vb.org Archive - Moved mysql database and site files, not working

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Moved mysql database and site files, not working (https://vborg.vbsupport.ru/showthread.php?t=96459)

Femtos

09-17-2005 07:13 PM

Moved mysql database and site files, not working

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:

Code:



 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

09-17-2005 07:24 PM

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

Femtos

09-17-2005 08:50 PM

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

09-17-2005 09:04 PM

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

09-17-2005 09:29 PM

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

09-18-2005 04:45 AM

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.

All times are GMT. The time now is 02:39 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01077 seconds Memory Usage 1,717KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: