PostgeSQL 9.3.5 en x86_64
PHP 5.4.16
Imagino que se debe al uso de PostgrSQL y que en MySQL no se produce.
Migración del formato de la base de datos
Conexión al servidor : 192.168.20.100 OK
Conexión a la base de datos : dolibarr OK
Versión del servidor de la base de datos 9.3.5
Rogamos espere unos instantes...
Elección del script de migración 3.8.0-3.9.0.sql
...
...
...
Request 149 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('001', 5201, '', 0, '', 'Belisario Boeto', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('001', 5201, '', 0, '', 'Belisario Boeto', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 150 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('002', 5201, '', 0, '', 'Hernando Siles', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('002', 5201, '', 0, '', 'Hernando Siles', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 151 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('003', 5201, '', 0, '', 'Jaime Zudáñez', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('003', 5201, '', 0, '', 'Jaime Zudáñez', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 152 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('004', 5201, '', 0, '', 'Juana Azurduy de Padilla', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('004', 5201, '', 0, '', 'Juana Azurduy de Padilla', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 153 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('005', 5201, '', 0, '', 'Luis Calvo', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('005', 5201, '', 0, '', 'Luis Calvo', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 154 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('006', 5201, '', 0, '', 'Nor Cinti', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('006', 5201, '', 0, '', 'Nor Cinti', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 155 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('007', 5201, '', 0, '', 'Oropeza', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('007', 5201, '', 0, '', 'Oropeza', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 156 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('008', 5201, '', 0, '', 'Sud Cinti', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('008', 5201, '', 0, '', 'Sud Cinti', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 157 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('009', 5201, '', 0, '', 'Tomina', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('009', 5201, '', 0, '', 'Tomina', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Request 158 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('010', 5201, '', 0, '', 'Yamparáez', 1);'
Error DB_ERROR_NO_PARENT: INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES ('010', 5201, '', 0, '', 'Yamparáez', 1);
ERROR: 23503: insert or update on table "llx_c_departements" violates foreign key constraint "fk_departements_code_region" DETAIL: Key (fk_region)=(5201) is not present in table "llx_c_regions". SCHEMA NAME: public TABLE NAME: llx_c_departements CONSTRAINT NAME: fk_departements_code_region LOCATION: ri_ReportViolation, ri_triggers.c:3232
Problema actualizando desde 3.8.4 a 3.9.1
Hola retrocomp:
Debería haber un error anterior. Lo que aparece ahí parece ser la consecuencia de que otra consulta a la base de datos no se ejecutara correctamente.
Escríbenos de nuevo en cuanto dispongas de la información.
Un saludo.
Debería haber un error anterior. Lo que aparece ahí parece ser la consecuencia de que otra consulta a la base de datos no se ejecutara correctamente.
Escríbenos de nuevo en cuanto dispongas de la información.
Un saludo.
Desarrollador con categoría Almirante de Dolibarr.
¿Quiere soporte personalizado? Contacte conmigo.
¿Quiere soporte personalizado? Contacte conmigo.