• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Cannot login to Plesk. PleskMainDBException. error in SQL syntax

Y

yarr

Guest
Hi,
I tried to login to our plesk installation today and it came up with the license agreement page (which didn't actually show the license, only the checkboxes to agree or not) and then displays the following error:

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) = "AdvancedPoll-2.03-14"' at line 1

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

Does anyone know what is going wrong?
 
Back
Top