WordPress.org

1. mikefincher
   Member
   Posted 2 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
   moderator
   Posted 2 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 2 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
   moderator
   Posted 2 years ago #

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

Topic Closed

This topic has been closed to new replies.