System Information
- Strapi Version: 4.1.8
- Operating System: Ubuntu 18.04
- Database: MariaDB 10.1.48
- Node Version: v14.17.2
- NPM Version: 6.14.13
- Yarn Version: 1.22.10
Hello!
I have installed MariaDB on my Ubuntu VPS, created a database, and added a root user “strapi” to it.
I have input these settings when installing my strapi using the mysql option from the install menu.
Now, when I try to run strapi develop, I get the following error:
Building your admin UI with development configuration ...
Admin UI built successfully
[2022-04-19 15:34:16.696] debug: ⛔️ Server wasn't able to start properly.
[2022-04-19 15:34:16.699] error: create table `strapi_database_schema` (`id` int unsigned not null auto_increment primary key, `schema` json, `time` datetime, `hash` varchar(255)) - ER_PARSE_ERROR: 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, `time` datetime, `hash` varchar(255))' at line 1
Error: ER_PARSE_ERROR: 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, `time` datetime, `hash` varchar(255))' at line 1
at Query.Sequence._packetToError (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/var/www/testwebsite.net/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/var/www/testwebsite.net/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:375:28)
at Socket.emit (domain.js:470:12)
at addChunk (internal/streams/readable.js:290:12)
at readableAddChunk (internal/streams/readable.js:265:9)
at Socket.Readable.push (internal/streams/readable.js:204:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
--------------------
at Protocol._enqueue (/var/www/testwebsite.net/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/var/www/testwebsite.net/node_modules/mysql/lib/Connection.js:198:25)
at /var/www/testwebsite.net/node_modules/knex/lib/dialects/mysql/index.js:132:18
at new Promise (<anonymous>)
at Client_MySQL._query (/var/www/testwebsite.net/node_modules/knex/lib/dialects/mysql/index.js:126:12)
at executeQuery (/var/www/testwebsite.net/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
at Client_MySQL.query (/var/www/testwebsite.net/node_modules/knex/lib/client.js:146:12)
at Runner.query (/var/www/testwebsite.net/node_modules/knex/lib/execution/runner.js:130:36)
at Runner.queryArray (/var/www/testwebsite.net/node_modules/knex/lib/execution/runner.js:224:21)
at ensureConnectionCallback (/var/www/testwebsite.net/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:11:19)
at Runner.ensureConnection (/var/www/testwebsite.net/node_modules/knex/lib/execution/runner.js:307:20)
at processTicksAndRejections (internal/process/task_queues.js:95:5)
at async Runner.run (/var/www/testwebsite.net/node_modules/knex/lib/execution/runner.js:30:19)
at async checkTableExists (/var/www/testwebsite.net/node_modules/@strapi/database/lib/schema/storage.js:21:7)
at async Object.read (/var/www/testwebsite.net/node_modules/@strapi/database/lib/schema/storage.js:27:7)
at async Object.sync (/var/www/testwebsite.net/node_modules/@strapi/database/lib/schema/index.js:73:25)
error Command failed with exit code 1.
Any tips would be most appreciated! I would be so happy to finally get Strapi up and running!