1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Error while backup 'pkg.release as release'

Discussion in 'Plesk for Windows - 8.x and Older' started by guesswho911, Dec 1, 2008.

  1. guesswho911

    guesswho911 Guest

    0
     
    About the middle of the month we changed our license to allow for Application Repo to be active. We didn't think anything of it until we went to look for our backups and found that they haven't been successful for a while. They seem to be coming up with this in the error:

    Backup error.
    Can't query SELECT pkg.name as name, pkg.version as version, pkg.release as release FROM APSApplicationItems ai INNER JOIN siteapppackages pkg ON ai.pkg_id=pkg.id WHERE ai.id=90: MySQLDatabaseProvider error 1064: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 FROM APSApplicationItems ai INNER JOIN siteapppackages pkg ON ai.pkg_' at line 1

    However if I run the command in mysql:
    SELECT pkg.name as name, pkg.version as version, pkg.release as 'release' FROM APSApplicationItems ai INNER JOIN siteapppackages pkg ON ai.pkg_id=pkg.id WHERE ai.id=90

    That command works. Apparently release is a reserved keyword in MySQL 5.0 but it is causing a problem in the script. Has anyone else run into this issue before and perhaps knows how to possibly solve it as it seems to be impossible to do a backup otherwise?
     
Loading...