Title: Broken, database error
Last modified: August 20, 2016

---

# Broken, database error

 *  Resolved [lookslikepat](https://wordpress.org/support/users/lookslikepat/)
 * (@lookslikepat)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/)
 * When installing I get this error message (with DEBUG turned on):
 * 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) ) On the settings page I get this:
 * WordPress database error: [Table ‘MYDBNAME.wp_simple_feed_stats’ doesn’t exist]
   
   SELECT * FROM wp_simple_feed_stats ORDER BY id DESC LIMIT 0, 3
 * This breaks the feed because the error message is in the feed too.
 * [http://wordpress.org/extend/plugins/simple-feed-stats/](http://wordpress.org/extend/plugins/simple-feed-stats/)

Viewing 11 replies - 1 through 11 (of 11 total)

 *  Plugin Author [Jeff Starr](https://wordpress.org/support/users/specialk/)
 * (@specialk)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251925)
 * Hi lookslikepat, thanks for this feedback. Do you happen to know which version
   of PHP/MySQL you’re running? Thanks.
 *  Thread Starter [lookslikepat](https://wordpress.org/support/users/lookslikepat/)
 * (@lookslikepat)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251926)
 * Sorry I forgot to write those down 🙂
 * PHP v 5.4.8
    MYSQL v 5.1.62 ( mysqlnd/mysqli v 5.0.10 )
 *  Thread Starter [lookslikepat](https://wordpress.org/support/users/lookslikepat/)
 * (@lookslikepat)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251927)
 * The MySQL version I entered wan’t all that correct 😛
    My PHP MySQL library version
   is 5.5.24, the MySQL server version is 5.1.62.
 *  Thread Starter [lookslikepat](https://wordpress.org/support/users/lookslikepat/)
 * (@lookslikepat)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251929)
 * I screwed up, forget those versions all together. I was trying this plugin on
   my local machine, not the online server.
    My local installs are as follows: `
   PHP 5.4.6-1ubuntu1.1 (cli) (built: Nov 15 2012 01:23:47)` `mysql Ver 14.14 Distrib
   5.5.28, for debian-linux-gnu (i686) using readline 6.2`
 *  Plugin Author [Jeff Starr](https://wordpress.org/support/users/specialk/)
 * (@specialk)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251930)
 * Will try to get it sorted for the next update. From the error it looks like the
   database was not created due to a syntax error (or something). It’s been working
   great on different setups, but apparently something happened. I’ll look into 
   it for the next update. Thank you for the infos!
 *  Thread Starter [lookslikepat](https://wordpress.org/support/users/lookslikepat/)
 * (@lookslikepat)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251931)
 * Don’t mention it, thank You for an (I’m assumimg) awesome plugin! 🙂
 *  Anonymous User 7324279
 * (@anonymized-7324279)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251932)
 * [Sun Dec 16 12:09:04 2012] [error] [client 98.251.96.128] 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)\n\t\t)’ at
   line 12 for query CREATE TABLE wp_simple_feed_stats (\n\t\t\t`id` mediumint(10)
   unsigned NOT NULL AUTO_INCREMENT,\n\t\t\t`logtime` varchar(200) NOT NULL default”,\
   n\t\t\t`request` varchar(200) NOT NULL default ”,\n\t\t\t`referer` varchar(200)
   NOT NULL default ”,\n\t\t\t`type` varchar(200) NOT NULL default ”,\n\t\t\t`qstring`
   varchar(200) NOT NULL default ”,\n\t\t\t`address` varchar(200) NOT NULL default”,\
   n\t\t\t`tracking` varchar(200) NOT NULL default ”,\n\t\t\t`agent` varchar(200)
   NOT NULL default ”,\n\t\t\tPRIMARY KEY (`id`),\n\t\t\tcur_timestamp TIMESTAMP(
   8)\n\t\t) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’),
   require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’),
   call_user_func_array, sfs_create_table, dbDelta
 * doh!
 *  Plugin Author [Jeff Starr](https://wordpress.org/support/users/specialk/)
 * (@specialk)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251933)
 * Thanks for that John. Can you provide PHP/MySQL version as well? It would help.
 *  [Ryan Bayne](https://wordpress.org/support/users/ryan-bayne/)
 * (@ryan-bayne)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251936)
 * I’m using the latest version and seeing these errors in my log. Not got time 
   to work on the syntax myself so I’ll disable the plugin for now because the error
   is constant.
 *  Plugin Author [Jeff Starr](https://wordpress.org/support/users/specialk/)
 * (@specialk)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251937)
 * Thanks for the feedback Ryan.
 *  Plugin Author [Jeff Starr](https://wordpress.org/support/users/specialk/)
 * (@specialk)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251938)
 * Just to follow up with this.. these PHP errors should be fixed in the latest 
   version (20130715). Please post anew if they persist, or if there are any other
   issues. Thanks!

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Broken, database error’ is closed to new replies.

 * ![](https://ps.w.org/simple-feed-stats/assets/icon-256x256.png?rev=1474990)
 * [Simple Statistics for Feeds](https://wordpress.org/plugins/simple-feed-stats/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-feed-stats/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-feed-stats/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-feed-stats/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-feed-stats/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-feed-stats/reviews/)

 * 11 replies
 * 4 participants
 * Last reply from: [Jeff Starr](https://wordpress.org/support/users/specialk/)
 * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/broken-database-error/#post-3251938)
 * Status: resolved