WordPress.org

Ready to get started?Download WordPress

Forums

Problems with upgrade: 7.2 to 1.01 (3 posts)

  1. griffey
    Member
    Posted 10 years ago #

    When I run the upgrade.php script, I'm getting nothing but errors...here they are, for your pleasure.
    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)
    Now, I know practically nothing about SQL. I could edit the PHP if necessary, but can't see what needs to be done. I just wanna get my database happy, and my old posts in my new 1.01.
    Anyone? Help?
    Jason

  2. OperaManiac
    Member
    Posted 10 years ago #

    just a stupid question from me...
    have u matched the table prefix in the config file from the old installation?

  3. griffey
    Member
    Posted 10 years ago #

    Well, since the instructions didn't talk about that at all....do you mean the wp-config.php file in the new installation? I didn't change the prefix, no...the old prefix was b2. What I don't want to happen is that the tables get buggered when I do the upgrade (I've got a backup, but not enough knowledge to be comfortable that I could handle it if it breaks in a major way).
    That's an idea, though. I'm looking at the config now, and see the line. If I change that, will it overwrite the old tables when I do the install?
    Jason

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.