WordPress.org

Support

Support » Installation » Installation Errors – SQL

Installation Errors – SQL

  • The first 2 steps are all successful, when I proceeded to step 3:
    Step 3
    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 ” at line 1] SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’55-0-default_post_status’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(55,’default_post_status’, 5, ‘publish’, ‘The default state of each new post’, 8, 20)
    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 ” at line 1] SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’56-0-default_comment_status’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(56,’default_comment_status’, 5, ‘open’, ‘The default state of comments for each new post’, 8, 20)
    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 ” at line 1] SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’57-0-default_ping_status’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(57,’default_ping_status’, 5, ‘open’, ‘The default ping state for each new post’, 8, 20)
    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 ” at line 1] SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’58-0-default_pingback_flag’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(58,’default_pingback_flag’, 5, ‘1’, ‘Whether the \’PingBack the URLs in this post\’ checkbox should be checked by default’, 8, 20)
    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 ” at line 1] SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’59-0-default_post_category’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(59,’default_post_category’, 7, ‘1’, ‘The default category for each new post’, 8, 20)
    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 ” at line 1] SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’83-0-default_post_edit_rows’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(83,’default_post_edit_rows’, 1, ‘9’, ‘The number of rows in the edit post form (min 3, max 100)’, 8, 5)
    ****************************************************************
    PHP Version 4.3.4
    Apache/1.3.29 (Unix)
    MySQL: 4.0.15
    pls let me know if any one of you guys encountered this and had a workwround…
    thanx a lot.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Not sure how many times I have to post a link to this but here goes again….
    http://wordpress.org/support/2/1995#post-5
    Is it that hard to search for an answer before posting a topic?

    Well, I hope the above response is not the typical style of response to be expected here. That did not need to be so nasty. 🙁
    In addition, the title of the quoted thread seems to have nothing to do with the problem referenced above. I would not have looked there for help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Installation Errors – SQL’ is closed to new replies.
Skip to toolbar