Receiving Sql Error On Install
0
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
0
Hello,
Please update your MariaDB to at least 10.2+ You current version is old and doesn't support json.
Thank you
0
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?
0
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
0
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
0
Hello,
Please check the latest log file in the storage/logs/ folder for error details.
Thank you
Instantly elevate your business, earn more money, attract more clients, and deliver exceptional digital experiences. Tecdiary is the leading independent provider of inventory & e-commerce solutions for digital experiences. What sets our solution apart for partners is our modular, flexible architecture and customizable licensing model. With Tecdiary, partners are free to build, customize, and extend the platform to create amazing digital experiences for your individual clients or to support your own packaged solution.
We use Cookies
We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.