Hello,
I am just installing manually Dolibarr on Mac OS X (10.10).
When going through the installation steps, I got the following error :
Erreur SQL DB_ERROR_SYNTAX 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 'virtual tinyint DEFAULT 0 NOT NULL, fk_parent integer DEFAULT 0, ’ at line 11
Could anyone help ? Thanks in advance.
additional information:
Connexion au serveur : localhost Ok
Version de la base 5.7.10
Nom de la base de données dolibarr
Création de la table llx_product et de sa clé primaire
Request 163 : create table llx_product ( rowid integer AUTO_INCREMENT PRIMARY KEY, ref varchar(128) NOT NULL, entity integer DEFAULT 1 NOT NULL, ref_ext varchar(128), datec datetime, tms timestamp, virtual tinyint DEFAULT 0 NOT NULL, fk_parent integer DEFAULT 0, label varchar(255) NOT NULL, description text, note text, customcode varchar(32), fk_country integer DEFAULT NULL, price double(24,8) DEFAULT 0, price_ttc double(24,8) DEFAULT 0, price_min double(24,8) DEFAULT 0, price_min_ttc double(24,8) DEFAULT 0, price_base_type varchar(3) DEFAULT ‘HT’, tva_tx double(6,3), recuperableonly integer NOT NULL DEFAULT ‘0’, localtax1_tx double(6,3) DEFAULT 0, localtax2_tx double(6,3) DEFAULT 0, fk_user_author integer DEFAULT NULL, fk_user_modif integer, tosell tinyint DEFAULT 1, tobuy tinyint DEFAULT 1, tobatch tinyint DEFAULT 0 NOT NULL, fk_product_type integer DEFAULT 0, duration varchar(6), seuil_stock_alerte integer DEFAULT 0, url varchar(255), barcode varchar(255) DEFAULT NULL, fk_barcode_type integer DEFAULT NULL, accountancy_code_sell varchar(32), accountancy_code_buy varchar(32), partnumber varchar(32), weight float DEFAULT NULL, weight_units tinyint DEFAULT NULL, length float DEFAULT NULL, length_units tinyint DEFAULT NULL, surface float DEFAULT NULL, surface_units tinyint DEFAULT NULL, volume float DEFAULT NULL, volume_units tinyint DEFAULT NULL, stock integer, pmp double(24,8) DEFAULT 0 NOT NULL, fifo double(24,8), lifo double(24,8), canvas varchar(32) DEFAULT NULL, finished tinyint DEFAULT NULL, hidden tinyint DEFAULT 0, import_key varchar(14), fk_price_expression integer, desiredstock integer DEFAULT 0, fk_unit integer DEFAULT NULL )ENGINE=innodb;
Executed query : create table llx_product ( rowid integer AUTO_INCREMENT PRIMARY KEY, ref varchar(128) NOT NULL, entity integer DEFAULT 1 NOT NULL, ref_ext varchar(128), datec datetime, tms timestamp, virtual tinyint DEFAULT 0 NOT NULL, fk_parent integer DEFAULT 0, label varchar(255) NOT NULL, description text, note text, customcode varchar(32), fk_country integer DEFAULT NULL, price double(24,8) DEFAULT 0, price_ttc double(24,8) DEFAULT 0, price_min double(24,8) DEFAULT 0, price_min_ttc double(24,8) DEFAULT 0, price_base_type varchar(3) DEFAULT ‘HT’, tva_tx double(6,3), recuperableonly integer NOT NULL DEFAULT ‘0’, localtax1_tx double(6,3) DEFAULT 0, localtax2_tx double(6,3) DEFAULT 0, fk_user_author integer DEFAULT NULL, fk_user_modif integer, tosell tinyint DEFAULT 1, tobuy tinyint DEFAULT 1, tobatch tinyint DEFAULT 0 NOT NULL, fk_product_type integer DEFAULT 0, duration varchar(6), seuil_stock_alerte integer DEFAULT 0, url varchar(255), barcode varchar(255) DEFAULT NULL, fk_barcode_type integer DEFAULT NULL, accountancy_code_sell varchar(32), accountancy_code_buy varchar(32), partnumber varchar(32), weight float DEFAULT NULL, weight_units tinyint DEFAULT NULL, length float DEFAULT NULL, length_units tinyint DEFAULT NULL, surface float DEFAULT NULL, surface_units tinyint DEFAULT NULL, volume float DEFAULT NULL, volume_units tinyint DEFAULT NULL, stock integer, pmp double(24,8) DEFAULT 0 NOT NULL, fifo double(24,8), lifo double(24,8), canvas varchar(32) DEFAULT NULL, finished tinyint DEFAULT NULL, hidden tinyint DEFAULT 0, import_key varchar(14), fk_price_expression integer, desiredstock integer DEFAULT 0, fk_unit integer DEFAULT NULL )ENGINE=innodb;
