Moved mysql database and site files, not working

[Femtos]

Hi, I recently moved my vbulletin 3.0.8 forums from one host to another. I backed up the mysql database in phpmysql and restored it in full in phpmysql on my new host. I then uploaded all the other site files, entered in the new config.php details and tried accessing the restored forum. Sadly, I received two errors that make the forum unfunctional.



Warning: array_keys(): The first argument should be an array in /includes/functions.php on line 3090



Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3090





Are the errors I get. On line 3090 of my includes/functions.php, I have:

 foreach(array_keys($forumcache) AS $forumid)

So $forumcache doesnt seem to be working.



I installed a lot of hacks including vbfeedback, vbjournal, and vbgarage although I don't see why it wouldnt work if I transfered every single thing that vbulletin uses (database and site files). Is there something I missed? Please help.

[Marco van Herwaarden]

Are you very sure the backup was complete and not corrupted?

[Femtos]

Yes I just did another full copy/rewrite and the errors persist.

Perhaps it was the way in which I backed up the database? I backed up using

"Use hexadecimal for binary fields" and selecting compatibility for Mysql40 because the host we were moving to had a different version of mysql that could not support latin1 charset. Could that be the reason why?

[Marco van Herwaarden]

What MySQL version is on the old & new server?

Could you also please check the backup file with an editor end check that the last few lines contain entries for the 'word' table?

PS What is the size of the backupfile?

[Femtos]

old server: MySQL 4.1.13a-Debian_2-log

new server: MySQL 4.0.25-standard

The backup file's last line is INSERT INTO `word` VALUES (14778, 'consulting');

The size of the backup file is 213 megabytes. Mostly due to vbGarage's pictures being stored in the database. I managed to restore it through the host's help.

[Marco van Herwaarden]

Try creating a new backup, but don't select "Use hexadecimal for binary fields".

PS If you have SSH/Telnet access, better use that since it is much mor reliable.