Page 1 of 1

[Solved] Database Issues after moving to new server.

Posted: Wed Oct 07, 2009 9:34 pm
by junkmailtrapenator
I am in the process of moving my CMSMS installation to a new server. This in itself is no big deal, but the move has caused a database issue that was not present on the old server.

I have a number of User Defined Tags that create a connection to a MySql database (not the cms db). On the old server this works fine, but what appears to happen on the new server is that the link_identifier to the non-cms db replaces the link_identifier to the cms db. Then any further queries the cms makes is against the wrong database.

CMSMS is 1.6.4 and all the files where copied from one server to the other. PHP is at 5.2.6 and 5.2.11 on the old and new servers respectively.

Does anyone have any idea what might be causeing it to be an issue on one server and not the other and what I might be able to do to work around this issue.

Thanks

Re: Database Issues after moving to new server.

Posted: Wed Oct 07, 2009 9:37 pm
by Nullig
Do you have

  adodb_connect();

at the end of your UDT to reconnect to the CMSMS db?

Nullig

Re: Database Issues after moving to new server.

Posted: Thu Oct 08, 2009 12:58 pm
by junkmailtrapenator
Interesting! Adding that seems to fix the problem. I wonder why I wasn't having that problem on the old server.

Thanks!!