Support » Installing WordPress » Error on WP 2.0.2 upgrade

  • Resolved breger


    I followed the instructions on upgrading from Wp 2.0 and all is OK except the following screen came up when I run upgrade.php –
    WordPress database error: [Incorrect table definition; There can only be one auto column and it must be defined as a key]
    ALTER TABLE wp_usermeta ADD COLUMN umeta_id bigint(20) NOT NULL auto_increment

    WordPress database error: [Key column ‘umeta_id’ doesn’t exist in table]
    ALTER TABLE wp_usermeta ADD PRIMARY KEY (umeta_id)

    Step 1
    There’s actually only one step. So if you see this, you’re done. Have fun!

    All seems OK and the site is working fine but has nayone any idea what this means and what I need to do to correct it? Thanks.
    The URL is

Viewing 2 replies - 1 through 2 (of 2 total)
  • I have now discovered that in categories only there is the following error –
    WordPress database 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 ‘AND comment_approved = ‘1” at line 1]
    SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = AND comment_approved = ‘1’

    It does not seem to affect pages though.

    Solved the problem. It was down to the Adhesive plugin which caused problems with the database, so I have now deactivated it and all OK.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error on WP 2.0.2 upgrade’ is closed to new replies.