Comment on 2:59am.
Thanks a million for your instructions, once I was prepared i changed my WP table prefix in 3 minutes start to finish.
Pingback on 3:29am.
[…] It took a while but I eventually found instructions at the Pi in the Sky Blog. […]
Comment on 2:39pm.
It’s don’t works for WordPress 2.2.1: in this version you need also copy string from field ‘xx_user_roles’ from “clean” installation of WP (with needed prefix) to your working installation of WP.
Comment on 3:24pm.
I have not tried this method with 2.2.1 yet, when I update, I’ll check and update this information too.
Edit: you seem to have misunderstood the method I describe. I explain that you need to change the prefix of some option names too. You don’t need to copy xx_user_roles from a clean WP installation, you can keep your current user roles just changing the prefix of the already existing option. I’m sure that it will be the same in 2.2.1.
Comment on 3:40am.
thanks for this tip! Just altered my prefix and couldn’t log in - this saved me from pulling out some hair
Comment on 3:40pm.
I developed for BlogSecurity.org a plugin which does exactly what you covered with your post here. I got the post after some researches( after it initially didn’t work). And you saved me some time as I had normally would have to check all values within wp_tables for it. Anyway I would like to mention that it would be better to change xx_user_roles….and so on to xxuser_roles as, as well the _ can be a prefix for the table and isn’t needed( Or Am I on the wrong track?). And can you maybe tell me when the xx_user_level record is generated, as I couldn’t find it while working on the Plugin, is it maybe only created if your blog accepts User signups or multiple authors?
Comment on 8:36pm.
You’re not in the wrong track; the underscore usage slipped accidentally. I’ve edited the article to reflect that the underscore is not part of the option names, but of the prefix.
I thought of making a plugin, but honestly I am too lazy ^_^
Related to xx_user_level, I am not sure. I’d say it’s set when an user is first edited (as opposed to created). Look into ‘wp-includes/user.php’ to see some usage.
Comment on 5:09pm.
I have added a bug to remove the column names using the $table_prefix.
Comment on 8:56am.
That’s a sane decision, it’s a change that was needed for a long time.
Comment on 8:00pm.
sencillamente genial, muchas gracias por una exposición tan sencilla y clara de un problema que nos ha dado muchos quebraderos de cabeza.
Pingback on 2:34pm.
[…] Har lagt ned lite tid nu på att förstå varför det ska vara så klurigt att ändra prefix på databastabellerna för en befintlig Wordpress-installation. Att ändra prefixet i tabellnamnet och i inställningsfilen wp-config.php skulle räcka trodde jag, men icke. Det fungerar för att siten ska se bra ut men det går inte att logga in som administratör. För detta måste man även ändra några inställningar i tabellerna [ev. prefix]_options och [ev.prefix]_usermeta. Läs vad som behöver ändras hos Pi in the Sky. […]
Comment on 11:15am.
Thanks! You saved me a lot of work!
Comment on 9:52pm.
Great! Just a little detail to make me crazy. Thanks a lot for your info. Save my day
Best regards from Brazil
Comment on 7:54am.
I had my blog up and running but made the stupid, stupid mistake of going into settings and I changing the extension (”computer”) to “tech”. Once I realised it didn’t work, I went back and renamed the site extension to “computer” but my site is being directed to “tech” My front page page is showing up but without the theme (although the site says the theme is installed). When I click on a page, I get the 404 message.
Is my problem in the MySQL datbase? If so, how do I fix it? I am in big trouble because I need this site up and running in about 18 hours time.
Any help would be appreciated. It goes without saying that I am an idiot for changing the file name.
Thanks in advance.
Comment on 7:10pm.
I don’t know what you mean by “changing the extension” as it has been more than two years since I dwelled in the depths of wordpress. However I’d say that your problem is in the options table. Log into your database using phpmyadmin or whatever you have, and look there. Good luck.
Comment on 12:33am.
Thanks for this, it set me in the right direction.
Comment on 5:02am.
Thank you. Not sure what I did exactly but I changed some wp_ values to the new values and it worked. Thanks.
Comment on 1:56pm.
Hello Pi. I have just done this for my wordpress and i have the same problem by now. But another problem is that i want to change the wp_user_roles in my wp_option but i can’t find this! I mean i can’t see something like this under the option_name column. I have done the other changes that you say above but i am still getting the same message and cannot login.
Can you help me with this?
Comment on 5:53pm.
The article was aimed at the 2.x versions of Wordpress. You’re probably using a 3.3.x version which will probably have other extra needs. Search in forums and look at the database structure to see if you can find more clues. Sorry I can’t be of more help.
Comments can contain some xhtml. Names and emails are required (emails aren't displayed), url's are optional.