Question: Problem On Install On My Server

Problem On Install On My Server

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 f

GB

Giovanni Bertoni

Asked

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

  • MS

    Mian Saleem

    Answered

    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

  • Login to Reply