“更改数据库前缀”wordpress插件错误/问题：将所有HTTP流量重定向到/wp-admin/install.php

Question

I installed 'change db prefix' wordpress plugin (WordPress version being used is 3.7.1), which resulted in an error and has blocked all kind of http access to the site (domain as well as /wp-admin pages).

Got the following errors while installation - Changing value: mdv_user_roles in table mdv_options: Failed Changing values in table mdv_usermeta: Failed

This is what is happening now - Whether I try to log into my /wp-admin or just access domain directly I am redirected to /wp-admin/install.php (welcome screen to install WordPress) as if this is a new installation.

Findings - I logged into phpMyAdmin from cPanel and found that all tables have old prefix, which means none of the tables are changed to the new one. Makes sense, probably there was a db-rollback due to the db errors.

However, $table_prefix property in wp-config.php file was changed to new prefix. I changed it back to the old prefix and uploaded file to server.

I still get the same behavior though. Access to domain points back to /wp-admin/install.php file.

Anyone has come across this issue? Any help is greatly appreciated! Thanks.

Answer 1

1. Uninstall plugin or remove change db prefix plugin folder from wp-content/plugins.
2. Change $table_prefix to new prefix.
3. Go to phpmyadmin-> your db-> select each table and rename the table with your new prefix.

For more details refer this link- Change wordpress table prefix