Moving Forum To New Server

[CorneliusWilson]

I moved my forum to a new server and installed it. I then got my host to import the SQL file so I can continue to have my 6600+ registered members, posts, etc.

In the admin home and main page of fourums I get a Warning: Division by zero in [path]/global.php(612) : eval()'d code on line 1085 message and database error and this message inside a box:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post ON (post.postid = moderation.primaryid)
WHERE moderation.type = 'reply';
MySQL Error : Unknown column 'moderation.primaryid' in 'on clause'
Error Number : 1054
Request Date : Wednesday, August 6th 2008 @ 08:18:27 AM
Error Date : Wednesday, August 6th 2008 @ 08:18:31 AM
Script : http://www.website.com/admincp/index.php?do=home
Referrer : http://www.website.com/admincp/index.php?do=nav
IP Address : 75.137.171.108
Username : CorneliusWilson
Classname : vb_database
MySQL Version : 5.0.51a-community

How do I fix this??

[Steve Machol]

1. This error is from a plugin you've installed. You need to disable each of your plugins then turn one at a time to see which one is causing this.

If you cannot log into the Admin CP then to disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

This will disable all hooks and allow you to log in properly with no hooks running.

http://www.vbulletin.com/docs/html/disable_plugins

2. It looks like you uploaded the vB 3.7.x files and did not upgrade.

[CorneliusWilson]

Yes, I did a clean installation. Was I supposed to copy files from my old server and transfer them to new?

I disabled all plugins and have same error.

[Steve Machol]

You cannot get that error with a clean install. Plus if you have plugins, then this was not a clean install.

Please explain.

[CorneliusWilson]

I transferred servers. I uploaded new vbulletin files. I then got the new hosting provider to upload SQL backup file to database (this is the file I downloaded from old server).

Maybe I should delete plugins.

[Steve Machol]

Then it appears post #2 is still applicable.

[CorneliusWilson]

So what I should do to fix the problem?

Want me to try and get old files from server, upload them to new server, then perform upgrade of forums?

[Steve Machol]

Follow the steps in #1 and answer the question in #2.

[CorneliusWilson]

I disabled all plugins from admincp.

This was a clean installaton, not an upgrade.

[Steve Machol]

Then please reread post #4. None of this is possible with a fresh install. We can't help much without accurate info.

[CorneliusWilson]

Ok I will attempt to get old files from server and then upload them to the new server and run upgrade. Thanks

[CorneliusWilson]

Ok now I am on the new server. I transfer all old files to the new server. Then I uploaded the new vbulletin files and ran the upgrade.

The upgrade page works. I click next step (1/6). It stops at
Creating hvquestion table

and gives database error.

Database error in vBulletin 3.6.8:
Invalid SQL:
INSERT INTO upgradelog(script, steptitle, step, startat, perpage, dateline)
VALUES ('upgrade_370b2.php', 'Table Creations', 1, 0, 0, 1219074251);
MySQL Error : Table 'profi18_forum.upgradelog' doesn't exist
Error Number : 1146

[Steve Machol]

It looks like when you transferred this database, it was not complete. Look at the db. What is the name of the last table in it?

[CorneliusWilson]

visitormessage_hash

[Steve Machol]

Your database is not complete. You will need to make a new backup and restore that.

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

If you don't have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

[Zorinea]

I used this: http://www.ozerov.de/bigdump.php

[CorneliusWilson]

Thanks. The upgrade works now. I do have one error on the top of every page.

Warning: Division by zero in [path]/global.php(612) : eval()'d code on line 1085


What is that?

[Steve Machol]

This error is from a plugin you've installed. You need to disable each of your plugins then turn one at a time to see which one is causing this.

If you cannot log into the Admin CP then to disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

This will disable all hooks and allow you to log in properly with no hooks running.

http://www.vbulletin.com/docs/html/disable_plugins