Cannot get old forum to work again

محروم.كوم · #1 02-08-2010, 04:10 PM

Hello

I am trying to restore a forum which was taken down about a year and a half ago and was working properly at the time.

I am now trying to restore it and not having much luck as I can't seem to restore the database.

If I restore the database through MySQL Administrator it gets as far as the attachments table and then I get lots of errors about queries not being valid and then no database selected for the remainder (probably caused by the first error). I believe thiis is to do with the encoding type and the binary data which is being wrongly interpreted by MSQL Administrator.

Using MySQL on the command line does appear to successfully import the entire database only giving a single warning about a duplicate key but when I try to visit the forum I get the error below.

I have already tried repairing and optimising the tables and have copied the tools.php into both the admin and install dirs and when I try to run tools.php it still gives me the same error (which tells me to run tools.php) so I'm a bit stuck!

I've also tried toggling mysql/mysqli.
If I put the wrong username and password into config.php then I just get a blank screen rather than the error.
I am using the latest version of MySQL and PHP which will be newer than what the site was originally running. Could this have caused the problem?

All the tables appear to be intact with readable data in them and were imported as latin1 which was what the original database was using.

Both the original and the new server are windows servers running IIS with PHP extensions.
The new server successfully runs other PHP and mysql sites including a moodle site and everything works ok.
I do get an internal server error if I try to go to /install/install.php or upgrade.php though???

Please can someone suggest anything else I can try or how I can fix this?

Thanks
Robin

Code:
vBulletin datastore error caused by one or more of the following:
You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.

The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.

Fatal error: vBulletin datastore cache incomplete or corrupt in \includes\init.php on line 210 __DEFINE_LIKE_SHARE__