Page 1 of 1

Problem after switching from MySQL4 to MySQL5

Posted: Tue Jul 16, 2013 12:50 am
by mrdark
Today I dumped the database from an existing installation from a MySQL4 database to a MySQL5 database. All the data went over successfully, I can connect to the database, browse the tables and rows. It's all there.

I've verified the DB username and password. I switched over the config.php to the new database information, and the main page of the site loads. However, clicking on items that normally pull data, pull nothing, just whitespace. There are no database errors on the site. Switching back to the MySQL4 database server, and everything works fine.

PHP is and has been version 5.4, no change there.

I've done this many times with other software and have never come across this problem. Does anyone have any insight on this? Losing my mind. Thanks.

Re: Problem after switching from MySQL4 to MySQL5

Posted: Tue Jul 16, 2013 9:15 am
by Jos
Are you running the latest version of CMSMS?
This might help: http://docs.cmsmadesimple.org/troubleshooting/tips

Re: Problem after switching from MySQL4 to MySQL5

Posted: Wed Jul 17, 2013 4:27 am
by mrdark
No. It's a version 1.7 (old, I know). The problem is, the web host is phasing out the external MySQL4 servers, which is what this install has been happy with for years. I've tried doing an upgrade to current version, which was a disaster. I'd try incrementals, but there's probably a ton of versions between 1.7 and current, and I don't see anywhere to download them.

Re: Problem after switching from MySQL4 to MySQL5

Posted: Wed Jul 17, 2013 4:41 pm
by Jo Morg
mrdark wrote:I'd try incrementals, but there's probably a ton of versions between 1.7 and current, and I don't see anywhere to download them.
A few, but that shouldn't be a problem if you follow the guide carefully: http://docs.cmsmadesimple.org/upgrading/old-versions .
Downloads here: http://dev.cmsmadesimple.org/project/files/6
HTH