Razuna 1.9.5 with mySql on MacOS Sierra


#1

Hello everyone,

I’m having problems with the setup wizard when using mySql database. The tables are created in the database but the wizard does not finish. Follows my sql version output:

±------------------------±-----------------------------+
| Variable_name | Value
±------------------------±-----------------------------+
| innodb_version | 5.7.21
| protocol_version | 10
| slave_type_conversions |
| tls_version | TLSv1,TLSv1.1
| version | 5.7.21
| version_comment | MySQL Community Server (GPL)
| version_compile_machine | x86_64
| version_compile_os | macos10.13
±------------------------±-----------------------------+

bluedragon error:

Query Error 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 ‘) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT=DYNAMIC’ at line 27
Datasource MYSQL
Native Error Code 1064
SQL State 42000
SQL CREATE TABLE razuna.raz1_cart ( CART_ID VARCHAR(200), USER_ID VARCHAR(100), CART_QUANTITY INT, CART_PRODUCT_ID VARCHAR(100), CART_CREATE_DATE DATE, CART_CREATE_TIME TIMESTAMP NULL, CART_CHANGE_DATE DATE, CART_CHANGE_TIME TIMESTAMP NULL, CART_FILE_TYPE VARCHAR(5), cart_order_email varchar(150), cart_order_message varchar(2000), cart_order_done varchar(1), cart_order_date TIMESTAMP NULL, cart_order_user_r VARCHAR(100), cart_order_artofimage LONGTEXT, cart_order_artofvideo LONGTEXT, cart_order_artofaudio LONGTEXT, cart_order_artoffile LONGTEXT, HOST_ID INT, KEY raz1_cart_id (CART_ID), KEY raz1_cart_user (USER_ID), KEY raz1_cart_done (cart_order_done), KEY raz1_cart_user_r (cart_order_user_r), UNIQUE KEY idx_raz1_cart_CART_PRODUCT_ID_HOST_ID (CART_ID, CART_PRODUCT_ID, HOST_ID), ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT=DYNAMIC;

Thanks

Rui


#2

The problem is the last comma in the query.
Remove it and works fine.

Thanks


#3

What @plural said is true, but in addition, MySQL 5.7 also enforces no_zero_dates.

Put these into your my.ini:

sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION