search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.46k stars 2.79k forks source link

Bug: SQL error when installing 3.7.4 #6080

Closed marcosgdf closed 7 years ago

marcosgdf commented 7 years ago

Bug

I know 3.7 is not supported anymore but I can't even install it

Affected versions: 3.7.2, 3.7.3,3.7.4

Base de datos

Conexión al servidor : localhost    Ok
Versión de la base de datos 5.7.16
Nombre de la base de datos  dolibarr37
Creación de la tabla llx_product y su clave primaria
Request 142 : 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, canvas varchar(32) DEFAULT NULL, finished  tinyint DEFAULT NULL, hidden    tinyint DEFAULT 0,  import_key  varchar(14),    desiredstock integer DEFAULT 0 )ENGINE=innodb;

Error de 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
marcosgdf commented 7 years ago

SQL errors due to MySQL changes