
Originally Posted by
AlexT
Something is not quite right again, I've ran the line, the following message has appeared:
1064 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 ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE zen_testimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
The versions are:
PHP Version: 5.2.1 (Zend: 2.2.0)
Database: MySQL 5.0.27-standard
Thank you,
Alex
Try this one:
Code:
ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `testimonials_html_text` ;