• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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