Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Jul 2010, 06:21
Exeter Exeter is offline
 
Join Date: Mar 2009
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.
Reply With Quote
  #2  
Old 03 Jul 2010, 07:53
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Right click on the error page and choose show page source. Copy & paste the error message here.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #3  
Old 03 Jul 2010, 20:55
Exeter Exeter is offline
 
Join Date: Mar 2009
<!--
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 :
-->
Reply With Quote
  #4  
Old 04 Jul 2010, 00:12
profanitytalker's Avatar
profanitytalker profanitytalker is offline
 
Join Date: Nov 2006
Have you tried repairing your db?
Reply With Quote
  #5  
Old 04 Jul 2010, 03:44
Exeter Exeter is offline
 
Join Date: Mar 2009
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.
Reply With Quote
  #6  
Old 04 Jul 2010, 06:31
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Did you install the files of the same vBulletin version on the new server/localhost?

Was the restore successful without any warnings?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #7  
Old 04 Jul 2010, 18:36
Exeter Exeter is offline
 
Join Date: Mar 2009
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
Reply With Quote
  #8  
Old 04 Jul 2010, 22:59
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Documentation on server is move is at: Moving Servers
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #9  
Old 04 Jul 2010, 23:35
Exeter Exeter is offline
 
Join Date: Mar 2009
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
Reply With Quote
  #10  
Old 05 Jul 2010, 04:07
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #11  
Old 05 Jul 2010, 06:22
Exeter Exeter is offline
 
Join Date: Mar 2009
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
Reply With Quote
  #12  
Old 06 Jul 2010, 04:34
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #13  
Old 06 Jul 2010, 09:47
KevinL KevinL is offline
 
Join Date: Apr 2005
Are you on 4.0.4 or 3.8.5? Because you say you are running both..
Reply With Quote
  #14  
Old 08 Jul 2010, 02:34
Exeter Exeter is offline
 
Join Date: Mar 2009
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.
Reply With Quote
  #15  
Old 08 Jul 2010, 05:05
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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.
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:19.

Layout Options | Width: Wide Color: