Hallo zusammen,
leider tritt bei dem Update auf die Version 10.0.4 ein Fehler auf.
System:
Windows Server 2019
IIS
PHP 7.3
MySQL 8
Download von Sourceforge.
Error/Problem/Fehler:
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‘
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‘
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:
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=‚ALTER TABLE llx_holiday MODIFY COLUMN ref varchar(30) NULL;‘
Request 149 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 150 sql=‚ALTER TABLE llx_reception ADD UNIQUE INDEX idx_reception_uk_ref (ref, entity);‘
Request 151 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_soc (fk_soc);‘
Request 152 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_user_author (fk_user_author);‘
Request 153 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_user_valid (fk_user_valid);‘
Request 154 sql=‚ALTER TABLE llx_reception ADD INDEX idx_reception_fk_shipping_method (fk_shipping_method);‘
Request 155 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 156 sql=‚ALTER TABLE llx_reception_extrafields ADD INDEX idx_reception_extrafields (fk_object);‘
Request 157 sql=‚ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN fk_projet integer DEFAULT NULL;‘
Request 158 sql=‚ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN fk_reception integer DEFAULT NULL;‘
Request 159 sql=‚ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL after date_validated;‘
Request 160 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 161 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (111, ‚supplier_proposal‘, ‚external‘, ‚BILLING‘, ‚Contact fournisseur facturation‘, 1);‘
Request 162 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (112, ‚supplier_proposal‘, ‚external‘, ‚SHIPPING‘, ‚Contact fournisseur livraison‘, 1);‘
Request 163 sql=‚insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (113, ‚supplier_proposal‘, ‚external‘, ‚SERVICE‘, ‚Contact fournisseur prestation‘, 1);‘
Request 164 sql=‚ALTER TABLE llx_ticket_extrafields ADD INDEX idx_ticket_extrafields (fk_object);‘
Request 165 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 166 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 KO
