Bonjour, Je pars d'une installation toute nouvelle, fraîchement récupérée depuis la branche develop du dépot git, et lors de l'installation, j'ai l'erreur suivante : 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 'NUL, import_key varchar(14) )ENGINE=innodb' at line 4
Vous le devinez, il s'agit du fichier install/mysql/tables/llx_categorie_fournisseur.sql create table llx_categorie_fournisseur ( fk_categorie integer NOT NULL, fk_societe integer NOT NUL, import_key varchar(14) )ENGINE=innodb; Remplacez "integer NOT NUL," par "integer NOT NULL," et cela fonctionne de nouveau. ----------------------- English version ---------------------- Hello, I start with a whole new system, freshly recovered from the branch develop in the git repository, and during the installation, I get 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 'NUL, import_key varchar(14) )ENGINE=innodb' at line 4. You guessed it, this is the file install/mysql/tables/llx_categorie_fournisseur.sql create table llx_categorie_fournisseur ( fk_categorie integer NOT NULL, fk_societe integer NOT NUL, import_key varchar(14) )ENGINE=innodb; Change "integer NOT NUL," by "integer NOT NULL," and it works again. -- Marc-Henri Pamiseux 02.30.96.15.24 06.26.71.30.97 SARL Libricks Maison de la technopole 6, rue Léonard de Vinci - BP 0119 53001 LAVAL Cedex
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev