Error establishing…

[Michael King]

Everything was working fine… I needed to reinstall on a new partition for other reasons, downloaded a fresh 3.8, install went smoothly, no errors… Launch DS, Start…, seems to do that correctly, click Sites and see the two sites I expect – great, back in business!

Then I launch one of them and get “Error Establishing Database Connection.” Try the other one…same thing. Can’t find anything in knowledge base, no hint in the error message what’s wrong…great… Yes, tried restarting things…no help.

Any help for a poor developer? Yes, free version – I work for a two non-profits, and it’s what we have budget for.

[Gregg]

Hello Michael,

Thank you for the email and we are sorry that this is happening to you. We have discovered that in some instances, due to the MySQL upgrade, the wp_options table can get locked and rendered seemingly unusable. Fortunately, we do have a fix.

1. Stop all DesktopServer services and close down DesktopServer
2. Run the MySQL upgrade script (mysqlupgrade3.sh) found here: http://docs.serverpress.com/article/155-how-to-manually-upgrade-desktopserver-from-mac
3. Restart DesktopServer

Go to http://github.com/serverpress and download a plugin called InnoDB Autoconvert. Extract the directory and place it in your Applications/Xampp/ds-plugins directory. Rename the folder innodb-autoconvert. Restart DesktopServer and you’ll notice that the InnoDB Autoconvert is now an available plugin. Enable this and then, from the main menu, select the “copy” option and copy the problematic website to a new instance. The InnoDB Autoconvert will update the tables properly and you should have a working website.

All sites should now be functioning.

Please let us know if this does not resolve the issue or if you need further assistance.

[Author]

Posts