WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] WP 2.3 Upgrade problem (4 posts)

  1. mikefincher
    Member
    Posted 6 years ago #

    When I ran the WP2.3 database upgrade, I got the following:

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    ALTER TABLE wp_posts CHANGE COLUMN post_status post_status enum
    ('publish','draft','private','static','object','attachment','inherit','future', 'pending') NOT NULL default 'publish'

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    ALTER TABLE wp_posts CHANGE COLUMN post_type post_type varchar(20) NOT NULL default 'post'

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    ALTER TABLE wp_posts ALTER COLUMN post_type SET DEFAULT 'post'

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    ALTER TABLE wp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID)

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    ALTER TABLE wp_users ADD KEY user_nicename (user_nicename)

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    DROP TABLE IF EXISTS wp_categories

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    DROP TABLE IF EXISTS wp_link2cat

    WordPress database error: [Access denied for user 'yscr_bbKh-X'@'localhost' to database 'getaclue']
    DROP TABLE IF EXISTS wp_post2cat

    It seems that my database was not properly upgraded...is there a database description for WP2.3 that I can use to check against?

  2. MichaelH
    Member
    Posted 6 years ago #

    That probably means the database user (DB_USER) defined in your wp-config.php file does not have the privileges necessary to add/delete/alter tables.

    Installing WordPress, Create the database and user covers assigning privileges.

  3. mission
    Member
    Posted 6 years ago #

    Hi !
    After updating 2.2 to 2.3 I 've got the following message in the sidebar:

    WordPress database error: [Table 'mission.wp_categories' doesn't exist]
    SELECT COUNT(*) FROM wp_categories

    Im not a big batabase expert, I understand what does it mean, but I dont know what to do with it..

  4. MichaelH
    Member
    Posted 6 years ago #

    @mission -- please review this:
    http://wordpress.org/support/topic/135564?replies=8

Topic Closed

This topic has been closed to new replies.

About this Topic