• cell

    (@cell)


    I am installing WP 1.01 on a commercial hosting running mysql.
    These errors shows up, but the installation seems to works out and i get my login password and can login normally.
    I wonder if this is common, and if its safe to use the WP installation?
    The errors are as the following:
    ==========================================
    SQL/DB Error:
    [You have an error in your SQL syntax 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 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 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 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 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 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)
    =============================================
    is this normal? how is it for the long run?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hella

    (@hella)

    Yes, this happens in 1.01. It’s fixed in the newer versions (1.2 >)

    jitpal

    (@jitpal)

    Hello. Yeah, I am gettin the same problem using version 1.0.2. I thought I would try one of the nightly builds but those don’t extract from their archives correctly. I have no idea what I am doing wrong. The Install goes perfectly. I have deleted my MySQL database and the Install files multiple times and re-installed, re-setup. Still the same error. I am really anxious to use WordPress but I do not know how to if it does not work. Thanks -Jitpal

    jitpal

    (@jitpal)

    Hello. I guess the problem was cosmetic. The thing is, in IE it doesn’t work but in Firefox it is working. I checked if my IE was showing a cached version but it was not. This is bizarre. Thanks -Jitpal

    Sushubh

    (@sushubh)

    its called SushubhEffect or so I have been told.
    if the blog’s running fine, there is nothing to be afraid off. 🙂

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL errors on install. Is this normal?’ is closed to new replies.