0
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, created_at
timestamp NULL DEFAULT NULL, updated_at
ti' at line 4 (Connection: mysql, SQL: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /; /!40103 SET TIME_ZONE='+00:00' /; /!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /; /!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /; /!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /; /!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /; DROP TABLE IF EXISTS accounts
; /!40101 SET @saved_cs_client = @@character_set_client /; /!50503 SET character_set_client = utf8mb4 /; CREATE TABLE accounts
( id
bigint unsigned NOT NULL AUTO_INCREMENT, name
varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, extra_attributes
json DEFAULT NULL, created_at
timestamp NULL DEFAULT NULL, updated_at
timestamp NULL DEFAULT NULL, deleted_at
timestamp NULL DEFAULT NULL, PRIMARY KEY (id
) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /!40101 SET character_set_client = @saved_cs_client /; DROP TABLE IF EXISTS activity_log
; /!40101 SET @saved_cs_client = @@character_set_client /; /!50503 SET character_set_client = utf8mb4 */; CREATE TABLE activity_log
( id
bigint unsigned NOT NULL AUTO_INCREMENT, log_name
varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, description
text CHARACTER SET utf8mb4
0
Hello,
WIMS require your database to support json
. For MariaDB if I am not wrong it was added in v10.2 Please update your database version they try agian.
Thank you
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.