Server to Server Migration

[Exeter]

I am having trouble moving my forum from one server to another. here is the process:

1) Backup DB using Mysql admin
2) restore DB on new server
3) Copy the files to new webserver directory
4) update config.php to use the new DB location

Now I am getting a DB error without any information when I access the admincp.
Disabling all hooks and using tools.php does not help.

What am I missing?

Thanks

I did not get any help on vbulletin.com.

[Marco van Herwaarden]

Right click on the error page and choose show page source. Copy & paste the error message here.

[Exeter]

<!--
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT styleid, dateline, title
FROM h_style
WHERE styleid = 2
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : Unknown column 'dateline' in 'field list'
Error Number : 1054
Request Date : Saturday, July 3rd 2010 @ 01:53:53 PM
Error Date : Saturday, July 3rd 2010 @ 01:53:54 PM
Script : http://localhost/admincp/index.php
Referrer :
IP Address : ::1
Username :
Classname : vB_Database
MySQL Version :
-->

[profanitytalker]

Have you tried repairing your db?

[Exeter]

Yes, I tried to repair the tables using tools.php; no luck

I still have the forum running on the original server. No problems there.

[Marco van Herwaarden]

Did you install the files of the same vBulletin version on the new server/localhost?

Was the restore successful without any warnings?

[Exeter]

I copied the files from the live server. I did not do a local install.
Is that required? In my original post I detailed everything I did.

If there is a process for migration, please let me know. I could not find any documentation for this.

Thanks for your help

[Marco van Herwaarden]

Documentation on server is move is at: Moving Servers (http://www.vbulletin.com/docs/html/moving_servers)

[Exeter]

Thanks, I followed these steps as indicated. No luck.

I also verified that the column 'dateline' is not present on my live server (the source that is working fine), and on a fresh install of VB 4.0.4.

this is getting annoying

[Marco van Herwaarden]

Please check if the config.php of the copied installation on your localhost is pointing to the correct database (the restored database) and with the correct table prefix.

[Exeter]

I checked all the seetings in config file. I beleive they are correct.

under the debugger I can see that the crash happens at
admincp/gloabl.php line 64

dateline is hard coded in that query, it's not in the DB

to make things interesting, the live serve also does not have that field defined in the DB
it still runs

more debugging work to do

[Marco van Herwaarden]

Line 64 of admincp/global.php in vBulletin version 3.8.4 is an empty line, so you have mixed up something.

Also on a quick scan of the file i can not find this query.

[KevinL]

Are you on 4.0.4 or 3.8.5? Because you say you are running both..

[Exeter]

I am runing 4.0.4
I upgraded the forum from 3.8.4 recently

Don't know why the error reads 3.8.4. It just does. When I search the files all of them are marked 4.0.4. The live version has CMS running, so it's 4.0.4.

In the 4.0.4 source code you can see the query being built at the line # I presented.

Something got screwed up somewhere. What was supposed to be an easy upgrade turned into 3 days of work. I ended up upgrading my forum. That killed the CMS data, which I had to rebuild manually. Now everything works. I still don't know what was wrong in the first place. My best guess is that the DB contains some remnant of 3.8.4 config. I will refrain from upgrading until the product is stabilized in the future.

Thanks to everyone who helped me. This forum is much more responsive than vb.com. I appreciate it.

[Marco van Herwaarden]

If the error message say 3.8.4, then the upgrade was not completed. This can also be the cause of the error. Please run upgrade.php again.

PS If this is not on your localhost, then create a new backup first.