njgd

Resolved.

Got it resolved. Instead of placing short code in the text widget, I had to use Rotator widget in the sidebar. Thought it’d show the image in there, but looks like image is shown only in the page and not on sidebar.
Good plugin. Liked the functionality it provides.

This might help https://www.ads-software.com/support/topic/error-the-http-response-test-get-a-false-http-status-302

Figured the answer. To start with I was looking at the wrong DB and thinking that tables were not renamed by the plugin. They were.

Basically ‘Change DB Prefix’ seems to be a badly written plugin.

Cause –
It was able to rename tables but somehow it appears to have added another ‘_’ to the new prefix. And hence it could not rename the field values in <prefix>_usermeta table.

Funnily enough the original prefix given for the plugin itself was wrong, in the sense there were no tables with the given ‘original’ prefix! So the plugin went and created another duplicate bunch of tables.

Basically db automicity was not maintained by this plugin. Makes me wonder how does one miss such basic principle of db mgmt and release a plugin.

Solution –
After analyzing the issue with ever helpful Bluehost tech support, just dropped new tables and modified db_prefix in wp-config.php back to original value. This solved the problem.

WordPress version being used is 3.7.1

Some more info –
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 myPHP 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!