JSON and JSON_ARRAY not supported by mysql server
AndreyShamis opened this issue · 2 comments
Server Version: 5.6.33-0ubuntu0.14.04.1 - (Ubuntu)
Client Database version: libmysql - mysqlnd 5.0.12-dev - 20150407 -
www-data@webcv:~/lbook$ sym doctrine:schema:update --force --dump-sql
The following SQL statements will be executed:
ALTER TABLE log_book_message CHANGE message message LONGTEXT NOT NULL;
ALTER TABLE lbook_users CHANGE roles roles JSON NOT NULL;
Updating database schema...
In AbstractMySQLDriver.php line 94:
An exception occurred while executing 'ALTER TABLE lbook_users CHANGE roles roles JSON NOT NULL':
SQLSTATE[42000]: Syntax error or access violation: 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 NOT NULL' at line 1
In PDOConnection.php line 106:
SQLSTATE[42000]: Syntax error or access violation: 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 NOT NULL' at line 1
In PDOConnection.php line 104:
SQLSTATE[42000]: Syntax error or access violation: 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 NOT NULL' at line 1
doctrine:schema:update [--complete] [--dump-sql] [-f|--force] [--em [EM]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--]
Check also DC2Type:json_array when use json_array