Resolution to: ALTER TABLE `phpwcms_subscription` error
Posted: Wed 28. Feb 2007, 17:29
To those who're getting this error while upgrading:
Finish the upgrade and run the following sql in phpMyAdmin:
The quotes surrounding CURRENT_TIMESTAMP are missing in the former statement.
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;Code: Select all
ALTER TABLE `phpwcms_subscription` ADD `subscription_tstamp` TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP' AFTER `subscription_lang` ;