Bienvenido a los foros %s

Foro comunidad hispana Dolibarr

Identificarse Registrarse

Problema actualizando desde 3.8.4 a 3.9.1

Si cree que ha encontrado un error en una versión estable, siéntase libre de comunicarlo aquí, indicando la versión.
retrocomp
Novato
Mensajes: 48
Registrado: Mar, 18/11/2014, 23:27

Problema actualizando desde 3.8.4 a 3.9.1

Mensaje por retrocomp »

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

Avatar de Usuario
marcosgdf
Jedi
Mensajes: 772
Registrado: Vie, 20/07/2012, 14:42
Ubicación: Valladolid, España

Mensaje por marcosgdf »

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.
Desarrollador con categoría Almirante de Dolibarr.
¿Quiere soporte personalizado? Contacte conmigo.