Fixed. 2012/10/27 Marc-Henri Pamiseux <marc-henri.pamis...@libricks.org>: > 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 > > > _______________________________________________ > Dolibarr-dev mailing list > Dolibarr-dev@nongnu.org > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
