PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

WordPress database error - Create Table

  1. Installed Gravity Forms, updated to 1.6.12 and got this error:

    WordPress database 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 '(8) )' at line 12]
    CREATE TABLE wp_simple_feed_stats ( id mediumint(10) unsigned NOT NULL AUTO_INCREMENT, logtime varchar(200) NOT NULL default '', request varchar(200) NOT NULL default '', referer varchar(200) NOT NULL default '', type varchar(200) NOT NULL default '', qstring varchar(200) NOT NULL default '', address varchar(200) NOT NULL default '', tracking varchar(200) NOT NULL default '', agent varchar(200) NOT NULL default '', PRIMARY KEY (id), cur_timestamp TIMESTAMP(8) )

    Posted 11 years ago on Friday April 5, 2013 | Permalink
  2. This table "wp_simple_feed_stats" is not part of Gravity Forms. You will need to check with the author of that plugin for support.

    http://wordpress.org/extend/plugins/simple-feed-stats/
    http://wordpress.org/support/topic/broken-database-error?replies=9

    Posted 11 years ago on Wednesday April 10, 2013 | Permalink