Problem after switching from MySQL4 to MySQL5

[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.

[Jos]

Are you running the latest version of CMSMS?
This might help: http://docs.cmsmadesimple.org/troubleshooting/tips

[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.

[Jo Morg]

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