Mysql error during PSA 8.3 update

[nickhx]

Hi everyone,

I am encountering the following error when I try to update PSA 8.2.1 to 8.3 (specifically the psa-8.3.0-cos4.build83071218.20.i586.rpm package):

Mysql exited with non-zero status 11 at -e line 27.

APS: tables already upgraded.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to us
e near '---------------
CREATE TABLE IF NOT EXISTS `SBSites` (
`id` ' at line 1
Mysql exited with non-zero status 256 at -e line 27, <STDIN> line 52.

ERROR while trying to upgrade SQL database from 821

Aborting...

My Mysql version is 5.055

Can anyone help? Thanks!

 

[nickhx]

Turns out this is a bug in the syntax in the database upgrade file /usr/local/psa/etc/db/psa_db_upgrade_821.sql provided in the main Plesk rpm, which I needed professional help (thanks layershift.com!) to resolve.

Hopefully, SWSoft will fix this in the next hotfix they issue.

 

[dirty@]

http://kb.swsoft.com/en/3546