Dolibarr logo
10.0.1

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : localhostOK
Database connection : jeeblees_doliOK
Database server version10.3.23-MariaDB-cll-lve
Client charsetutf8
Client collationutf8_general_ci
Please be patient...

Choose migration script8.0.0-9.0.0.sql
Request 1 sql='ALTER TABLE llx_contrat_extrafields ADD INDEX idx_contrat_extrafields (fk_object);'
Request 2 sql='ALTER TABLE llx_facture_rec_extrafields ADD INDEX idx_facture_rec_extrafields (fk_object);'
Request 3 sql='ALTER TABLE llx_accounting_account DROP FOREIGN KEY fk_accounting_account_fk_pcg_version;'
Request 4 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN fk_pcg_version varchar(32) NOT NULL;'
Request 5 sql='ALTER TABLE llx_accounting_system MODIFY COLUMN pcg_version varchar(32) NOT NULL;'
Request 6 sql='ALTER TABLE llx_accounting_account ADD CONSTRAINT fk_accounting_account_fk_pcg_version FOREIGN KEY (fk_pcg_version) REFERENCES llx_accounting_system (pcg_version);'
Error DB_ERROR_1452: ALTER TABLE llx_accounting_account ADD CONSTRAINT fk_accounting_account_fk_pcg_version FOREIGN KEY (fk_pcg_version) REFERENCES llx_accounting_system (pcg_version);
Cannot add or update a child row: a foreign key constraint fails (`jeeblees_doli`.`#sql-1a73a9_8f593`, CONSTRAINT `fk_accounting_account_fk_pcg_version` FOREIGN KEY (`fk_pcg_version`) REFERENCES `llx_accounting_system` (`pcg_version`))
Request 7 sql='ALTER TABLE llx_facture ADD COLUMN module_source varchar(32);'
Request 8 sql='ALTER TABLE llx_facture ADD COLUMN pos_source varchar(32);'
Request 9 sql='create table llx_facture_rec_extrafields(rowid integer AUTO_INCREMENT PRIMARY KEY,tms timestamp,fk_object integer NOT NULL,import_key varchar(14)) ENGINE=innodb;'
Request 10 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_subject varchar(255) after email_msgid;'
Request 11 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_tocc varchar(255) after email_to;'
Request 12 sql='ALTER TABLE llx_actioncomm ADD COLUMN email_tobcc varchar(255) after email_tocc;'
Request 13 sql='ALTER TABLE llx_actioncomm MODIFY COLUMN code varchar(50);'
Request 14 sql='ALTER TABLE llx_extrafields ADD COLUMN help text NULL;'
Request 15 sql='ALTER TABLE llx_extrafields ADD COLUMN totalizable boolean DEFAULT FALSE after list;'
Request 16 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN desc_fourn text after ref_fourn;'
Request 17 sql='ALTER TABLE llx_user ADD COLUMN dateemploymentend date after dateemployment;'
Request 18 sql='ALTER TABLE llx_stock_mouvement ADD COLUMN fk_project integer;'
Request 19 sql='ALTER TABLE llx_c_action_trigger MODIFY COLUMN elementtype varchar(32);'
Request 20 sql='ALTER TABLE llx_c_field_list ADD COLUMN visible tinyint DEFAULT 1 NOT NULL AFTER search;'
Request 21 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('COMPANY_DELETE','Third party deleted','Executed when you delete third party','societe',1);'
Request 22 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPAL_DELETE','Customer proposal deleted','Executed when a customer proposal is deleted','propal',2);'
Request 23 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_DELETE','Customer order deleted','Executed when a customer order is deleted','commande',5);'
Request 24 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_DELETE','Customer invoice deleted','Executed when a customer invoice is deleted','facture',9);'
Request 25 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('PROPOSAL_SUPPLIER_DELETE','Price request deleted','Executed when a customer proposal delete','proposal_supplier',10);'
Request 26 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('ORDER_SUPPLIER_DELETE','Supplier order deleted','Executed when a supplier order is deleted','order_supplier',14);'
Request 27 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('BILL_SUPPLIER_DELETE','Supplier invoice deleted','Executed when a supplier invoice is deleted','invoice_supplier',17);'
Request 28 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('CONTRACT_DELETE','Contract deleted','Executed when a contract is deleted','contrat',18);'
Request 29 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('FICHINTER_DELETE','Intervention is deleted','Executed when a intervention is deleted','ficheinter',35);'
Request 30 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('EXPENSE_DELETE','Expense report deleted','Executed when an expense report is deleted','expensereport',204);'
Request 31 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Expense report validated','Executed when an expense report is validated','expensereport',202);'
Request 32 sql='insert into llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE','Expense report approved','Executed when an expense report is approved','expensereport',203);'
Request 33 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8001', 'Aktieselvskab A/S');'
Request 34 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8002', 'Anparts Selvskab ApS');'
Request 35 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8003', 'Personlig ejet selvskab');'
Request 36 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8004', 'Iværksætterselvskab IVS');'
Request 37 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8005', 'Interessentskab I/S');'
Request 38 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8006', 'Holdingselskab');'
Request 39 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8007', 'Selskab Med Begrænset Hæftelse SMBA');'
Request 40 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8008', 'Kommanditselskab K/S');'
Request 41 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (80, '8009', 'SPE-selskab');'
Request 42 sql='ALTER TABLE llx_payment_salary ADD COLUMN ref varchar(30) NULL after rowid;'
Request 43 sql='ALTER TABLE llx_payment_salary ADD COLUMN fk_projet integer DEFAULT NULL after amount;'
Request 44 sql='ALTER TABLE llx_payment_various ADD COLUMN ref varchar(30) NULL after rowid;'
Request 45 sql='ALTER TABLE llx_categorie ADD COLUMN ref_ext varchar(255);'
Request 46 sql='ALTER TABLE llx_paiement ADD COLUMN ext_payment_id varchar(128);'
Request 47 sql='ALTER TABLE llx_paiement ADD COLUMN ext_payment_site varchar(128);'
Request 48 sql='ALTER TABLE llx_societe ADD COLUMN twitter varchar(255) after skype;'
Request 49 sql='ALTER TABLE llx_societe ADD COLUMN facebook varchar(255) after skype;'
Request 50 sql='ALTER TABLE llx_societe ADD COLUMN instagram varchar(255) after skype;'
Request 51 sql='ALTER TABLE llx_societe ADD COLUMN snapchat varchar(255) after skype;'
Request 52 sql='ALTER TABLE llx_societe ADD COLUMN googleplus varchar(255) after skype;'
Request 53 sql='ALTER TABLE llx_societe ADD COLUMN youtube varchar(255) after skype;'
Request 54 sql='ALTER TABLE llx_societe ADD COLUMN whatsapp varchar(255) after skype;'
Request 55 sql='ALTER TABLE llx_socpeople ADD COLUMN twitter varchar(255) after skype;'
Request 56 sql='ALTER TABLE llx_socpeople ADD COLUMN facebook varchar(255) after skype;'
Request 57 sql='ALTER TABLE llx_socpeople ADD COLUMN instagram varchar(255) after skype;'
Request 58 sql='ALTER TABLE llx_socpeople ADD COLUMN snapchat varchar(255) after skype;'
Request 59 sql='ALTER TABLE llx_socpeople ADD COLUMN googleplus varchar(255) after skype;'
Request 60 sql='ALTER TABLE llx_socpeople ADD COLUMN youtube varchar(255) after skype;'
Request 61 sql='ALTER TABLE llx_socpeople ADD COLUMN whatsapp varchar(255) after skype;'
Request 62 sql='ALTER TABLE llx_adherent ADD COLUMN skype varchar(255);'
Request 63 sql='ALTER TABLE llx_adherent ADD COLUMN twitter varchar(255);'
Request 64 sql='ALTER TABLE llx_adherent ADD COLUMN facebook varchar(255);'
Request 65 sql='ALTER TABLE llx_adherent ADD COLUMN instagram varchar(255);'
Request 66 sql='ALTER TABLE llx_adherent ADD COLUMN snapchat varchar(255);'
Request 67 sql='ALTER TABLE llx_adherent ADD COLUMN googleplus varchar(255);'
Request 68 sql='ALTER TABLE llx_adherent ADD COLUMN youtube varchar(255);'
Request 69 sql='ALTER TABLE llx_adherent ADD COLUMN whatsapp varchar(255);'
Request 70 sql='ALTER TABLE llx_user ADD COLUMN skype varchar(255);'
Request 71 sql='ALTER TABLE llx_user ADD COLUMN twitter varchar(255);'
Request 72 sql='ALTER TABLE llx_user ADD COLUMN facebook varchar(255);'
Request 73 sql='ALTER TABLE llx_user ADD COLUMN instagram varchar(255);'
Request 74 sql='ALTER TABLE llx_user ADD COLUMN snapchat varchar(255);'
Request 75 sql='ALTER TABLE llx_user ADD COLUMN googleplus varchar(255);'
Request 76 sql='ALTER TABLE llx_user ADD COLUMN youtube varchar(255);'
Request 77 sql='ALTER TABLE llx_user ADD COLUMN whatsapp varchar(255);'
Request 78 sql='ALTER TABLE llx_website CHANGE COLUMN fk_user_create fk_user_creat integer;'
Request 79 sql='ALTER TABLE llx_website_page CHANGE COLUMN fk_user_create fk_user_creat integer;'
Request 80 sql='ALTER TABLE llx_website ADD COLUMN maincolor varchar(16);'
Request 81 sql='ALTER TABLE llx_website ADD COLUMN maincolorbis varchar(16);'
Request 82 sql='ALTER TABLE llx_website_page ADD COLUMN image varchar(255);'
Request 83 sql='CREATE TABLE llx_takepos_floor_tables(rowid integer AUTO_INCREMENT PRIMARY KEY,entity integer DEFAULT 1 NOT NULL,label varchar(255),leftpos float,toppos float,floor smallint) ENGINE=innodb;'
Request 84 sql='UPDATE llx_c_payment_term SET decalage = nbjour, nbjour = 0 where decalage IS NULL AND type_cdr = 2;'
Request 85 sql='UPDATE llx_holiday SET ref = rowid WHERE ref IS NULL;'
Request 86 sql='CREATE TABLE llx_emailcollector_emailcollector(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,entity integer DEFAULT 1 NOT NULL,ref varchar(128) NOT NULL,label varchar(255),description text,host varchar(255),login varchar(128),password varchar(128),source_directory varchar(255) NOT NULL,target_directory varchar(255),datelastresult datetime,codelastresult varchar(16),lastresult varchar(255),note_public text,note_private text,date_creation datetime NOT NULL,tms timestamp NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;'
Request 87 sql='ALTER TABLE llx_emailcollector_emailcollector ADD COLUMN login varchar(128);'
Request 88 sql='ALTER TABLE llx_emailcollector_emailcollector ADD INDEX idx_emailcollector_entity (entity);'
Request 89 sql='ALTER TABLE llx_emailcollector_emailcollector ADD INDEX idx_emailcollector_status (status);'
Request 90 sql='CREATE TABLE llx_emailcollector_emailcollectorfilter(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,fk_emailcollector INTEGER NOT NULL,type varchar(128) NOT NULL,rulevalue varchar(255) NULL,date_creation datetime NOT NULL,tms timestamp NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;'
Request 91 sql='CREATE TABLE llx_emailcollector_emailcollectoraction(rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL,fk_emailcollector INTEGER NOT NULL,type varchar(128) NOT NULL,actionparam varchar(255) NULL,date_creation datetime NOT NULL,tms timestamp NOT NULL,fk_user_creat integer NOT NULL,fk_user_modif integer,position integer DEFAULT 0,import_key varchar(14),status integer NOT NULL) ENGINE=innodb;'
Request 92 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD INDEX idx_emailcollector_fk_emailcollector (fk_emailcollector);'
Request 93 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD CONSTRAINT fk_emailcollectorfilter_fk_emailcollector FOREIGN KEY (fk_emailcollector) REFERENCES llx_emailcollector_emailcollector(rowid);'
Request 94 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD INDEX idx_emailcollector_fk_emailcollector (fk_emailcollector);'
Request 95 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD CONSTRAINT fk_emailcollectoraction_fk_emailcollector FOREIGN KEY (fk_emailcollector) REFERENCES llx_emailcollector_emailcollector(rowid);'
Request 96 sql='ALTER TABLE llx_emailcollector_emailcollectorfilter ADD UNIQUE INDEX uk_emailcollector_emailcollectorfilter (fk_emailcollector, type, rulevalue);'
Request 97 sql='ALTER TABLE llx_emailcollector_emailcollectoraction ADD UNIQUE INDEX uk_emailcollector_emailcollectoraction (fk_emailcollector, type);'
Request 98 sql='ALTER TABLE llx_societe_rib ADD COLUMN comment varchar(255);'
Request 99 sql='ALTER TABLE llx_societe_rib ADD COLUMN ipaddress varchar(68);'
Request 100 sql='DROP TABLE llx_ticket_logs;'
Request 101 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 102 sql='ALTER TABLE llx_accounting_account MODIFY COLUMN account_number varchar(32) NOT NULL;'
Request 103 sql='UPDATE llx_const set name = __ENCRYPT('PRELEVEMENT_END_TO_END')__ where name = __ENCRYPT('END_TO_END')__;'
Request 104 sql='UPDATE llx_const set name = __ENCRYPT('PRELEVEMENT_USTRD')__ where name = __ENCRYPT('USTRD')__;'
Request 105 sql='DROP TABLE tmp_llx_accouting_account;'
Request 106 sql='CREATE TABLE tmp_llx_accouting_account AS SELECT MIN(rowid) as MINID, MAX(rowid) as MAXID, account_number, entity, fk_pcg_version, count(*) AS NB FROM llx_accounting_account group BY account_number, entity, fk_pcg_version HAVING count(*) >= 2 order by account_number, entity, fk_pcg_version;'
Request 107 sql='DELETE from llx_accounting_account where rowid in (select minid from tmp_llx_accouting_account where minid NOT IN (SELECT fk_code_ventilation from llx_facturedet) AND minid NOT IN (SELECT fk_code_ventilation from llx_facture_fourn_det) AND minid NOT IN (SELECT fk_code_ventilation from llx_expensereport_det));'
Request 108 sql='ALTER TABLE llx_accounting_account DROP INDEX uk_accounting_account;'
Request 109 sql='ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);'
Request 110 sql='UPDATE llx_projet SET fk_opp_status = NULL WHERE fk_opp_status = -1;'
Script processingKO
Error(s) were reported during the migration process so next step is not available. To ignore errors, you can click here, but the application or some features may not work correctly until the errors are resolved.