Connexion au serveur : localhost OK
Connexion à la base : dolibarr2 OK
Version du serveur de base de données 5.5.24-log
Merci de patienter…
Choix du script de migration 3.1.0-3.2.0.sql
Request 1 sql=‹ DELETE FROM llx_user_param WHERE param = ‹ MAIN_THEME › and value = ‹ freelug ›; ›
Request 2 sql=‹ update llx_propal set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 3 sql=‹ update llx_commande set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 4 sql=‹ update llx_facture set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 5 sql=‹ update llx_commande_fournisseur set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 6 sql=‹ update llx_contrat set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 7 sql=‹ update llx_deplacement set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 8 sql=‹ update llx_facture_fourn set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 9 sql=‹ update llx_facture_rec set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 10 sql=‹ update llx_fichinter set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 11 sql=‹ update llx_projet_task set fk_projet = null where fk_projet not in (select rowid from llx_projet); ›
Request 12 sql=‹ update llx_commande set fk_user_author = null where fk_user_author not in (select rowid from llx_user); ›
Request 13 sql=‹ ALTER TABLE llx_extrafields ADD COLUMN TYPE VARCHAR(8); ›
Request 14 sql=‹ UPDATE llx_c_paper_format SET active=1 WHERE active=0; ›
Request 15 sql=‹ ALTER TABLE llx_actioncomm ADD COLUMN ref_ext varchar(128) after id; ›
Request 16 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_availability integer AFTER fk_product_fournisseur; ›
Request 17 sql=‹ ALTER TABLE llx_element_element MODIFY COLUMN sourcetype varchar(32) NOT NULL; ›
Request 18 sql=‹ ALTER TABLE llx_element_element MODIFY COLUMN targettype varchar(32) NOT NULL; ›
Request 19 sql=‹ ALTER TABLE llx_user MODIFY ref_ext varchar(50); ›
Request 20 sql=‹ ALTER TABLE llx_user ADD COLUMN ref_int varchar(50) AFTER ref_ext; ›
Request 21 sql=‹ ALTER TABLE llx_societe MODIFY code_client varchar(24); ›
Request 22 sql=‹ ALTER TABLE llx_societe MODIFY code_fournisseur varchar(24); ›
Request 23 sql=‹ ALTER TABLE llx_societe MODIFY siren varchar(128); ›
Request 24 sql=‹ ALTER TABLE llx_societe MODIFY siret varchar(128); ›
Request 25 sql=‹ ALTER TABLE llx_societe MODIFY ape varchar(128); ›
Request 26 sql=‹ ALTER TABLE llx_societe MODIFY idprof4 varchar(128); ›
Request 27 sql=‹ ALTER TABLE llx_societe ADD COLUMN idprof5 varchar(128); ›
Request 28 sql=‹ ALTER TABLE llx_societe MODIFY code_compta varchar(24); ›
Request 29 sql=‹ ALTER TABLE llx_societe MODIFY code_compta_fournisseur varchar(24); ›
Request 30 sql=‹ ALTER TABLE llx_chargesociales ADD COLUMN tms timestamp; ›
Request 31 sql=‹ ALTER TABLE llx_chargesociales ADD COLUMN date_creation datetime; ›
Request 32 sql=‹ ALTER TABLE llx_chargesociales ADD COLUMN date_valid datetime; ›
Request 33 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (1, ‹ EU4A0 ›, ‹ Format 4A0 ›, ‹ 1682 ›, ‹ 2378 ›, ‹ mm ›, 1); ›
Request 34 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (2, ‹ EU2A0 ›, ‹ Format 2A0 ›, ‹ 1189 ›, ‹ 1682 ›, ‹ mm ›, 1); ›
Request 35 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (3, ‹ EUA0 ›, ‹ Format A0 ›, ‹ 840 ›, ‹ 1189 ›, ‹ mm ›, 1); ›
Request 36 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (4, ‹ EUA1 ›, ‹ Format A1 ›, ‹ 594 ›, ‹ 840 ›, ‹ mm ›, 1); ›
Request 37 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (5, ‹ EUA2 ›, ‹ Format A2 ›, ‹ 420 ›, ‹ 594 ›, ‹ mm ›, 1); ›
Request 38 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (6, ‹ EUA3 ›, ‹ Format A3 ›, ‹ 297 ›, ‹ 420 ›, ‹ mm ›, 1); ›
Request 39 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (7, ‹ EUA4 ›, ‹ Format A4 ›, ‹ 210 ›, ‹ 297 ›, ‹ mm ›, 1); ›
Request 40 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (8, ‹ EUA5 ›, ‹ Format A5 ›, ‹ 148 ›, ‹ 210 ›, ‹ mm ›, 1); ›
Request 41 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (9, ‹ EUA6 ›, ‹ Format A6 ›, ‹ 105 ›, ‹ 148 ›, ‹ mm ›, 1); ›
Request 42 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (100, ‹ USLetter ›, ‹ Format Letter (A) ›, ‹ 216 ›, ‹ 279 ›, ‹ mm ›, 1); ›
Request 43 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (105, ‹ USLegal ›, ‹ Format Legal ›, ‹ 216 ›, ‹ 356 ›, ‹ mm ›, 1); ›
Request 44 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (110, ‹ USExecutive ›, ‹ Format Executive ›, ‹ 190 ›, ‹ 254 ›, ‹ mm ›, 1); ›
Request 45 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (115, ‹ USLedger ›, ‹ Format Ledger/Tabloid (
›, ‹ 279 ›, ‹ 432 ›, ‹ mm ›, 1); ›
Request 46 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (200, ‹ CAP1 ›, ‹ Format Canadian P1 ›, ‹ 560 ›, ‹ 860 ›, ‹ mm ›, 1); ›
Request 47 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (205, ‹ CAP2 ›, ‹ Format Canadian P2 ›, ‹ 430 ›, ‹ 560 ›, ‹ mm ›, 1); ›
Request 48 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (210, ‹ CAP3 ›, ‹ Format Canadian P3 ›, ‹ 280 ›, ‹ 430 ›, ‹ mm ›, 1); ›
Request 49 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (215, ‹ CAP4 ›, ‹ Format Canadian P4 ›, ‹ 215 ›, ‹ 280 ›, ‹ mm ›, 1); ›
Request 50 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (220, ‹ CAP5 ›, ‹ Format Canadian P5 ›, ‹ 140 ›, ‹ 215 ›, ‹ mm ›, 1); ›
Request 51 sql=‹ INSERT INTO llx_c_paper_format (rowid, code, label, width, height, unit, active) VALUES (225, ‹ CAP6 ›, ‹ Format Canadian P6 ›, ‹ 107 ›, ‹ 140 ›, ‹ mm ›, 1); ›
Request 52 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_product integer after tms; ›
Request 53 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_soc integer after fk_product; ›
Request 54 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD COLUMN ref_fourn varchar(30) after fk_soc; ›
Request 55 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD COLUMN entity integer DEFAULT 1 NOT NULL; ›
Request 56 sql=‹ UPDATE llx_product_fournisseur_price as a, llx_product_fournisseur as b SET a.fk_product = b.fk_product, a.fk_soc = b.fk_soc, a.ref_fourn = b.ref_fourn, a.entity = b.entity WHERE a.fk_product_fournisseur = b.rowid AND (a.fk_product IS NULL OR a.fk_soc IS NULL OR a.fk_product = 0 OR a.fk_soc = 0); ›
Request 57 sql=‹ ALTER TABLE llx_product_fournisseur_price DROP INDEX uk_product_fournisseur_price_ref; ›
Request 58 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD UNIQUE INDEX uk_product_fournisseur_price_ref (ref_fourn, fk_soc, quantity, entity); ›
Request 59 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_fourn_price_fk_product (fk_product, entity); ›
Request 60 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_fourn_price_fk_soc (fk_soc, entity); ›
Request 61 sql=‹ ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_fk_product FOREIGN KEY (fk_product) REFERENCES llx_product (rowid); ›
Request 62 sql=‹ ALTER TABLE llx_product_fournisseur_price DROP FOREIGN KEY fk_product_fournisseur_price_fk_product_fournisseur; ›
Request 63 sql=‹ DROP TABLE IF EXISTS llx_pos_tmp; ›
Request 64 sql=‹ ALTER TABLE llx_deplacement ADD COLUMN fk_user_modif integer AFTER fk_user_author; ›
Request 65 sql=‹ CREATE TABLE llx_localtax(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer NOT NULL DEFAULT ‹ 1 ›,tms timestamp,datep date DEFAULT NULL,datev date DEFAULT NULL,amount double NOT NULL DEFAULT ‹ 0 ›,label varchar(255) DEFAULT NULL,note text,fk_bank integer DEFAULT NULL,fk_user_creat integer DEFAULT NULL,fk_user_modif integer DEFAULT NULL) ENGINE=InnoDB; ›
Request 66 sql=‹ ALTER TABLE llx_propal MODIFY ref_int varchar(255); ›
Request 67 sql=‹ ALTER TABLE llx_propal MODIFY ref_ext varchar(255); ›
Request 68 sql=‹ ALTER TABLE llx_propal MODIFY ref_client varchar(255); ›
Request 69 sql=‹ ALTER TABLE llx_commande MODIFY ref_int varchar(255); ›
Request 70 sql=‹ ALTER TABLE llx_commande MODIFY ref_ext varchar(255); ›
Request 71 sql=‹ ALTER TABLE llx_commande MODIFY ref_client varchar(255); ›
Request 72 sql=‹ ALTER TABLE llx_facture MODIFY ref_int varchar(255); ›
Request 73 sql=‹ ALTER TABLE llx_facture MODIFY ref_ext varchar(255); ›
Request 74 sql=‹ ALTER TABLE llx_facture MODIFY ref_client varchar(255); ›
Request 75 sql=‹ UPDATE llx_societe SET fk_stcomm = 0 WHERE fk_stcomm IS NULL; ›
Request 76 sql=‹ ALTER TABLE llx_societe MODIFY COLUMN fk_stcomm integer NOT NULL; ›
Request 77 sql=‹ ALTER TABLE llx_societe CHANGE COLUMN gencod barcode varchar(255); ›
Request 78 sql=‹ ALTER TABLE llx_societe ADD COLUMN fk_barcode_type integer DEFAULT 0; ›
Request 79 sql=‹ UPDATE llx_menu SET leftmenu = NULL where leftmenu in ( ›’, ‹ 0 ›, ‹ 1 ›);’
Request 80 sql=‹ ALTER TABLE llx_categorie_societe DROP INDEX fk_categorie; ›
Request 81 sql=‹ ALTER TABLE llx_categorie_societe DROP INDEX fk_societe; ›
Erreur DB_ERROR_1553: ALTER TABLE llx_categorie_societe DROP INDEX fk_societe;
Cannot drop index ‹ fk_societe ›: needed in a foreign key constraint
Request 82 sql=‹ ALTER TABLE llx_categorie_fournisseur DROP INDEX fk_categorie; ›
Request 83 sql=‹ ALTER TABLE llx_categorie_fournisseur ADD PRIMARY KEY pk_categorie_fournisseur (fk_categorie, fk_societe); ›
Request 84 sql=‹ ALTER TABLE llx_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_categorie (fk_categorie); ›
Request 85 sql=‹ ALTER TABLE llx_categorie_fournisseur ADD INDEX idx_categorie_fournisseur_fk_societe (fk_societe); ›
Request 86 sql=‹ DELETE FROM llx_categorie_fournisseur WHERE fk_categorie NOT IN (SELECT rowid FROM llx_categorie); ›
Request 87 sql=‹ DELETE FROM llx_categorie_fournisseur WHERE fk_societe NOT IN (SELECT rowid FROM llx_societe); ›
Request 88 sql=‹ ALTER TABLE llx_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid); ›
Request 89 sql=‹ ALTER TABLE llx_categorie_fournisseur ADD CONSTRAINT fk_categorie_fournisseur_fk_soc FOREIGN KEY (fk_societe) REFERENCES llx_societe (rowid); ›
Request 90 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23201, 232, 23201, ‹ ›, 0, ‹ Los Andes ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23201, 232, 23201, ‹ ›, 0, ‹ Los Andes ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 91 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23202, 232, 23202, ‹ ›, 0, ‹ Capital ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23202, 232, 23202, ‹ ›, 0, ‹ Capital ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 92 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23203, 232, 23203, ‹ ›, 0, ‹ Central ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23203, 232, 23203, ‹ ›, 0, ‹ Central ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 93 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23204, 232, 23204, ‹ ›, 0, ‹ Cento Occidental ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23204, 232, 23204, ‹ ›, 0, ‹ Cento Occidental ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 94 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23205, 232, 23205, ‹ ›, 0, ‹ Guayana ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23205, 232, 23205, ‹ ›, 0, ‹ Guayana ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 95 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23206, 232, 23206, ‹ ›, 0, ‹ Insular ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23206, 232, 23206, ‹ ›, 0, ‹ Insular ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 96 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23207, 232, 23207, ‹ ›, 0, ‹ Los Llanos ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23207, 232, 23207, ‹ ›, 0, ‹ Los Llanos ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 97 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23208, 232, 23208, ‹ ›, 0, ‹ Nor-Oriental ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23208, 232, 23208, ‹ ›, 0, ‹ Nor-Oriental ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 98 sql=‹ INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23209, 232, 23209, ‹ ›, 0, ‹ Zuliana ›, 1); ›
Erreur DB_ERROR_1452: INSERT INTO llx_c_regions (rowid, fk_pays, code_region, cheflieu, tncc, nom, active) VALUES (23209, 232, 23209, ‹ ›, 0, ‹ Zuliana ›, 1);
Cannot add or update a child row: a foreign key constraint fails (dolibarr2.llx_c_regions, CONSTRAINT fk_c_regions_fk_pays FOREIGN KEY (fk_pays) REFERENCES llx_c_pays (rowid))
Request 99 sql='INSERT INTO llx_c_departements ( code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES (‹ VE-L ›, 23201, ‹ ›, 0, ‹ VE-L ›,
repair.php
exécution du script : OK
upgrade.php
KO aux mêmes endroits
Moi aussi j’ai le problème mais de 3.1.0 à 3.2.2
Erreur DB_ERROR_1553: ALTER TABLE llx_categorie_societe DROP INDEX fk_societe;
Cannot drop index ‹ fk_societe ›: needed in a foreign key constraint
repair.php ne résoud pas le problème
Essayez de faire une maj 3.1.0 vers 3.2.0 avant !
[code]
http://votre_url_dolibarr/install/upgrade.php?action=upgrade&selectlang=fr_FR&versionfrom=3.1.0&versionto=3.2.0[/code
Pas mieux !
Je suis remonté plus loin …
J’ai fais 3.1.0 vers 3.1.1 et c’est OK
J’ai fais 3.1.1 vers 3.2.0 et c’est KO
L’exécution de la requete 81 dans phpmyadmin donne la même erreur
Essayez en désactivant le contôle des clefs étrangères avant via phpmyadmin
J’ai fais autrement: j’ai effacé le fichier conf
