On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • 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