Support » Fixing WordPress » Error when saving Options: Miscellaneous

  • 1.2 alpha – 4/15 build
    I get the following error when saving the Options: Miscellaneous:
    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 ”,’mailserver_pass’,’default_category’)’ at line 1]
    SELECT wp1_options.option_id, option_name, option_type, option_value, option_admin_level FROM wp1_options WHERE option_name IN (‘default_post_edit_rows’,’blog_charset’,’use_smilies’,’use_balanceTags’,’advanced_edit’,’ping_sites’,’mailserver_url’, ‘mailserver_port’,mailserver_login’,’mailserver_pass’,’default_category’)
    Warning: Cannot modify header information – headers already sent by (output started at /home/randy/public_html/blog/wp-includes/wp-db.php:90) in /home/randy/public_html/blog/wp-admin/options.php on line 112

Viewing 7 replies - 1 through 7 (of 7 total)
  • The first thing I’d do is update your nightly (or download the latest CVS), because it corrects a number of errors visible on your front page (such as the comments and footer), as well as other backend stuff.

    I’m running the 4/15 nightly build. Unfortunately, I don’t understand how to use CVS, so will have to wait until someone posts a archive of the latest to the nightly build area here.

    Take a look at my posts in the ‘Options Mostly Done’ thread. There is a syntax error on line 48 of options-writing.php in the wp-admin folder. There is a single quote missing from in front of the mailserver_login value in the hidden form element called page_options.
    Insert the single quote and you should be fine. This error occurred in both the 04-15 and 04-18 nightlies.

    Ryan Boren


    WordPress Dev

    Matt fixed this in CVS just now.

    Thanks. I made the mod to options-writing.php and all is well. Will look for next nightly build.

    me too
    cvs is way over my head…

    Me too, I’ll just stick with my fix until the next nightly comes out. CVS ain’t my bag.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error when saving Options: Miscellaneous’ is closed to new replies.