Support » Fixing WordPress » Tdays build (17/02/04) upgrade error

  • Hi guys,
    Just ran upgrade.php and was presented with these errors:
    SQL/DB 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 ‘WHERE option_id = ’93” at line 1]
    SELECT * FROM WHERE option_id = ’93’
    SQL/DB 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 ‘(option_id, option_name, option_type, option_value, option_desc]
    INSERT INTO (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES (93, 1, ‘blog_charset’, ‘Y’, 3, ‘utf-8’, 20, 8, ‘your blog\’s charset (here\’s a list of possible charsets)’, 8)
    Are these anything tp be worried about?
    Thanks
    Karl

Viewing 4 replies - 1 through 4 (of 4 total)
  • replace the global statmenet with this
    global $wpdb, $tableusers, $tablecomments, $tableposts, $tableoptiongroups, $tableoptiongroup_options, $tableoptions;

    Thread Starter karlb

    (@karlb)

    Thanks Gamerz,
    I’ll give it a try 🙂
    Karl

    Same problem here. Do I use phpMyAdmin to fix this? If so, how?

    This error also occurs when doing a fresh install. However, just fixing the global statement doesn’t fix it – then it tries to put in a duplicate entry (at least in a fresh install). There’s two problems, really – first that the global statement is incorrect, and second that the option never gets put into an option group to begin with. And THEN, it doesn’t even bother putting it into the options group when it realizes it’s not there!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Tdays build (17/02/04) upgrade error’ is closed to new replies.