• 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!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

SQL error when changing the domain name for a website

Status
Not open for further replies.

magnuskragelund

New Pleskian
I'm running Parallels Plesk Panel 11.5.30 with 3 websites running on the server.
When I go to Hosting Settings for a website (under the Websites & Domains section), change the domain name (from site1.example.com to somthingelse.example.com) and click OK, i get an error with the following message:
Unable to prepare SQL statement for query 'UPDATE domains SET name=LOWER(?) WHERE name=LOWER(?)': no such table: domains

I have no idea what to do about it - any help is greatly appreciated.
 
Looks like a plesk DB inconsistency ...
Try upgrading the db with

Code:
/usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair
 
Status
Not open for further replies.
Back
Top