Hello I am trying to install and receiving a SQL error after input of admin and key info.
The error is -
SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘json DEFAULT NULL, batch_uuid char(36) COLLATE utf8mb4_unicode_ci DEFAULT NU’ at line 11
I have looked and the installer gets the ‘accounts’ table setup in the DB but then errors. I have dropped all tables to clean database, and tried several times. Same results. By creating ‘accounts’ table this tells me the connection is good. Please help
- MSAnswered
Hello,
Please update your MariaDB to at least 10.2+ You current version is old and doesn’t support json.
Thank you
- JJAnswered
Hello again, Server Admin confirms that plesk was updated to Plesk Obsidian v10.0.54 which included MariaDB v10.11 that was installed on Aug 2nd at 3am So according to him, the DB is using the latest version. As I said before, the installer creates 1 table “accounts” with all properties. I am assuming that json is being used for that creation as well. So what do you suggest to get this thing installed?
- MSAnswered
Hello,
If you are using the 10.11 there shouldn’t be such error. Please open phpmuyadmin and view the version at the right. If you can share the server details in private reply, I can help you check.
Thank you
- JJAnswered
Ok, database and install package have completed. Now I am receiving a 500 server error. Error = 2023-08-05 13:00:10 Error 73.118.24.62 500 GET /public/tsms HTTP/1.0 Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36 7.36 K Apache SSL/TLS access The application is finding the index page because a simple test echo displays. Please help
- MSAnswered
Hello,
Please check the latest log file in the
storage/logs/folder for error details.Thank you
- Login to Reply