What version of WordPress were you using prior to the hack?
When you carried out the restore, did you re-upload WP 3.1.1? Or did you just grab a copy of the latest version of WordPress? If it’s the latter, your database may not be correct for the core files that you are using.
Thread Starter
Richard
(@richard1966)
I did a clean install from 3.1. then updated to the latest release with WP. I then imported the database in, which now you have said that, I think is the root of the problem.
Having said that I did the same procedure with another hacked site and all is fine so I’m confussed. (nothing new for me)
Thread Starter
Richard
(@richard1966)
Is there something in the database I can change or has the table structure change?
The table structure will have changed. Do you still have the original 3.1.1 database backup?
Thread Starter
Richard
(@richard1966)
Fixed it.
It was an incompatibility between database versions.
Basically I backed up the database. Then created a database backup minus the wp-options table.
Next I dropped all the tables went into the site and faced with the new install page. Filled in the details and logged in.
At this point I imported all the tables minus wp-options to the new database replacing those tables.
Downside you have to reactivate settings and plugins but now all is working. Thanks for the inspiration from http://www.vexentricity.com/?p=424 who showed the way.
Hope this helps someone should it happen again. 🙂