• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Mysql error during PSA 8.3 update

N

nickhx

Guest
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!
 
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.
 
Back
Top