Database migration required. After updating Pubvana files, run the following SQL statements against your database:
-- Drop slug column from all addon tables
ALTER TABLE plugins DROP COLUMN slug;
ALTER TABLE themes DROP COLUMN slug;
ALTER TABLE widgets DROP COLUMN slug;
-- Add description column to themes (if not present)
ALTER TABLE themes ADD COLUMN description VARCHAR(255) NULL AFTER name;
-- Change widget description from TEXT to VARCHAR(255)
ALTER TABLE widgets MODIFY COLUMN description VARCHAR(255) NULL;
-- Add disabled columns to all addon tables
ALTER TABLE plugins ADD COLUMN disabled TINYINT(1) NULL DEFAULT NULL AFTER is_active,
ADD COLUMN disabled_reason VARCHAR(255) NULL DEFAULT NULL AFTER disabled;
ALTER TABLE themes ADD COLUMN disabled TINYINT(1) NULL DEFAULT NULL AFTER is_active,
ADD COLUMN disabled_reason VARCHAR(255) NULL DEFAULT NULL AFTER disabled;
ALTER TABLE widgets ADD COLUMN disabled TINYINT(1) NULL DEFAULT NULL AFTER is_active,
ADD COLUMN disabled_reason VARCHAR(255) NULL DEFAULT NULL AFTER disabled;
-- Rename pv_safe to pv_safe
ALTER TABLE plugins CHANGE COLUMN pv_safe pv_safe TINYINT(1) UNSIGNED NULL DEFAULT NULL;
ALTER TABLE themes CHANGE COLUMN pv_safe pv_safe TINYINT(1) UNSIGNED NULL DEFAULT NULL;
ALTER TABLE widgets CHANGE COLUMN pv_safe pv_safe TINYINT(1) UNSIGNED NULL DEFAULT NULL;
-- Add author column to marketplace_licenses
ALTER TABLE marketplace_licenses ADD COLUMN author VARCHAR(100) NULL DEFAULT NULL AFTER product_name;
Crontab update required. The Pubvana Cron system has been replaced. Update your crontab:
* * * * * /path/to/php /path/to/pubvana/spark cron minute
0 */6 * * * /path/to/php /path/to/pubvana/spark cron quarterday
0 3 * * * /path/to/php /path/to/pubvana/spark cron daily
The old php spark posts:publish crontab entry still works but is now called automatically by cron minute. You can remove it.
Static page URLs changed. Pages are now served at /pages/your-slug instead of /your-slug. Update any internal links or bookmarks.