We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Koops Mailing List - Database Error

    • 20993
    • 37 Posts
    natedogg3304 Reply #1, 16 years, 5 months ago
    I get this error when trying to create the mail_subscribers table for Koops Mailing List:

    ALTER TABLE `mail_subscribers` CHANGE `date` `date` TIMESTAMP( 14 ) NOT NULL DEFAULT CURRENT_TIMESTAMP

MySQL said: Documentation
#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 'CURRENT_TIMESTAMP' at line 1


    I don’t know much about phpmyadmin and mysql, so I was hoping to get some help here.

    Thanks