What came to light recently, this is due to me using MySQL 4.1 with PHP5?
PHP cares not at all for the flavor of MySQL being used; the syntax is the same. What you will need to do, is recompile PHP after the MySQL upgrade, since the PHP MySQL bridge is compiled against mysql.h, which is version specific.
1. Upgrade MySQL
2. Perform the steps to correct your tables (usually does nothing in fact)
3. Recompile PHP
None of this requires you to upload/download anything -- it's all in your host's hands.
circlical - hosting software development forums * blog
Well, first I've got to ask why someone is using MySQL4? That's just silly. MySQL5 is pretty stable, has been for a good while now.
Saeven is right, however. php5 doesn't complain about mysql4, or at least I never saw it do so when running sql4. If you're getting database errors, then there's a few problems.
#1: you need to check configurations
#2: you need to recompile php properly tying in the mysql database (maybe it was upgraded and php needs to be recompiled?)
#3: Use mysqli
#4: use the old passwords option if that still doesn't work
It sounds to me though like they want you to 'upgrade to mysql5', which means more money for them. A bit of a sham if you ask me.
WHMCS Guru - WHMCS addons, management, support and more. WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to WHMCS !!
Always looking for Linux, WHMCS, Support Desk work. PM for details