Erreur lors de mise a jour 11.0.1 vers 11.0.3

Choix du script de migration 10.0.0-11.0.0.sql
Request 1 sql='ALTER TABLE bk_account_bookkeeping ADD COLUMN date_export datetime DEFAULT NULL;'
Request 2 sql='ALTER TABLE bk_expensereport ADD COLUMN paid smallint default 0 NOT NULL;'
Request 3 sql='UPDATE bk_expensereport set paid = 1 WHERE fk_statut = 6 and paid = 0;'
Request 4 sql='UPDATE bk_c_units SET short_label = 'i' WHERE code = 'MI';'
Request 5 sql='UPDATE bk_c_units SET unit_type = 'weight', short_label = 'kg', scale = 0 WHERE code = 'KG';'
Request 6 sql='UPDATE bk_c_units SET unit_type = 'weight', short_label = 'g', scale = -3 WHERE code = 'G';'
Request 7 sql='UPDATE bk_c_units SET unit_type = 'time' WHERE code IN ('S','H','D');'
Request 8 sql='UPDATE bk_c_units SET unit_type = 'size' WHERE code IN ('M','LM');'
Request 9 sql='UPDATE bk_c_units SET label = 'SizeUnitm', scale = 0 WHERE code IN ('M');'
Request 10 sql='UPDATE bk_c_units SET active = 0, scale = 0 WHERE code IN ('LM');'
Request 11 sql='UPDATE bk_c_units SET unit_type = 'surface', scale = 0 WHERE code IN ('M2');'
Request 12 sql='UPDATE bk_c_units SET unit_type = 'volume', scale = 0 WHERE code IN ('M3','L');'
Request 13 sql='UPDATE bk_c_units SET scale = -3, active = 0 WHERE code IN ('L');'
Request 14 sql='UPDATE bk_c_units SET label = 'VolumeUnitm3' WHERE code IN ('M3');'
Request 15 sql='UPDATE bk_c_units SET label = 'SurfaceUnitm2' WHERE code IN ('M2');'
Request 16 sql='ALTER TABLE bk_adherent_type ADD UNIQUE INDEX uk_adherent_type_libelle (libelle, entity);'
Request 17 sql='ALTER TABLE bk_mailing_cibles MODIFY COLUMN lastname varchar(160);'
Request 18 sql='ALTER TABLE bk_mailing_cibles MODIFY COLUMN firstname varchar(160);'
Request 19 sql='ALTER TABLE bk_emailcollector_emailcollector ADD COLUMN login varchar(128);'
Request 20 sql='ALTER TABLE bk_emailcollector_emailcollector ADD COLUMN codelastresult varchar(16);'
Request 21 sql='ALTER TABLE bk_emailcollector_emailcollectoraction ADD COLUMN position integer DEFAULT 0;'
Request 22 sql='ALTER TABLE bk_product_price MODIFY COLUMN tva_tx double(6,3) DEFAULT 0 NOT NULL;'
Request 23 sql='ALTER TABLE bk_facturedet MODIFY COLUMN situation_percent real DEFAULT 100;'
Request 24 sql='UPDATE bk_facturedet SET situation_percent = 100 WHERE situation_percent IS NULL AND fk_prev_id IS NULL;'
Request 25 sql='UPDATE bk_accounting_system SET fk_country = NULL, active = 0 WHERE pcg_version = 'SYSCOHADA';'
Request 26 sql='INSERT INTO bk_accounting_system (fk_country, pcg_version, label, active) VALUES ( 20, 'BAS-K1-MINI', 'The Swedish mini chart of accounts', 1);'
Request 27 sql='ALTER TABLE bk_c_action_trigger MODIFY COLUMN elementtype varchar(64) NOT NULL;'
Request 28 sql='ALTER TABLE bk_societe_account ADD COLUMN site_account varchar(128);'
Request 29 sql='UPDATE bk_holiday SET ref = rowid WHERE ref IS NULL;'
Request 30 sql='ALTER TABLE bk_holiday MODIFY COLUMN ref varchar(30) NOT NULL;'
Request 31 sql='ALTER TABLE bk_c_email_senderprofile MODIFY COLUMN active tinyint DEFAULT 1 NOT NULL;'
Request 32 sql='insert into bk_c_type_container (code,label,module,active) values ('menu', 'Menu', 'system', 1);'
Request 33 sql='INSERT INTO bk_c_ticket_type (code, pos, label, active, use_default, description) VALUES('HELP', '15', 'Request for functionnal help', 1, 0, NULL);'
Request 34 sql='ALTER TABLE bk_don ADD COLUMN fk_user_modif integer;'
Request 35 sql='ALTER TABLE bk_expeditiondet ADD INDEX idx_expeditiondet_fk_origin_line (fk_origin_line);'
Request 36 sql='ALTER TABLE bk_rights_def ADD COLUMN module_position INTEGER NOT NULL DEFAULT 0;'
Request 37 sql='ALTER TABLE bk_rights_def ADD COLUMN family_position INTEGER NOT NULL DEFAULT 0;'
Request 38 sql='UPDATE bk_rights_def SET subperms = 'write' WHERE perms = 'fiscalyear' AND module = 'accounting' AND subperms IS NULL;'
Request 39 sql='ALTER TABLE bk_bom_bom ADD COLUMN duration double(24,8) DEFAULT NULL;'
Request 40 sql='ALTER TABLE bk_bom_bom ADD COLUMN fk_warehouse integer;'
Request 41 sql='ALTER TABLE bk_bom_bomline ADD COLUMN position integer NOT NULL DEFAULT 0;'
Request 42 sql='ALTER TABLE bk_bom_bomline ADD COLUMN qty_frozen smallint DEFAULT 0;'
Request 43 sql='ALTER TABLE bk_bom_bomline ADD COLUMN disable_stock_change smallint DEFAULT 0;'
Request 44 sql='ALTER TABLE bk_bom_bomline DROP COLUMN rank;'
**Erreur DB_ERROR_SYNTAX: ALTER TABLE bk_bom_bomline DROP COLUMN rank;**
**You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank' at line 1**
Request 45 sql='create table bk_categorie_warehouse(fk_categorie integer NOT NULL,fk_warehouse integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 46 sql='ALTER TABLE bk_categorie_warehouse ADD PRIMARY KEY pk_categorie_warehouse (fk_categorie, fk_warehouse);'
Request 47 sql='ALTER TABLE bk_categorie_warehouse ADD INDEX idx_categorie_warehouse_fk_categorie (fk_categorie);'
Request 48 sql='ALTER TABLE bk_categorie_warehouse ADD INDEX idx_categorie_warehouse_fk_warehouse (fk_warehouse);'
Request 49 sql='ALTER TABLE bk_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES bk_categorie (rowid);'
**Erreur DB_ERROR_1826: ALTER TABLE bk_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES bk_categorie (rowid);**
**Duplicate foreign key constraint name 'fk_categorie_warehouse_categorie_rowid'**
Request 50 sql='ALTER TABLE bk_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_fk_warehouse_rowid FOREIGN KEY (fk_warehouse) REFERENCES bk_entrepot (rowid);'
**Erreur DB_ERROR_1826: ALTER TABLE bk_categorie_warehouse ADD CONSTRAINT fk_categorie_warehouse_fk_warehouse_rowid FOREIGN KEY (fk_warehouse) REFERENCES bk_entrepot (rowid);**
**Duplicate foreign key constraint name 'fk_categorie_warehouse_fk_warehouse_rowid'**
Request 51 sql='create table bk_holiday_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 52 sql='ALTER TABLE bk_holiday_extrafields ADD INDEX idx_holiday_extrafields (fk_object);'
Request 53 sql='ALTER TABLE bk_societe_rib MODIFY label varchar(200);'
Request 54 sql='ALTER TABLE bk_societe ADD COLUMN logo_squarred varchar(255);'
Request 55 sql='insert into bk_c_action_trigger (code,label,description,elementtype,rang) values ('USER_SENTBYMAIL','Email sent','Executed when an email is sent from user card','user',300);'
Request 56 sql='create table bk_entrepot_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 57 sql='ALTER TABLE bk_entrepot_extrafields ADD INDEX idx_entrepot_extrafields (fk_object);'
Request 58 sql='ALTER TABLE bk_extrafields ADD COLUMN printable boolean DEFAULT FALSE;'
Request 59 sql='ALTER TABLE bk_facture ADD COLUMN retained_warranty real DEFAULT NULL after situation_final;'
Request 60 sql='ALTER TABLE bk_facture ADD COLUMN retained_warranty_date_limit date DEFAULT NULL after retained_warranty;'
Request 61 sql='ALTER TABLE bk_facture ADD COLUMN retained_warranty_fk_cond_reglement integer DEFAULT NULL after retained_warranty_date_limit;'
Request 62 sql='ALTER TABLE bk_facture ADD COLUMN date_closing datetime DEFAULT NULL after date_valid;'
Request 63 sql='ALTER TABLE bk_facture ADD COLUMN fk_user_closing integer DEFAULT NULL after fk_user_valid;'
Request 64 sql='ALTER TABLE bk_c_shipment_mode ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 65 sql='ALTER TABLE bk_c_shipment_mode DROP INDEX uk_c_shipment_mode;'
Request 66 sql='ALTER TABLE bk_c_shipment_mode ADD UNIQUE INDEX uk_c_shipment_mode (code, entity);'
Request 67 sql='ALTER TABLE bk_facture_fourn DROP COLUMN total;'
Request 68 sql='ALTER TABLE bk_user ADD COLUMN iplastlogin varchar(250);'
Request 69 sql='ALTER TABLE bk_user ADD COLUMN ippreviouslogin varchar(250);'
Request 70 sql='ALTER TABLE bk_events ADD COLUMN prefix_session varchar(255) NULL;'
Request 71 sql='create table bk_payment_salary_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14))ENGINE=innodb;'
Request 72 sql='ALTER TABLE bk_payment_salary_extrafields ADD INDEX idx_payment_salary_extrafields (fk_object);'
Request 73 sql='ALTER TABLE bk_c_price_expression MODIFY COLUMN expression varchar(255) NOT NULL;'
Request 74 sql='UPDATE bk_bank_url set url = REPLACE( url, 'compta/salaries/', 'salaries/');'
Request 75 sql='ALTER TABLE bk_stock_mouvement ADD COLUMN fk_projet INTEGER NOT NULL DEFAULT 0 AFTER model_pdf;'
Request 76 sql='ALTER TABLE bk_oauth_token ADD COLUMN fk_soc integer DEFAULT NULL after token;'
Request 77 sql='ALTER TABLE bk_adherent_type ADD COLUMN duration varchar(6) DEFAULT NULL after morphy;'
Request 78 sql='ALTER TABLE bk_mailing ADD COLUMN tms timestamp;'
Request 79 sql='ALTER TABLE bk_mailing_cibles ADD COLUMN tms timestamp;'
Request 80 sql='ALTER TABLE bk_projet ADD COLUMN usage_opportunity integer DEFAULT 0;'
Request 81 sql='ALTER TABLE bk_projet ADD COLUMN usage_task integer DEFAULT 1;'
Request 82 sql='ALTER TABLE bk_projet CHANGE COLUMN bill_time usage_bill_time integer DEFAULT 0;'
Request 83 sql='ALTER TABLE bk_projet ADD COLUMN usage_organize_event integer DEFAULT 0;'
Request 84 sql='UPDATE bk_projet set usage_opportunity = 1 WHERE fk_opp_status > 0;'
Request 85 sql='create table bk_societe_contacts(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,date_creation datetime NOT NULL,fk_soc integer NOT NULL,fk_c_type_contact int NOT NULL,fk_socpeople integer NOT NULL,tms TIMESTAMP,import_key VARCHAR(14))ENGINE=innodb;'
Request 86 sql='ALTER TABLE bk_societe_contacts ADD UNIQUE INDEX idx_societe_contacts_idx1 (entity, fk_soc, fk_c_type_contact, fk_socpeople);'
Request 87 sql='ALTER TABLE bk_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_c_type_contact FOREIGN KEY (fk_c_type_contact) REFERENCES bk_c_type_contact(rowid);'
**Erreur DB_ERROR_1826: ALTER TABLE bk_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_c_type_contact FOREIGN KEY (fk_c_type_contact) REFERENCES bk_c_type_contact(rowid);**
**Duplicate foreign key constraint name 'fk_societe_contacts_fk_c_type_contact'**
**Request 88 sql='ALTER TABLE bk_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_soc FOREIGN KEY (fk_soc) REFERENCES bk_societe(rowid);'**
**Erreur DB_ERROR_1826: ALTER TABLE bk_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_soc FOREIGN KEY (fk_soc) REFERENCES bk_societe(rowid);**
**Duplicate foreign key constraint name 'fk_societe_contacts_fk_soc'**
**Request 89 sql='ALTER TABLE bk_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_socpeople FOREIGN KEY (fk_socpeople) REFERENCES bk_socpeople(rowid);'**
**Erreur DB_ERROR_1826: ALTER TABLE bk_societe_contacts ADD CONSTRAINT fk_societe_contacts_fk_socpeople FOREIGN KEY (fk_socpeople) REFERENCES bk_socpeople(rowid);**
**Duplicate foreign key constraint name 'fk_societe_contacts_fk_socpeople'**
Request 90 sql='ALTER TABLE bk_accounting_account MODIFY COLUMN rowid bigint AUTO_INCREMENT;'
Request 91 sql='ALTER TABLE bk_supplier_proposaldet ADD COLUMN date_start datetime DEFAULT NULL;'
Request 92 sql='ALTER TABLE bk_supplier_proposaldet ADD COLUMN date_end datetime DEFAULT NULL;'
Request 93 sql='create table bk_c_hrm_public_holiday(id integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 0 NOT NULL,fk_country integer,code varchar(62),dayrule varchar(64) DEFAULT '',day integer,month integer,year integer,active integer DEFAULT 1,import_key varchar(14))ENGINE=innodb;'
Request 94 sql='ALTER TABLE bk_c_hrm_public_holiday ADD UNIQUE INDEX uk_c_hrm_public_holiday(entity, code);'
Request 95 sql='ALTER TABLE bk_c_hrm_public_holiday ADD UNIQUE INDEX uk_c_hrm_public_holiday2(entity, fk_country, dayrule, day, month, year);'
Request 96 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('NEWYEARDAY1', 0, 0, 0, 1, 1, 1);'
Request 97 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('LABORDAY1', 0, 0, 0, 5, 1, 1);'
Request 98 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('ASSOMPTIONDAY1', 0, 0, 0, 8, 15, 1);'
Request 99 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('CHRISTMASDAY1', 0, 0, 0, 12, 25, 1);'
Request 100 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-VICTORYDAY', 0, 1, '', 0, 5, 8, 1);'
Request 101 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-NATIONALDAY', 0, 1, '', 0, 7, 14, 1);'
Request 102 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ASSOMPTION', 0, 1, '', 0, 8, 15, 1);'
Request 103 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-TOUSSAINT', 0, 1, '', 0, 11, 1, 1);'
Request 104 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ARMISTICE', 0, 1, '', 0, 11, 11, 1);'
Request 105 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-EASTER', 0, 1, 'eastermonday', 0, 0, 0, 1);'
Request 106 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-ASCENSION', 0, 1, 'ascension', 0, 0, 0, 1);'
Request 107 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('FR-PENTECOST', 0, 1, 'pentecost', 0, 0, 0, 1);'
Request 108 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-LIBEAZIONE', 0, 3, 0, 4, 25, 1);'
Request 109 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-EPIPHANY', 0, 3, 0, 6, 1, 1);'
Request 110 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-REPUBBLICA', 0, 3, 0, 6, 2, 1);'
Request 111 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-TUTTISANTIT', 0, 3, 0, 11, 1, 1);'
Request 112 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-IMMACULE', 0, 3, 0, 12, 8, 1);'
Request 113 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, year, month, day, active) VALUES('IT-SAINTSTEFAN', 0, 3, 0, 12, 26, 1);'
Request 114 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-EASTER', 0, 4, 'easter', 0, 0, 0, 1);'
Request 115 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-REYE', 0, 4, '', 0, 6, 1, 1);'
Request 116 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-HISPANIDAD', 0, 4, '', 0, 10, 12, 1);'
Request 117 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-TOUSSAINT', 0, 4, '', 0, 11, 1, 1);'
Request 118 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-CONSTITUIZION', 0, 4, '', 0, 12, 6, 1);'
Request 119 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('ES-IMMACULE', 0, 4, '', 0, 12, 8, 1);'
Request 120 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-EASTER', 0, 41, 'eastermonday', 0, 0, 0, 1);'
Request 121 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-ASCENSION', 0, 41, 'ascension', 0, 0, 0, 1);'
Request 122 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-PENTECOST', 0, 41, 'pentecost', 0, 0, 0, 1);'
Request 123 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-FRONLEICHNAM', 0, 41, 'fronleichnam', 0, 0, 0, 1);'
Request 124 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-KONEGIE', 0, 41, '', 0, 6, 1, 1);'
Request 125 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-26OKT', 0, 41, '', 0, 10, 26, 1);'
Request 126 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-TOUSSAINT', 0, 41, '', 0, 11, 1, 1);'
Request 127 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-IMMACULE', 0, 41, '', 0, 12, 8, 1);'
Request 128 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-24DEC', 0, 41, '', 0, 12, 24, 1);'
Request 129 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-SAINTSTEFAN', 0, 41, '', 0, 12, 26, 1);'
Request 130 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('AT-Silvester', 0, 41, '', 0, 12, 31, 1);'
Request 131 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('IN-REPUBLICDAY', 0, 117, '', 0, 1, 26, 1);'
Request 132 sql='INSERT INTO bk_c_hrm_public_holiday (code, entity, fk_country, dayrule, year, month, day, active) VALUES('IN-GANDI', 0, 117, '', 0, 10, 2, 1);'
Request 133 sql='create table bk_c_socialnetworks(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,code varchar(100),label varchar(150),url text,icon varchar(20),active tinyint DEFAULT 1 NOT NULL)ENGINE=innodb;'
Request 134 sql='ALTER TABLE bk_c_socialnetworks ADD UNIQUE INDEX idx_c_socialnetworks_code (code);'
Request 135 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'facebook', 'Facebook', 'https://www.facebook.com/{socialid}', 'fa-facebook', 1);'
Request 136 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'skype', 'Skype', 'https://www.skype.com/{socialid}', 'fa-skype', 1);'
Request 137 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'twitter', 'Twitter', 'https://www.twitter.com/{socialid}', 'fa-twitter', 1);'
Request 138 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'linkedin', 'LinkedIn', 'https://www.linkedin.com/{socialid}', 'fa-linkedin', 1);'
Request 139 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'instagram', 'Instagram', 'https://www.instagram.com/{socialid}', 'fa-instagram', 1);'
Request 140 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'snapchat', 'Snapchat', '{socialid}', 'fa-snapchat', 1);'
Request 141 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'googleplus', 'GooglePlus', 'https://www.googleplus.com/{socialid}', 'fa-google-plus-g', 1);'
Request 142 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'youtube', 'Youtube', 'https://www.youtube.com/{socialid}', 'fa-youtube', 1);'
Request 143 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'whatsapp', 'Whatsapp', '{socialid}', 'fa-whatsapp', 1);'
Request 144 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'tumblr', 'Tumblr', 'https://www.tumblr.com/{socialid}', 'fa-tumblr', 0);'
Request 145 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'vero', 'Vero', 'https://vero.co/{socialid}', '', 0);'
Request 146 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'viadeo', 'Viadeo', 'https://fr.viadeo.com/fr/{socialid}', 'fa-viadeo', 0);'
Request 147 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'slack', 'Slack', '{socialid}', 'fa-slack', 0);'
Request 148 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'xing', 'Xing', '{socialid}', 'fa-xing', 0);'
Request 149 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'meetup', 'Meetup', '{socialid}', 'fa-meetup', 0);'
Request 150 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'pinterest', 'Pinterest', '{socialid}', 'fa-pinterest', 0);'
Request 151 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'flickr', 'Flickr', '{socialid}', 'fa-flickr', 0);'
Request 152 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, '500px', '500px', '{socialid}', 'fa-500px', 0);'
Request 153 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'giphy', 'Giphy', '{socialid}', '', 0);'
Request 154 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'gifycat', 'Gificat', '{socialid}', '', 0);'
Request 155 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'dailymotion', 'Dailymotion', '{socialid}', '', 0);'
Request 156 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'vimeo', 'Vimeo', '{socialid}', '', 0);'
Request 157 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'periscope', 'Periscope', '{socialid}', '', 0);'
Request 158 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'twitch', 'Twitch', '{socialid}', '', 0);'
Request 159 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'discord', 'Discord', '{socialid}', 'fa-discord', 0);'
Request 160 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'wikipedia', 'Wikipedia', '{socialid}', '', 0);'
Request 161 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'reddit', 'Reddit', '{socialid}', 'fa-reddit', 0);'
Request 162 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'quora', 'Quora', '{socialid}', '', 0);'
Request 163 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'tripadvisor', 'Tripadvisor', '{socialid}', '', 0);'
Request 164 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'mastodon', 'Mastodon', '{socialid}', '', 0);'
Request 165 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'diaspora', 'Diaspora', '{socialid}', '', 0);'
Request 166 sql='INSERT INTO bk_c_socialnetworks (entity, code, label, url, icon, active) VALUES(1, 'viber', 'Viber', '{socialid}', '', 0);'
Request 167 sql='ALTER TABLE bk_adherent ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;'
Request 168 sql='ALTER TABLE bk_societe ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;'
Request 169 sql='ALTER TABLE bk_socpeople ADD COLUMN socialnetworks text DEFAULT NULL AFTER email;'
Request 170 sql='ALTER TABLE bk_user ADD COLUMN socialnetworks text DEFAULT NULL AFTER personal_email;'
Request 171 sql='ALTER TABLE bk_product ADD COLUMN net_measure float;'
Request 172 sql='ALTER TABLE bk_product ADD COLUMN net_measure_units tinyint;'
Request 173 sql='create table bk_adherent_type_lang(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_type integer DEFAULT 0 NOT NULL,lang varchar(5) DEFAULT 0 NOT NULL,label varchar(255) NOT NULL,description text,email text,import_key varchar(14) DEFAULT NULL)ENGINE=innodb;'
Request 174 sql='create table bk_fichinter_rec(rowid integer AUTO_INCREMENT PRIMARY KEY,titre varchar(50) NOT NULL,entity integer DEFAULT 1 NOT NULL,fk_soc integer DEFAULT NULL,datec datetime,fk_contrat integer DEFAULT 0,fk_user_author integer,fk_projet integer,duree real,description text,modelpdf varchar(50),note_private text,note_public text,frequency integer,unit_frequency varchar(2) DEFAULT 'm',date_when datetime DEFAULT NULL,date_last_gen datetime DEFAULT NULL,nb_gen_done integer DEFAULT NULL,nb_gen_max integer DEFAULT NULL,auto_validate integer NULL DEFAULT NULL)ENGINE=innodb;'
Request 175 sql='ALTER TABLE bk_fichinter_rec ADD UNIQUE INDEX idx_fichinter_rec_uk_titre (titre, entity);'
Request 176 sql='ALTER TABLE bk_fichinter_rec ADD INDEX idx_fichinter_rec_fk_soc (fk_soc);'
Request 177 sql='ALTER TABLE bk_fichinter_rec ADD INDEX idx_fichinter_rec_fk_user_author (fk_user_author);'
Request 178 sql='ALTER TABLE bk_fichinter_rec ADD INDEX idx_fichinter_rec_fk_projet (fk_projet);'
Request 179 sql='ALTER TABLE bk_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES bk_user (rowid);'
**Erreur DB_ERROR_1826: ALTER TABLE bk_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_user_author FOREIGN KEY (fk_user_author) REFERENCES bk_user (rowid);**
**Duplicate foreign key constraint name 'fk_fichinter_rec_fk_user_author'**
Request 180 sql='ALTER TABLE bk_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_projet FOREIGN KEY (fk_projet) REFERENCES bk_projet (rowid);'
**Erreur DB_ERROR_1826: ALTER TABLE bk_fichinter_rec ADD CONSTRAINT fk_fichinter_rec_fk_projet FOREIGN KEY (fk_projet) REFERENCES bk_projet (rowid);**
**Duplicate foreign key constraint name 'fk_fichinter_rec_fk_projet'**
Request 181 sql='create table bk_fichinterdet_rec(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_fichinter integer NOT NULL,date datetime,description text,duree integer,rang integer DEFAULT 0,total_ht DOUBLE(24, 8) NULL DEFAULT NULL,subprice DOUBLE(24, 8) NULL DEFAULT NULL,fk_parent_line integer NULL DEFAULT NULL,fk_product integer NULL DEFAULT NULL,label varchar(255) NULL DEFAULT NULL,tva_tx DOUBLE(6, 3) NULL DEFAULT NULL,localtax1_tx DOUBLE(6, 3) NULL DEFAULT 0,localtax1_type VARCHAR(1) NULL DEFAULT NULL,localtax2_tx DOUBLE(6, 3) NULL DEFAULT 0,localtax2_type VARCHAR(1) NULL DEFAULT NULL,qty double NULL DEFAULT NULL,remise_percent double NULL DEFAULT 0,remise double NULL DEFAULT 0,fk_remise_except integer NULL DEFAULT NULL,price DOUBLE(24, 8) NULL DEFAULT NULL,total_tva DOUBLE(24, 8) NULL DEFAULT NULL,total_localtax1 DOUBLE(24, 8) NULL DEFAULT 0,total_localtax2 DOUBLE(24, 8) NULL DEFAULT 0,total_ttc DOUBLE(24, 8) NULL DEFAULT NULL,product_type INTEGER NULL DEFAULT 0,date_start datetime NULL DEFAULT NULL,date_end datetime NULL DEFAULT NULL,info_bits INTEGER NULL DEFAULT 0,buy_price_ht DOUBLE(24, 8) NULL DEFAULT 0,fk_product_fournisseur_price integer NULL DEFAULT NULL,fk_code_ventilation integer NOT NULL DEFAULT 0,fk_export_commpta integer NOT NULL DEFAULT 0,special_code integer UNSIGNED NULL DEFAULT 0,fk_unit integer NULL DEFAULT NULL,import_key varchar(14) NULL DEFAULT NULL)ENGINE=innodb;'
Request 182 sql='ALTER TABLE bk_supplier_proposaldet ADD COLUMN date_start datetime DEFAULT NULL AFTER product_type;'
Request 183 sql='ALTER TABLE bk_supplier_proposaldet ADD COLUMN date_end datetime DEFAULT NULL AFTER date_start;'
Request 184 sql='create table bk_expedition_package(rowid integer AUTO_INCREMENT PRIMARY KEY,fk_expedition integer NOT NULL,description varchar(255),value double(24,8) DEFAULT 0,fk_parcel_type integer,height float,width float,size float,size_units integer,weight float,weight_units integer,dangerous_goods smallint DEFAULT 0,tail_lift smallint DEFAULT 0,rang integer DEFAULT 0)ENGINE=innodb;'
Request 185 sql='create table bk_c_shipment_package_type(rowid integer AUTO_INCREMENT PRIMARY KEY,label varchar(50) NOT NULL,description varchar(255),active integer DEFAULT 1 NOT NULL,entity integer DEFAULT 1 NOT NULL)ENGINE=innodb;'
Request 186 sql='CREATE TABLE bk_product_fournisseur_price_extrafields (rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 187 sql='ALTER TABLE bk_product_fournisseur_price_extrafields ADD INDEX idx_product_fournisseur_price_extrafields (fk_object);'
Request 188 sql='CREATE TABLE bk_mrp_mo(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,ref varchar(128) DEFAULT '(PROV)' NOT NULL,entity integer DEFAULT 1 NOT NULL,label varchar(255),qty real NOT NULL,fk_warehouse integer,fk_soc integer,note_public text,note_private text,date_creation datetime NOT NULL,date_valid datetime NULL,tms timestamp,fk_user_creat integer NOT NULL,fk_user_modif integer,fk_user_valid integer,model_pdf varchar(255),import_key varchar(14),status integer NOT NULL,fk_product integer NOT NULL,date_start_planned datetime,date_end_planned datetime,fk_bom integer,fk_project integer) ENGINE=innodb;'
Request 189 sql='ALTER TABLE bk_mrp_mo ADD COLUMN date_valid datetime NULL;'
Request 190 sql='ALTER TABLE bk_mrp_mo ADD COLUMN fk_user_valid integer;'
Request 191 sql='ALTER TABLE bk_bom_bom ADD COLUMN model_pdf varchar(255);'
Request 192 sql='ALTER TABLE bk_mrp_mo ADD COLUMN model_pdf varchar(255);'
Request 193 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_ref (ref);'
Request 194 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_entity (entity);'
Request 195 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_fk_soc (fk_soc);'
Request 196 sql='ALTER TABLE bk_mrp_mo ADD CONSTRAINT fk_mrp_mo_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES bk_user(rowid);'
**Erreur DB_ERROR_1826: ALTER TABLE bk_mrp_mo ADD CONSTRAINT fk_mrp_mo_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES bk_user(rowid);**
**Duplicate foreign key constraint name 'fk_mrp_mo_fk_user_creat'**
Request 197 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_status (status);'
Request 198 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_fk_product (fk_product);'
Request 199 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_date_start_planned (date_start_planned);'
Request 200 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_date_end_planned (date_end_planned);'
Request 201 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_fk_bom (fk_bom);'
Request 202 sql='ALTER TABLE bk_mrp_mo ADD INDEX idx_mrp_mo_fk_project (fk_project);'
Request 203 sql='create table bk_mrp_mo_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 204 sql='ALTER TABLE bk_mrp_mo_extrafields ADD INDEX idx_fk_object(fk_object);'
Request 205 sql='insert into bk_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_VALIDATE','BOM validated','Executed when a BOM is validated','bom',650);'
Request 206 sql='insert into bk_c_action_trigger (code,label,description,elementtype,rang) values ('BOM_UNVALIDATE','BOM unvalidated','Executed when a BOM is unvalidated','bom',651);'

Impossible de poster tous la liste et encore moins d’importer un fichier pdf

Pas de Bonjour ?

Un petite recherche ??

etc…

Mille excuse pour le bonjour car j’ai du supprimé plein de ligne pour pouvoir valider le poste