[Dolibarr-bugtrack] [Bug #1552] Foreign Key problems when doing first install

[Doliforge]

Ce message ne s'affiche pas correctement? mettez à jour vos préférences utilisateur.

Dolibarr ERP & CRM » Bugs » bug #1552

Foreign Key problems when doing first install

Dernières modifications

Cedric GROSS (kreizit)

18/08/2014 09:42 (Europe/Paris)

Changements :

Status:

Open → Closed

Répondre

État

Détails
Last Modified On:	14/08/2014 11:50		Submitted by:	Marcos García (marcosgdf)
Submitted on:	08/08/2014 15:23
Summary:	Foreign Key problems when doing first install
Description:	Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (rowid, fk_region, code_departement,cheflieu,tncc,ncc,nom) values (0,0,'0','0',0,'-','-'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'01','01053',5,'AIN','Ain'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (22,'02','02408',5,'AISNE','Aisne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (83,'03','03190',5,'ALLIER','Allier'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (93,'04','04070',4,'ALPES-DE-HAUTE-PROVENCE','Alpes-de-Haute-Provence'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (93,'05','05061',4,'HAUTES-ALPES','Hautes-Alpes'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (93,'06','06088',4,'ALPES-MARITIMES','Alpes-Maritimes'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'07','07186',5,'ARDECHE','Ardèche'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (21,'08','08105',4,'ARDENNES','Ardennes'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'09','09122',5,'ARIEGE','Ariège'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (21,'10','10387',5,'AUBE','Aube'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (91,'11','11069',5,'AUDE','Aude'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'12','12202',5,'AVEYRON','Aveyron'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (93,'13','13055',4,'BOUCHES-DU-RHONE','Bouches-du-Rhône'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (25,'14','14118',2,'CALVADOS','Calvados'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (83,'15','15014',2,'CANTAL','Cantal'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (54,'16','16015',3,'CHARENTE','Charente'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (54,'17','17300',3,'CHARENTE-MARITIME','Charente-Maritime'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (24,'18','18033',2,'CHER','Cher'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (74,'19','19272',3,'CORREZE','Corrèze'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (94,'2A','2A004',3,'CORSE-DU-SUD','Corse-du-Sud'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (94,'2B','2B033',3,'HAUTE-CORSE','Haute-Corse'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (26,'21','21231',3,'COTE-D OR','Côte-d Or'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (53,'22','22278',4,'COTES-D ARMOR','Côtes-d Armor'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (74,'23','23096',3,'CREUSE','Creuse'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (72,'24','24322',3,'DORDOGNE','Dordogne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (43,'25','25056',2,'DOUBS','Doubs'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'26','26362',3,'DROME','Drôme'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (23,'27','27229',5,'EURE','Eure'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (24,'28','28085',1,'EURE-ET-LOIR','Eure-et-Loir'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (53,'29','29232',2,'FINISTERE','Finistère'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (91,'30','30189',2,'GARD','Gard'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'31','31555',3,'HAUTE-GARONNE','Haute-Garonne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'32','32013',2,'GERS','Gers'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (72,'33','33063',3,'GIRONDE','Gironde'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (91,'34','34172',5,'HERAULT','Hérault'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (53,'35','35238',1,'ILLE-ET-VILAINE','Ille-et-Vilaine'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (24,'36','36044',5,'INDRE','Indre'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (24,'37','37261',1,'INDRE-ET-LOIRE','Indre-et-Loire'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'38','38185',5,'ISERE','Isère'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (43,'39','39300',2,'JURA','Jura'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (72,'40','40192',4,'LANDES','Landes'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (24,'41','41018',0,'LOIR-ET-CHER','Loir-et-Cher'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'42','42218',3,'LOIRE','Loire'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (83,'43','43157',3,'HAUTE-LOIRE','Haute-Loire'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (52,'44','44109',3,'LOIRE-ATLANTIQUE','Loire-Atlantique'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (24,'45','45234',2,'LOIRET','Loiret'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'46','46042',2,'LOT','Lot'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (72,'47','47001',0,'LOT-ET-GARONNE','Lot-et-Garonne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (91,'48','48095',3,'LOZERE','Lozère'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (52,'49','49007',0,'MAINE-ET-LOIRE','Maine-et-Loire'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (25,'50','50502',3,'MANCHE','Manche'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (21,'51','51108',3,'MARNE','Marne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (21,'52','52121',3,'HAUTE-MARNE','Haute-Marne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (52,'53','53130',3,'MAYENNE','Mayenne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (41,'54','54395',0,'MEURTHE-ET-MOSELLE','Meurthe-et-Moselle'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (41,'55','55029',3,'MEUSE','Meuse'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (53,'56','56260',2,'MORBIHAN','Morbihan'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (41,'57','57463',3,'MOSELLE','Moselle'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (26,'58','58194',3,'NIEVRE','Nièvre'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (31,'59','59350',2,'NORD','Nord'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (22,'60','60057',5,'OISE','Oise'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (25,'61','61001',5,'ORNE','Orne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (31,'62','62041',2,'PAS-DE-CALAIS','Pas-de-Calais'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (83,'63','63113',2,'PUY-DE-DOME','Puy-de-Dôme'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (72,'64','64445',4,'PYRENEES-ATLANTIQUES','Pyrénées-Atlantiques'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'65','65440',4,'HAUTES-PYRENEES','Hautes-Pyrénées'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (91,'66','66136',4,'PYRENEES-ORIENTALES','Pyrénées-Orientales'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (42,'67','67482',2,'BAS-RHIN','Bas-Rhin'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (42,'68','68066',2,'HAUT-RHIN','Haut-Rhin'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'69','69123',2,'RHONE','Rhône'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (43,'70','70550',3,'HAUTE-SAONE','Haute-Saône'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (26,'71','71270',0,'SAONE-ET-LOIRE','Saône-et-Loire'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (52,'72','72181',3,'SARTHE','Sarthe'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'73','73065',3,'SAVOIE','Savoie'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (82,'74','74010',3,'HAUTE-SAVOIE','Haute-Savoie'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'75','75056',0,'PARIS','Paris'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (23,'76','76540',3,'SEINE-MARITIME','Seine-Maritime'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'77','77288',0,'SEINE-ET-MARNE','Seine-et-Marne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'78','78646',4,'YVELINES','Yvelines'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (54,'79','79191',4,'DEUX-SEVRES','Deux-Sèvres'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (22,'80','80021',3,'SOMME','Somme'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'81','81004',2,'TARN','Tarn'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (73,'82','82121',0,'TARN-ET-GARONNE','Tarn-et-Garonne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (93,'83','83137',2,'VAR','Var'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (93,'84','84007',0,'VAUCLUSE','Vaucluse'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (52,'85','85191',3,'VENDEE','Vendée'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (54,'86','86194',3,'VIENNE','Vienne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (74,'87','87085',3,'HAUTE-VIENNE','Haute-Vienne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (41,'88','88160',4,'VOSGES','Vosges'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (26,'89','89024',5,'YONNE','Yonne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (43,'90','90010',0,'TERRITOIRE DE BELFORT','Territoire de Belfort'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'91','91228',5,'ESSONNE','Essonne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'92','92050',4,'HAUTS-DE-SEINE','Hauts-de-Seine'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'93','93008',3,'SEINE-SAINT-DENIS','Seine-Saint-Denis'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'94','94028',2,'VAL-DE-MARNE','Val-de-Marne'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values (11,'95','95500',2,'VAL-D OISE','Val-d Oise'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values ( 2,'972','97209',3,'MARTINIQUE','Martinique'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values ( 3,'973','97302',3,'GUYANE','Guyane'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values ( 4,'974','97411',3,'REUNION','Réunion'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`)) Error de SQL : DB_ERROR_1452 - insert into llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom) values ( 6,'976','97601',3,'MAYOTTE','Mayotte'); - Cannot add or update a child row: a foreign key constraint fails (`dolibarr`.`llx_c_departements`, CONSTRAINT `fk_departements_fk_region` FOREIGN KEY (`fk_region`) REFERENCES `llx_c_regions` (`rowid`))
Step to reproduce bug:
Detected in version:	develop		Category:	Core Problem
Severity:	7		OS Type/Version:
PHP version:			Database type and version:
Etat
Status:	Closed		Assigned to:	Aucun
Resolution:	Fixed

Commentaires

Cedric GROSS 14/08/2014 11:50

The bug has been corrected. Pull request send inside GIT sources
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch.

 Lien direct vers l'artefact  |  Mettre à jour vos préférences