[Dolibarr-dev] Processus installation en échec / E rror in setup

[Marc-Henri Pamiseux]

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