The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Server to Server Migration
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. |
#2
|
|||
|
|||
Right click on the error page and choose show page source. Copy & paste the error message here.
|
#3
|
|||
|
|||
<!--
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 : --> |
#4
|
|||
|
|||
Have you tried repairing your db?
|
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
Did you install the files of the same vBulletin version on the new server/localhost?
Was the restore successful without any warnings? |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
Documentation on server is move is at: Moving Servers
|
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|