WordPress.org

1. pcbeef
   Member
   Posted 3 years ago #

   I decided to give rc2 a go and foolishly did not backup my database.

   I had a table prefix initially but decided to change it to the default "wp_".

   I then changed all the tables accordingly and conducted the update.

   Everything seemed okay, until I tried visiting the admin page which resulted in
   "You do not have sufficient permissions to access this page."

   I then went into wp_options and changed all the rows which had referenced the old table prefix. I was then able to log into the admin page.

   However, when my posts do not have any categories or tags assigned to them. I also cannot access some features like the plugin browser installer or the update feature. It just gives me the error message

   "You do not have sufficient permissions to access this page."

   Does anybody know how to fix this issue?

2. MichaelH
   Volunteer
   Posted 3 years ago #

   Might consider doing a Tool->Export and then installing a new blog (which is as simple as putting a new $table_prefix in your wp-config.php file) then do the Tools->Import.

   Also consider these 3 problems you inflicted on yourself:
   1. No backup before upgrade
   2. Upgraded to version that is still in testing stages
   3. Changed names of database tables without proper backup

3. pcbeef
   Member
   Posted 3 years ago #

   Seems like my webhost does automatic db backups. I reverted to a previous state and conducted the upgrade again, this time worked fine. Thanks.

Topic Closed

This topic has been closed to new replies.