Broken, database error

  • Resolved lookslikepat

    (@lookslikepat)


    13 years, 4 months ago

    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/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Jeff Starr

    (@specialk)

    13 years, 4 months ago

    Hi lookslikepat, thanks for this feedback. Do you happen to know which version of PHP/MySQL you’re running? Thanks.

    Thread Starter lookslikepat

    (@lookslikepat)

    13 years, 4 months ago

    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

    (@lookslikepat)

    13 years, 4 months ago

    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

    (@lookslikepat)

    13 years, 4 months ago

    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

    (@specialk)

    13 years, 4 months ago

    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

    (@lookslikepat)

    13 years, 4 months ago

    Don’t mention it, thank You for an (I’m assumimg) awesome plugin! 🙂

    Anonymous User 7324279

    (@anonymized-7324279)

    13 years, 4 months ago

    [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\tid mediumint(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\t\tlogtime varchar(200) NOT NULL default ”,\n\t\t\trequest varchar(200) NOT NULL default ”,\n\t\t\treferer varchar(200) NOT NULL default ”,\n\t\t\ttype varchar(200) NOT NULL default ”,\n\t\t\tqstring varchar(200) NOT NULL default ”,\n\t\t\taddress varchar(200) NOT NULL default ”,\n\t\t\ttracking varchar(200) NOT NULL default ”,\n\t\t\tagent 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

    (@specialk)

    13 years, 4 months ago

    Thanks for that John. Can you provide PHP/MySQL version as well? It would help.

    Ryan Bayne

    (@ryan-bayne)

    12 years, 10 months ago

    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

    (@specialk)

    12 years, 10 months ago

    Thanks for the feedback Ryan.

    Plugin Author Jeff Starr

    (@specialk)

    12 years, 9 months ago

    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.