Project-Sloth / ps-housing

Advanced housing system for QBCore.
https://discord.gg/projectsloth
Other
343 stars 110 forks source link

Problem with SQL #181

Closed ReazCho closed 9 months ago

ReazCho commented 9 months ago

---- Database: qbcoreframework_8c97e0---- ------------------------------------------------------------ Table structure for table properties--CREATE TABLE properties ( property_id int(11) NOT NULL, owner_citizenid varchar(50) DEFAULT NULL, street varchar(100) DEFAULT NULL, region varchar(100) DEFAULT NULL, description longtext DEFAULT NULL, has_access longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(has_access)), extra_imgs longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(extra_imgs)), furnitures longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT json_array() CHECK (json_valid(furnitures)), for_sale tinyint(1) NOT NULL DEFAULT 1, price int(11) NOT NULL DEFAULT 0, shell varchar(50) NOT NULL, apartment varchar(50) DEFAULT NULL, door_data longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(door_data)), garage_data longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(garage_data))) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json_array() CHECK (json_valid(has_access)),

extra_imgs longtext CHARACTER' at line 17

ReazCho commented 9 months ago

and also i have this error image_2024-01-30_223618600