Greetings!
I installed Dolibarr ver 3.6.1 supports mysql up to 5.5.38.
I have got this error message:
SQL Error 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 ‘webservices_url varchar(255), webservices’ at line 74
Server connection : xxxxxx.mysql.xxxxx.xxx Ok
Database version 5.6.21-log
Database name xxxxxxxxxxxxx
Create table llx_societe
Request 165 : create table llx_societe ( rowid integer AUTO_INCREMENT PRIMARY KEY, nom varchar(128), entity integer DEFAULT 1 NOT NULL, ref_ext varchar(128), ref_int varchar(60), statut tinyint DEFAULT 0, parent integer, tms timestamp, datec datetime, status tinyint DEFAULT 1, code_client varchar(24), code_fournisseur varchar(24), code_compta varchar(24), code_compta_fournisseur varchar(24), address varchar(255), zip varchar(25), town varchar(50), fk_departement integer DEFAULT 0, fk_pays integer DEFAULT 0, phone varchar(20), fax varchar(20), url varchar(255), email varchar(128), skype varchar(255), fk_effectif integer DEFAULT 0, fk_typent integer DEFAULT 0, fk_forme_juridique integer DEFAULT 0, fk_currency varchar(3), siren varchar(128), siret varchar(128), ape varchar(128), idprof4 varchar(128), idprof5 varchar(128), idprof6 varchar(128), tva_intra varchar(20), capital real, fk_stcomm integer DEFAULT 0 NOT NULL, note_private text, note_public text, prefix_comm varchar(5), client tinyint DEFAULT 0, fournisseur tinyint DEFAULT 0, supplier_account varchar(32), fk_prospectlevel varchar(12), customer_bad tinyint DEFAULT 0, customer_rate real DEFAULT 0, supplier_rate real DEFAULT 0, fk_user_creat integer NULL, fk_user_modif integer, remise_client real DEFAULT 0, mode_reglement tinyint, cond_reglement tinyint, mode_reglement_supplier tinyint, cond_reglement_supplier tinyint, tva_assuj tinyint DEFAULT 1, localtax1_assuj tinyint DEFAULT 0, localtax1_value double(6,3), localtax2_assuj tinyint DEFAULT 0, localtax2_value double(6,3), barcode varchar(255), fk_barcode_type integer NULL DEFAULT 0, price_level integer NULL, outstanding_limit double(24,8) DEFAULT NULL, default_lang varchar(6), logo varchar(255), canvas varchar(32), import_key varchar(14) webservices_url varchar(255), webservices_key varchar(128), )ENGINE=innodb;
Prerequisites check:
Ok PHP Version 5.6.2 (More information)
Ok This PHP supports variables POST and GET.
Ok This PHP supports sessions.
Ok This PHP support GD graphical functions.
Ok This PHP support UTF8 functions.
Ok Your PHP max session memory is set to 512M. This should be enough.
Ok Configuration file htdocs/conf/conf.php exists.
Ok Configuration file htdocs/conf/conf.php is writable.
My Host servers answer:
It seems like Dolibarr ver 3.6.1 supports mysql up to 5.5.38. -> https://bitnami.com/stack/dolibarr/changelog.txt. We are running Mysql 5.6.21 in all of our shared hosting servers. That is why there is error with the sql query. I suggest you to take a look at www.dolibarr.org/c/installing-my-dolibarr there is probably a workaround on this issue.
Please your advice.
Greetings to your amazing community!
Best regards,
Golan D.
