I’ve been trying to get SolidCP setup as I used to use Websitepanel and it seems like a great alternative!
Unfortunately I’m having an issue trying to install WordPress on websites. I always get an ApplicationInstallationError. In searching the forum I haven’t been able to find a solution. Below is the error that I’m getting. Has anyone had this happen?
– Failure: An error occurred during execution of the database script. The error occurred between the following lines of the script: “5” and “13”. The verbose log might have more information about the error. The command started with the following: “CREATE PROCEDURE add_user() BEGIN DECLARE EXIT HAN” 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 ‘IDENTIFIED BY ‘PASSWORD WAS HERE’; FLUSH PRIVILEGES; END’ at line 4 http://go.microsoft.com/fwlink/?LinkId=178587 Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SQL_EXECUTION_FAILURE. 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 ‘IDENTIFIED BY ‘PASSWORD WAS HERE’; FLUSH PRIVILEGES; END’ at line 4
I ended up uninstalling MySQL 8 and installed MySQL 5. Everything is working now. I’d love to run MySQL but this will have to do for now.
There are a few changes in how MySQL 8 is to be queried and i don’t believe WebPI has these changes included. We will need to wait for Microsoft to support MySQL 8.
- Views743 times
- Answers2 answers