mysql 5.0.24a breaks PSA 8.0.1

[carlswart]

Scott,

This is a quick note to let you know that mysql 5.0.24a, available from the atomic-bleeding channel, breaks PSA 8.0.1.

The error is:

ERROR: PleskMainDBException
MySQL query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release) = "gtchat-0.93-15"' at line 1

0: /usr/local/psa/admin/plib/common_func.php3:232
db_query(string 'SELECT id FROM SiteAppPackages WHERE CONCAT(name, "-", version, "-", release) = "gtchat-0.93-15"')
1: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:284
SiteAppPackageManager::getSiteAppPackageId(string 'gtchat-0.93-15')
2: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:249
SiteAppPackageManager->syncWithDatabase()
3: /usr/local/psa/admin/htdocs/license.php3:27

--
Regards,
-Carl

[breun]

No suprise really as Plesk isn't compatible with MySQL 5 yet.

[carlswart]

I agree that it is no surprise and that PSA is not MySQL 5 compatible.

Since the MySQL 5 rpm's installed silently, I did a few tests, not that I could really get past the login screen, before the error appeared.

Maybe the error can assist Scott now or in future with his efforts to make MySQL rpm's compatible with PSA.

[scott]

Theres no way I can make mysql 5 compatible with psa, its an internal PSA design issue