Resolution to: ALTER TABLE `phpwcms_subscription` error

[alchemistkevin]

To those who're getting this error while upgrading:

Code: Select all

ERROR: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP' at line 1 -> ALTER TABLE `phpwcms_subscription` ADD `subscription_tstamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Finish the upgrade and run the following sql in phpMyAdmin:

Code: Select all

ALTER TABLE `phpwcms_subscription` ADD `subscription_tstamp` TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP' AFTER `subscription_lang` ;

The quotes surrounding CURRENT_TIMESTAMP are missing in the former statement.