Backup bug using mysql to plesk

[DanivalBrazil]

Hello,

If I set my plesk to use MySql, my backups fail with this error:

Backup error.
Can't query SELECT pkg.name as name, pkg.version as version, pkg.release as release FROM APSClientApplicationItems ci INNER JOIN (APSApplicationItems ai INNER JOIN siteapppackages pkg ON ai.pkg_id=pkg.id) ON ai.id=ci.app_item_id WHERE ci.id=0: 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 APSClientApplicationItems ci INNER JOIN (APSApplicationItems ai ' at line 1


If I Set MSSQL, my backups work fine.

How do I fix it? I dont like use MSSQL.

 

[nieuwhier]

I switched today from jet to mysql and I have the same error here..

 

[nieuwhier]

I switched back to jet engine, got another error there.
Now again back to mysql. Is seems the table pgk.release is not available.

is that from the application pack perhaps ?
Did not know that plesk was this buggy....

 

[nieuwhier]

Ok... I am just talking to myself I guess....

This is the query with the error when when I start the backup:
SELECT pkg.name as name, pkg.version as version, pkg.release as release
FROM APSClientApplicationItems ci
INNER JOIN (APSApplicationItems ai
INNER JOIN siteapppackages pkg ON ai.pkg_id=pkg.id) ON ai.id=ci.app_item_id
WHERE ci.id=0

When I open phpmyadmin with the database and change pkg.release as release INTO pkg.release as testrelease than the query runs ok. Is this for real ? A reserved keyword ?