WordPress.org

Ready to get started?Download WordPress

Forums

MySQL error: ALTER TABLE fails, WP doesn't notice (2 posts)

  1. skjaeve
    Member
    Posted 7 years ago #

    I was upgrading to 2.1.2 when I got a heap of MySQL errors from upgrade.php:

    WordPress database error: [ALTER command denied to user 'aasmunds'@'localhost' for table 'wp_categories']
    ALTER TABLE wp_categories ADD COLUMN link_count bigint(20) NOT NULL default '0'

    WordPress database error: [ALTER command denied to user 'aasmunds'@'localhost' for table 'wp_categories']
    ALTER TABLE wp_categories ADD COLUMN posts_private tinyint(1) NOT NULL default '0'

    WordPress database error: [ALTER command denied to user 'aasmunds'@'localhost' for table 'wp_categories']
    ALTER TABLE wp_categories ADD COLUMN links_private tinyint(1) NOT NULL default '0'

    And a bunch of secondary errors refering to nonexistent columns.

    Now, this is clearly an error in my user's MySQL privileges, has nothing to do with WordPress itself, and it should be trivial to fix by nagging my host a little.

    However, after three pages of error messages, WordPress still tells me:

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

    It would be very nice if WordPress would detect that something went wrong with MySQL and not say "All is well", since all is clearly not well if I try to ignore these errors and carry on as usual.

  2. MichaelH
    Member
    Posted 7 years ago #

    You are correct that you must grant more privileges to you database user.

    That's also a good point about the "All is well" message. Maybe that is a candidate for a bug ticket at WordPress Trac. You can use your forum login/password to login there and report a bug.

Topic Closed

This topic has been closed to new replies.

About this Topic