Hallo zusammen,
Leider tritt beim Update auf Version 10.0.3 ein Fehler auf.
Können Sie mir sagen, wie Sie das Problem beheben können?
Hello everybody,
Unfortunately, an error occurs during the update to version 10.0.3.
Can you tell me how to fix the problem?
Problem/Fehler:
Request 110 sql=‚ALTER TABLE llx_bom_bom ADD CONSTRAINT llx_bom_bom_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);‘
Fehler DB_ERROR_1826: ALTER TABLE llx_bom_bom ADD CONSTRAINT llx_bom_bom_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);
Duplicate foreign key constraint name ‚llx_bom_bom_fk_user_creat‘
Request 117 sql=‚ALTER TABLE llx_bom_bomline ADD CONSTRAINT llx_bom_bomline_fk_bom FOREIGN KEY (fk_bom) REFERENCES llx_bom_bom(rowid);‘
Fehler DB_ERROR_1826: ALTER TABLE llx_bom_bomline ADD CONSTRAINT llx_bom_bomline_fk_bom FOREIGN KEY (fk_bom) REFERENCES llx_bom_bom(rowid);
Duplicate foreign key constraint name ‚llx_bom_bomline_fk_bom‘
Request 123 sql=‚ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid);‘
Fehler DB_ERROR_1826: ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid);
Duplicate foreign key constraint name ‚fk_product_fournisseur_price_barcode_type‘
LOG:
Version Erstinstallation 10.0.2
Database Datenbankmigration (Struktur und einige Daten)
Serververbindung : localhost OK
Datenbankverbindung : dolibarr OK
Version des Datenbankservers 8.0.17
Client-Zeichensatz utf8
Client Sortierreihenfolge utf8_general_ci
Bitte haben Sie ein wenig Geduld …
Verwendetes Migrationsskript: 9.0.0-10.0.0.sql
Request 1 sql=‚ALTER TABLE llx_actioncomm MODIFY COLUMN code varchar(50);‘
Request 2 sql=‚DROP TABLE llx_ticket_logs;‘
Request 3 sql=‚CREATE TABLE llx_pos_cash_fence(rowid INTEGER AUTO_INCREMENT PRIMARY KEY,entity INTEGER DEFAULT 1 NOT NULL,ref VARCHAR(64),label VARCHAR(255),opening double(24,8) default 0,cash double(24,8) default 0,card double(24,8) default 0,cheque double(24,8) default 0,status INTEGER,date_creation DATETIME NOT NULL,date_valid DATETIME,day_close INTEGER,month_close INTEGER,year_close INTEGER,posmodule VARCHAR(30),posnumber VARCHAR(30),fk_user_creat integer,fk_user_valid integer,tms TIMESTAMP NOT NULL,import_key VARCHAR(14)) ENGINE=innodb;‘
Request 4 sql=‚UPDATE llx_chargesociales SET date_creation = tms WHERE date_creation IS NULL;‘
Request 5 sql=‚DROP TABLE llx_cotisation;‘
Request 6 sql=‚ALTER TABLE llx_accounting_bookkeeping DROP COLUMN validated;‘
Request 7 sql=‚ALTER TABLE llx_accounting_bookkeeping_tmp DROP COLUMN validated;‘
Request 8 sql=‚ALTER TABLE llx_loan ADD COLUMN insurance_amount double(24,8) DEFAULT 0;‘
Request 9 sql=‚ALTER TABLE llx_facture DROP INDEX idx_facture_uk_facnumber;‘
Request 10 sql=‚ALTER TABLE llx_facture CHANGE facnumber ref VARCHAR(30) NOT NULL;‘
Request 11 sql=‚ALTER TABLE llx_facture ADD UNIQUE INDEX uk_facture_ref (ref, entity);‘
Request 12 sql=‚insert into llx_c_action_trigger (code,label,description,elementtype,rang) values (‚TICKET_CREATE‘,‚Ticket created‘,‚Executed when a ticket is created‘,‚ticket‘,161);‘
Request 13 sql=‚insert into llx_c_action_trigger (code,label,description,elementtype,rang) values (‚TICKET_MODIFY‘,‚Ticket modified‘,‚Executed when a ticket is modified‘,‚ticket‘,163);‘
Request 14 sql=‚insert into llx_c_action_trigger (code,label,description,elementtype,rang) values (‚TICKET_ASSIGNED‘,‚Ticket assigned‘,‚Executed when a ticket is assigned to another user‘,‚ticket‘,164);‘
Request 15 sql=‚insert into llx_c_action_trigger (code,label,description,elementtype,rang) values (‚TICKET_CLOSE‘,‚Ticket closed‘,‚Executed when a ticket is closed‘,‚ticket‘,165);‘
Request 16 sql=‚insert into llx_c_action_trigger (code,label,description,elementtype,rang) values (‚TICKET_SENTBYMAIL‘,‚Ticket message sent by email‘,‚Executed when a message is sent from the ticket record‘,‚ticket‘,166);‘
Request 17 sql=‚insert into llx_c_action_trigger (code,label,description,elementtype,rang) values (‚TICKET_DELETE‘,‚Ticket deleted‘,‚Executed when a ticket is deleted‘,‚ticket‘,167);‘
Request 18 sql=‚create table llx_mailing_unsubscribe(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,email varchar(255),unsubscribegroup varchar(128) DEFAULT ‚‘,ip varchar(128),date_creat datetime,tms timestamp)ENGINE=innodb;‘
Request 19 sql=‚ALTER TABLE llx_mailing_unsubscribe ADD UNIQUE uk_mailing_unsubscribe(email, entity, unsubscribegroup);‘
Request 20 sql=‚ALTER TABLE llx_adherent ADD gender VARCHAR(10);‘
Request 21 sql=‚ALTER TABLE llx_adherent_type ADD morphy VARCHAR(3);‘
Request 22 sql=‚ALTER TABLE llx_subscription ADD fk_type integer;‘
Request 23 sql=‚UPDATE llx_subscription as s SET fk_type = (SELECT fk_adherent_type FROM llx_adherent as a where a.rowid = s.fk_adherent) where fk_type IS NULL;‘
Request 24 sql=‚ALTER TABLE llx_bank_url DROP INDEX uk_bank_url;‘
Request 25 sql=‚ALTER TABLE llx_bank_url ADD UNIQUE INDEX uk_bank_url (fk_bank, url_id, type);‘
Request 26 sql=‚ALTER TABLE llx_actioncomm ADD COLUMN calling_duration integer;‘
Request 27 sql=‚ALTER TABLE llx_actioncomm ADD COLUMN visibility varchar(12) DEFAULT ‚default‘;‘
Request 28 sql=‚DROP TABLE llx_ticket_msg;‘
Request 29 sql=‚ALTER TABLE llx_don ADD COLUMN fk_soc integer NULL;‘
Request 30 sql=‚ALTER TABLE llx_payment_various ADD COLUMN subledger_account varchar(32);‘
Request 31 sql=‚ALTER TABLE llx_prelevement_facture_demande ADD COLUMN entity integer;‘
Request 32 sql=‚ALTER TABLE llx_prelevement_facture_demande ADD COLUMN sourcetype varchar(32);‘
Request 33 sql=‚ALTER TABLE llx_prelevement_facture_demande ADD COLUMN ext_payment_id varchar(128) NULL;‘
Request 34 sql=‚ALTER TABLE llx_prelevement_facture_demande ADD COLUMN ext_payment_site varchar(128) NULL;‘
Request 35 sql=‚ALTER TABLE llx_c_units DROP INDEX uk_c_units_code;‘
Request 36 sql=‚ALTER TABLE llx_c_units ADD COLUMN scale integer;‘
Request 37 sql=‚ALTER TABLE llx_c_units ADD COLUMN unit_type varchar(10);‘
Request 38 sql=‚CREATE TABLE llx_c_units(rowid integer AUTO_INCREMENT PRIMARY KEY,code varchar(3),scale integer,label varchar(50),short_label varchar(5),unit_type varchar(10),active tinyint DEFAULT 1 NOT NULL) ENGINE=innodb;‘
Request 39 sql=‚ALTER TABLE llx_c_units ADD UNIQUE uk_c_units_code(code);‘
Request 40 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚T‘,‚3‘,‚WeightUnitton‘,‚T‘, ‚weight‘, 1);‘
Request 41 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚KG‘,‚0‘,‚WeightUnitkg‘,‚kg‘, ‚weight‘, 1);‘
Request 42 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚G‘,‘-3’,‚WeightUnitg‘,‚g‘, ‚weight‘, 1);’
Request 43 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚MG‘,‘-6’,‚WeightUnitmg‘,‚mg‘, ‚weight‘, 1);’
Request 44 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚OZ‘,‚98‘,‚WeightUnitounce‘,‚Oz‘, ‚weight‘, 1);‘
Request 45 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚LB‘,‚99‘,‚WeightUnitpound‘,‚lb‘, ‚weight‘, 1);‘
Request 46 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚M‘,‚0‘,‚SizeUnitm‘,‚m‘, ‚size‘, 1);‘
Request 47 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚DM‘,‘-1’,‚SizeUnitdm‘,‚dm‘, ‚size‘, 1);’
Request 48 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚CM‘,‘-2’,‚SizeUnitcm‘,‚cm‘, ‚size‘, 1);’
Request 49 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚MM‘,‘-3’,‚SizeUnitmm‘,‚mm‘, ‚size‘, 1);’
Request 50 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚FT‘,‚98‘,‚SizeUnitfoot‘,‚ft‘, ‚size‘, 1);‘
Request 51 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚IN‘,‚99‘,‚SizeUnitinch‘,‚in‘, ‚size‘, 1);‘
Request 52 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚M2‘,‚0‘,‚SurfaceUnitm2‘,‚m2‘, ‚surface‘, 1);‘
Request 53 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚DM2‘,‘-2’,‚SurfaceUnitdm2‘,‚dm2‘, ‚surface‘, 1);’
Request 54 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚CM2‘,‘-4’,‚SurfaceUnitcm2‘,‚cm2‘, ‚surface‘, 1);’
Request 55 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚MM2‘,‘-6’,‚SurfaceUnitmm2‘,‚mm2‘, ‚surface‘, 1);’
Request 56 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚FT2‘,‚98‘,‚SurfaceUnitfoot2‘,‚ft2‘, ‚surface‘, 1);‘
Request 57 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚IN2‘,‚99‘,‚SurfaceUnitinch2‘,‚in2‘, ‚surface‘, 1);‘
Request 58 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚M3‘,‚0‘,‚VolumeUnitm3‘,‚m3‘, ‚volume‘, 1);‘
Request 59 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚DM3‘,‘-3’,‚VolumeUnitdm3‘,‚dm3‘, ‚volume‘, 1);’
Request 60 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚CM3‘,‘-6’,‚VolumeUnitcm3‘,‚cm3‘, ‚volume‘, 1);’
Request 61 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚MM3‘,‘-9’,‚VolumeUnitmm3‘,‚mm3‘, ‚volume‘, 1);’
Request 62 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚FT3‘,‚88‘,‚VolumeUnitfoot3‘,‚ft3‘, ‚volume‘, 1);‘
Request 63 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚IN3‘,‚89‘,‚VolumeUnitinch3‘,‚in3‘, ‚volume‘, 1);‘
Request 64 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚OZ3‘,‚97‘,‚VolumeUnitounce‘,‚Oz‘, ‚volume‘, 1);‘
Request 65 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚L‘, ‚98‘,‚VolumeUnitlitre‘,‚L‘, ‚volume‘, 1);‘
Request 66 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚GAL‘,‚99‘,‚VolumeUnitgallon‘,‚gal‘, ‚volume‘, 1);‘
Request 67 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚P‘,‚0‘,‚Piece‘,‚p‘, ‚qty‘, 1);‘
Request 68 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚SET‘, ‚0‘,‚Set‘,‚set‘, ‚qty‘, 1);‘
Request 69 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚S‘,‚0‘,‚second‘,‚s‘, ‚time‘, 1);‘
Request 70 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚MI‘,‚60‘,‚minute‘,‚i‘, ‚time‘, 1);‘
Request 71 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚H‘,‚3600‘,‚hour‘,‚h‘, ‚time‘, 1);‘
Request 72 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚D‘,‚86400‘,‚day‘,‚d‘, ‚time‘, 1);‘
Request 73 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚W‘,‚604800‘,‚week‘,‚w‘, ‚time‘, 1);‘
Request 74 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚MO‘,‚2629800‘,‚month‘,‚m‘, ‚time‘, 1);‘
Request 75 sql=‚INSERT INTO llx_c_units (code, scale, label, short_label, unit_type, active) VALUES (‚Y‘,‚31557600‘,‚year‘,‚y‘, ‚time‘, 1);‘
Request 76 sql=‚UPDATE llx_c_units SET short_label = ‚i‘ WHERE code = ‚MI‘;‘
Request 77 sql=‚UPDATE llx_c_units SET unit_type = ‚weight‘, short_label = ‚kg‘, scale = 0 WHERE code = ‚KG‘;‘
Request 78 sql=‚UPDATE llx_c_units SET unit_type = ‚weight‘, short_label = ‚g‘, scale = -3 WHERE code = ‚G‘;‘
Request 79 sql=‚UPDATE llx_c_units SET unit_type = ‚time‘ WHERE code IN (‚S‘,‚H‘,‚D‘);‘
Request 80 sql=‚UPDATE llx_c_units SET unit_type = ‚size‘ WHERE code IN (‚M‘,‚LM‘);‘
Request 81 sql=‚UPDATE llx_c_units SET label = ‚SizeUnitm‘, scale = 0 WHERE code IN (‚M‘);‘
Request 82 sql=‚UPDATE llx_c_units SET active = 0, scale = 0 WHERE code IN (‚LM‘);‘
Request 83 sql=‚UPDATE llx_c_units SET unit_type = ‚surface‘, scale = 0 WHERE code IN (‚M2‘);‘
Request 84 sql=‚UPDATE llx_c_units SET unit_type = ‚volume‘, scale = 0 WHERE code IN (‚M3‘,‚L‘);‘
Request 85 sql=‚UPDATE llx_c_units SET scale = -3, active = 0 WHERE code IN (‚L‘);‘
Request 86 sql=‚UPDATE llx_c_units SET label = ‚VolumeUnitm3‘ WHERE code IN (‚M3‘);‘
Request 87 sql=‚UPDATE llx_c_units SET label = ‚SurfaceUnitm2‘ WHERE code IN (‚M2‘);‘
Request 88 sql=‚ALTER TABLE llx_user ADD COLUMN fk_warehouse INTEGER NULL;‘
Request 89 sql=‚ALTER TABLE llx_commande ADD COLUMN module_source varchar(32);‘
Request 90 sql=‚ALTER TABLE llx_commande ADD COLUMN pos_source varchar(32);‘
Request 91 sql=‚ALTER TABLE llx_societe ADD COLUMN linkedin varchar(255) after whatsapp;‘
Request 92 sql=‚ALTER TABLE llx_socpeople ADD COLUMN linkedin varchar(255) after whatsapp;‘
Request 93 sql=‚ALTER TABLE llx_adherent ADD COLUMN linkedin varchar(255) after whatsapp;‘
Request 94 sql=‚ALTER TABLE llx_user ADD COLUMN linkedin varchar(255) after whatsapp;‘
Request 95 sql=‚ALTER TABLE llx_expensereport_det ADD COLUMN fk_ecm_files integer DEFAULT NULL;‘
Request 96 sql=‚ALTER TABLE llx_expensereport ADD COLUMN paid smallint default 0 NOT NULL;‘
Request 97 sql=‚UPDATE llx_expensereport set paid = 1 WHERE fk_statut = 6 and paid = 0;‘
Request 98 sql=‚CREATE TABLE llx_bom_bom(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,entity integer DEFAULT 1 NOT NULL,ref varchar(128) NOT NULL,label varchar(255),description text,note_public text,note_private text,fk_product integer,qty double(24,8),efficiency double(8,4),date_creation datetime NOT NULL,tms timestamp,date_valid datetime,fk_user_creat integer NOT NULL,fk_user_modif integer,fk_user_valid integer,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;‘
Request 99 sql=‚ALTER TABLE llx_bom_bom ADD COLUMN efficiency double(8,4) DEFAULT 1;‘
Request 100 sql=‚ALTER TABLE llx_bom_bom ADD COLUMN entity integer DEFAULT 1 NOT NULL;‘
Request 101 sql=‚ALTER TABLE llx_bom_bom ADD COLUMN date_valid datetime;‘
Request 102 sql=‚create table llx_bom_bom_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;‘
Request 103 sql=‚CREATE TABLE llx_bom_bomline(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,fk_bom integer NOT NULL,fk_product integer NOT NULL,fk_bom_child integer NULL,description text,import_key varchar(14),qty double(24,8) NOT NULL,efficiency double(8,4) NOT NULL DEFAULT 1,position integer NOT NULL) ENGINE=innodb;‘
Request 104 sql=‚ALTER TABLE llx_bom_bomline ADD COLUMN efficiency double(8,4) DEFAULT 1;‘
Request 105 sql=‚ALTER TABLE llx_bom_bomline ADD COLUMN fk_bom_child integer NULL;‘
Request 106 sql=‚ALTER TABLE llx_bom_bomline ADD COLUMN position integer NOT NULL;‘
Request 107 sql=‚create table llx_bom_bomline_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;‘
Request 108 sql=‚ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_rowid (rowid);‘
Request 109 sql=‚ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_ref (ref);‘
Request 110 sql=‚ALTER TABLE llx_bom_bom ADD CONSTRAINT llx_bom_bom_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);‘
Fehler DB_ERROR_1826: ALTER TABLE llx_bom_bom ADD CONSTRAINT llx_bom_bom_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);
Duplicate foreign key constraint name ‚llx_bom_bom_fk_user_creat‘
Request 111 sql=‚ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_status (status);‘
Request 112 sql=‚ALTER TABLE llx_bom_bom ADD INDEX idx_bom_bom_fk_product (fk_product);‘
Request 113 sql=‚ALTER TABLE llx_bom_bomline ADD INDEX idx_bom_bomline_rowid (rowid);‘
Request 114 sql=‚ALTER TABLE llx_bom_bomline ADD INDEX idx_bom_bomline_fk_product (fk_product);‘
Request 115 sql=‚ALTER TABLE llx_bom_bomline ADD INDEX idx_bom_bomline_fk_bom (fk_bom);‘
Request 116 sql=‚ALTER TABLE llx_bom_bom ADD UNIQUE INDEX uk_bom_bom_ref(ref, entity);‘
Request 117 sql=‚ALTER TABLE llx_bom_bomline ADD CONSTRAINT llx_bom_bomline_fk_bom FOREIGN KEY (fk_bom) REFERENCES llx_bom_bom(rowid);‘
Fehler DB_ERROR_1826: ALTER TABLE llx_bom_bomline ADD CONSTRAINT llx_bom_bomline_fk_bom FOREIGN KEY (fk_bom) REFERENCES llx_bom_bom(rowid);
Duplicate foreign key constraint name ‚llx_bom_bomline_fk_bom‘
Request 118 sql=‚ALTER TABLE llx_product_fournisseur_price ADD COLUMN barcode varchar(180) DEFAULT NULL;‘
Request 119 sql=‚ALTER TABLE llx_product_fournisseur_price ADD COLUMN fk_barcode_type integer DEFAULT NULL;‘
Request 120 sql=‚ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_barcode (barcode);‘
Request 121 sql=‚ALTER TABLE llx_product_fournisseur_price ADD INDEX idx_product_fk_barcode_type (fk_barcode_type);‘
Request 122 sql=‚ALTER TABLE llx_product_fournisseur_price ADD UNIQUE INDEX uk_product_barcode (barcode, fk_barcode_type, entity);‘
Request 123 sql=‚ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid);‘
Fehler DB_ERROR_1826: ALTER TABLE llx_product_fournisseur_price ADD CONSTRAINT fk_product_fournisseur_price_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid);
Duplicate foreign key constraint name ‚fk_product_fournisseur_price_barcode_type‘
Request 124 sql=‚ALTER TABLE llx_facturedet_rec ADD COLUMN buy_price_ht double(24,8) DEFAULT 0;‘
Request 125 sql=‚ALTER TABLE llx_facturedet_rec ADD COLUMN fk_product_fournisseur_price integer DEFAULT NULL;‘
Request 126 sql=‚ALTER TABLE llx_facturedet_rec ADD COLUMN fk_user_author integer;‘
Request 127 sql=‚ALTER TABLE llx_facturedet_rec ADD COLUMN fk_user_modif integer;‘
Request 128 sql=‚ALTER TABLE llx_expensereport_det MODIFY COLUMN value_unit double(24,8) NOT NULL;‘
Request 129 sql=‚ALTER TABLE llx_expensereport_det ADD COLUMN subprice double(24,8) DEFAULT 0 NOT NULL after qty;‘
Request 130 sql=‚ALTER TABLE llx_product_attribute_combination ADD INDEX idx_product_att_com_product_parent (fk_product_parent);‘
Request 131 sql=‚ALTER TABLE llx_product_attribute_combination ADD INDEX idx_product_att_com_product_child (fk_product_child);‘
Request 132 sql=‚ALTER TABLE llx_user ADD COLUMN fk_user_expense_validator integer after fk_user;‘
Request 133 sql=‚ALTER TABLE llx_user ADD COLUMN fk_user_holiday_validator integer after fk_user_expense_validator;‘
Request 134 sql=‚ALTER TABLE llx_user ADD COLUMN personal_email varchar(255) after email;‘
Request 135 sql=‚ALTER TABLE llx_user ADD COLUMN personal_mobile varchar(20) after user_mobile;‘
Request 136 sql=‚ALTER TABLE llx_product ADD COLUMN fk_project integer DEFAULT NULL;‘
Request 137 sql=‚ALTER TABLE llx_product ADD INDEX idx_product_fk_project (fk_project);‘
Request 138 sql=‚ALTER TABLE llx_actioncomm ADD COLUMN calling_duration integer;‘
Request 139 sql=‚ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN datelastok datetime;‘
Request 140 sql=‚ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN maxemailpercollect integer DEFAULT 100;‘
Request 141 sql=‚DELETE FROM llx_const WHERE name = ENCRYPT(‚THEME_ELDY_USE_HOVER‘) AND value = ENCRYPT(‚0‘);‘
Request 142 sql=‚DELETE FROM llx_const WHERE name = ENCRYPT(‚THEME_ELDY_USE_CHECKED‘) AND value = ENCRYPT(‚0‘);‘
Request 143 sql=‚ALTER TABLE llx_inventorydet DROP COLUMN pmp;‘
Request 144 sql=‚ALTER TABLE llx_inventorydet DROP COLUMN pa;‘
Request 145 sql=‚ALTER TABLE llx_inventorydet DROP COLUMN new_pmp;‘
Request 146 sql=‚UPDATE llx_c_shipment_mode SET label = ‚https://www.laposte.fr/outils/suivre-vos-envois?code={TRACKID}‘ WHERE code IN (‚COLSUI‘);‘
Request 147 sql=‚UPDATE llx_c_shipment_mode SET label = ‚https://www.laposte.fr/outils/suivre-vos-envois?code={TRACKID}‘ WHERE code IN (‚LETTREMAX‘);‘
Request 148 sql=‚create table llx_reception(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,ref varchar(30) NOT NULL,entity integer DEFAULT 1 NOT NULL,fk_soc integer NOT NULL,fk_projet integer DEFAULT NULL,ref_ext varchar(30),ref_int varchar(30),ref_supplier varchar(30),date_creation datetime,fk_user_author integer,fk_user_modif integer,date_valid datetime,fk_user_valid integer,date_delivery datetime DEFAULT NULL,date_reception datetime,fk_shipping_method integer,tracking_number varchar(50),fk_statut smallint DEFAULT 0,billed smallint DEFAULT 0,height float,width float,size_units integer,size float,weight_units integer,weight float,note_private text,note_public text,model_pdf varchar(255),fk_incoterms integer,location_incoterms varchar(255),import_key varchar(14),extraparams varchar(255))ENGINE=innodb;‘
Request 149 sql=‚ALTER TABLE llx_reception ADD UNIQUE INDEX idx_reception_uk_ref (ref, entity);‘
Request 150 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_soc (fk_soc);‘
Request 151 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_user_author (fk_user_author);‘
Request 152 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_user_valid (fk_user_valid);‘
Request 153 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_shipping_method (fk_shipping_method);‘
Request 154 sql=‚create table llx_reception_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;‘
Request 155 sql=‚ALTER TABLE llx_reception_extrafields ADD INDEX idx_reception_extrafields (fk_object);‘
Request 156 sql=‚ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN fk_projet integer DEFAULT NULL;‘
Request 157 sql=‚ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN fk_reception integer DEFAULT NULL;‘
Request 158 sql=‚ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL after date_validated;‘
Request 159 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (110, ‚supplier_proposal‘, ‚internal‘, ‚SALESREPFOLL‘, ‚Responsable suivi de la demande‘, 1);‘
Request 160 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (111, ‚supplier_proposal‘, ‚external‘, ‚BILLING‘, ‚Contact fournisseur facturation‘, 1);‘
Request 161 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (112, ‚supplier_proposal‘, ‚external‘, ‚SHIPPING‘, ‚Contact fournisseur livraison‘, 1);‘
Request 162 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (113, ‚supplier_proposal‘, ‚external‘, ‚SERVICE‘, ‚Contact fournisseur prestation‘, 1);‘
Request 163 sql=‚ALTER TABLE llx_ticket_extrafields ADD INDEX idx_ticket_extrafields (fk_object);‘
Request 164 sql=‚UPDATE llx_facturedet AS fd LEFT JOIN llx_facture AS f ON f.rowid = fd.fk_facture SET fd.special_code = 4 WHERE f.module_source = ‚takepos‘ AND fd.special_code = 3;‘
Request 165 sql=‚UPDATE llx_website_page set fk_user_creat = fk_user_modif WHERE fk_user_creat IS NULL and fk_user_modif IS NOT NULL;‘
Script-Verarbeitung
