Servers to be upgraded to MySQL 5.x this week or next

Raven · Posted: Wed Aug 16, 2006 11:14 pm

Due to popular demand, we will begin upgrades on MySQL 4.1 to bring it to version 5 starting the week of Monday, August 14th, 2006 and continuing until all shared and fully managed dedicated servers are completed.

This upgrade will entail a brief period of database inaccessibility due to the fact the we need to shut the database server down to perform the upgrade. Once it has been upgraded we will restart the database server.

This will not affect any other services on your machine. Mail and web services should run fine. PHP and other scripts that rely on MySQL for functionality will be temporarily disrupted.

We plan on doing this as late at night as possible for the least possible disruption during regular business hours.

This should only take 15-30 minutes to complete if all goes well.

Please make certain that your scripts are up to date and compatible with mysql 5.0. You are responsible for the updates.

Problematic scripts known to break on this upgrade are almost all OSCommerce-based shopping carts including creloaded, oscmax and zend cart. Invision Power Board also has issues with this upgrade.

We have found and created patches for some of these scripts that you may find useful.

Shopping Carts:
OS Commerce and MySQL 5 patch
Zend Cart MySQL 5 patch
Creloaded MySQL 5.0 Patch
OSCmax MySQL 5 Patch
advanced_search_result.tpl.php patch for MySQL 5

Invision Power Board:
Invision Power Poard MySQL 5 Patch

Other:
General information Regarding MySQL 5 JOIN issues

If the upgrades have been completed, and you have errors on your site, then please use this forum to report your problems and we will try to assist.

Best Regards,
RavenWebServices
8/16/2006

Raven · Posted: Wed Aug 23, 2006 4:55 pm

We have held off making the changes because a couple of clients were doing special presentations/programs and we did not want to interrupt them. We will still be scheduling the update and we will post back here when that will be.