Cannot change server - Please help!

[livethedream]

Okay, this may be pretty drawn out so I will only post a summary and if any kind member takes up the gauntlet and asks questions I'll answer and explain further

(Saves me typing out a novel for nothing :) )

Right, we set up a forum etc. on a shared server and now want to move it to a dedicated server. We have a server setup and ready to go.

The sql database is currently held on our hosts 'sql server' and is different to the shared server that we have our website on.

I ftp'd the htdocs down from shared server.

I backed up the sql database using mysql administrator on my pc.

On the dedicated server (DS) I setup up a database and a user etc.
I also set up a user account and gave it a website.

I ftp'd the site up to this users htdocs and it seems fine.
I restored with mysql administrator the backup from the Shared server (SS) to the DS.

If I run http://<ip-address>/info.php it returns a page of info.
If I run http://<ip-address>/index.php it returns the website on the SS (config.php unchanged at this point)

From the above I take it that the website bit is in the right place and functioning.

When I edit config.php to point to the DS database I get a VB error page that says Databse error...The <domain> database has encountered an error.

I have checked with putty that there are indeed files pertaining to a sql database, I have even managed to issue a show tables sql command through my sql administrator and got back a list of tables which makes me think that the database is ok.

Any help or pointers that you can give will be gratefully received! ! :):confused:

[R1lover]

What version of mysql if on the old server?
What version of mysql is on the new server?

What command did you use to back up this old database in ssh?

This sometimes can make a difference and cause issues.

[livethedream]

I'll have to check the mysql versions but what I can say for now is that I did not use ssh to back up the sql d/b. I used mysql administrator from my PC.

We don't have ssh access to the server that has the D/B on it, the shared server hosting company has it on their sql server.

HTH

Oh, and thanks VERY much for the quick reply and interest :)

[R1lover]

Was this on a windows box?

if it was on a linux box have your hosting company run this to back up your database and then have them provide you a link to download it.

You could fight for hours trying to get it working when you backup with one program and restore with another.

Check our this thread for some great information.

http://www.vbulletin.com/forum/showthread.php?t=242922&highlight=moving+servers

[livethedream]

What version of mysql if on the old server?
What version of mysql is on the new server?

What command did you use to back up this old database in ssh?

This sometimes can make a difference and cause issues.


5.0.22 via tcp/ip on the new server
5.0.22-log via tcp/ip on the current site

--------------- Added at 15:37 ---------------

Was this on a windows box?

if it was on a linux box have your hosting company run this to back up your database and then have them provide you a link to download it.

You could fight for hours trying to get it working when you backup with one program and restore with another.

Check our this thread for some great information.

http://www.vbulletin.com/forum/showthread.php?t=242922&highlight=moving+servers


Both Linux...

Backed up and restored with the same program - mysql administrator...

Thanx

--------------- Added at 17:44 ---------------

Hi,

The tools listed for backing up the database seem to be scripts that need copying to the server that hosts the database files. Is this the case?

If it is, I can't use them as I have said previously that I don't have ssh access to that server.


Can anyone help as this problem means that we can't migrate and currently are paying for two hosts! :eek:

[snakes1100]

Post the "COMPLETE" DB error msg after you change the config.php file.

[livethedream]

Hi and thanks for the reply...

The page comes up with a 'V' logo top left and this message with it...
---Quote---

Database error
The <domain name> database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the xxx.xxx.xxx.xxx home page, then try to open another page.
Click the Back button to try another link.

The xxx.xxx.xxx.xxx forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
---End Quote---

The domain mentioned in the error is just a domain on the server. The IP address in the error is the correct ip for this server.

[Paul M]

You need to view the page source and post that - the error is not contained in the visible text.

[livethedream]

oops! Yes I can see how that might help



Between the dashed line is the source (In red are bits I've changed for obvious reasons)

-------------------------------------------------



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>domainnameonnewserver Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.domainame.co.uk/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The domainnameonnewserver database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">newserveriaddress</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The newserveripaddress forum technical staff have been notified of the error, though you may <a href="mailto:emailaddress@admin.co.uk">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>


<!--
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic,
connections.start,user.usergroupid, user.displaygroupid, user.options, user.username,
groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM flashchat_connections as connections
LEFT JOIN flashchat_rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN user as user ON(connections.userid = user.userid)
LEFT JOIN usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start;

MySQL Error : Table 'databasename,sameonbothservers.flashchat_connecti ons' doesn't exist
Error Number : 1146
Date : Sunday, October 7th 2007 @ 09:11:45 PM
Script : http://newserveripaddress/ (http://newserveripaddress/)
Referrer :
IP Address : myclientpcipaddress
Username : Unregistered
Classname : vB_Database
-->


</body>
</html>



----------------------------------------

Two things, the entry in green is the actual domainname that is currently pointing to the old server and will point to the new server when we fix it, I can't imagine where this error is getting it from, the config.php does not mention it.



Also, the stuff at the bottom appears to be from flashchat, I can't see why that would be here wither.



Thanks for the help

[R1lover]

Disable flashchat and try it again...

If this works then re-install flashchat if you must have it.

--------------- Added at 16:19 ---------------

This is because it's still in the settings somewhere that the domain is the old domain, probably the admin panel under vBulletin Settings.

[livethedream]

I appreciate what you say but how is flashchat causing the problem? It works fine on the current setup and all backups were taken after flashchat was installed.

Can you explain further what is going wrong? I'd like to understand before I try removing things.

Thanks very much for your assistance.

[R1lover]

I appreciate what you say but how is flashchat causing the problem? It works fine on the current setup and all backups were taken after flashchat was installed.

Can you explain further what is going wrong? I'd like to understand before I try removing things.

Thanks very much for your assistance.


It's BLACK & WHITE! :)

MySQL Error : Table 'databasename,sameonbothservers.flashchat_connecti ons' doesn't exist


You database is telling you that this flashchat connection does not exist.

[livethedream]

Thanks for that...

Following your post about settings in admincp I realised that could probably still get into them. I did and changed any refernce to the domain name .co.uk to the new servers IP...

I now get the same error screen BUT the bit about flashchat is visible in a scollable box ...
Why would the move screw the flashchat link?

[R1lover]

Try disabling flashchat and then see if vBulletin is ok... One step at a time.

[livethedream]

I'll have a go tomorrow, got to go to bed. 1AM don't ya know :(

I'll post back tomorrow.

Thanks ever so much :)

--------------- Added at 22:55 ---------------

Thanks for all your help, your support helped nudge me in the right direction and the problem (well, the current one:) ) is solved.

The problem was the sql backup. Flashchat had been installed after we had setup the backup job in mysql administrator. The backup job didn't include the tables for flashchat. Simple as that!

One fresh, modified, backup and restore and up came the homepage... :)

Thanks again.