Dolibarr logo
20.0.1

Dolibarr install or upgrade

Database Database migration (structure + some data)

Server connection : localhostOK
Database connection : htech_iasOK
Database server version10.6.22-MariaDB-cll-lve-log
Client charsetutf8
Client collationutf8_general_ci
Please be patient...
Choose migration script4.0.0-5.0.0.sql
Request 1 sql='UPDATE llx_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRPARTY_CREATION_INDIVIDUAL')__;'
Request 2 sql='UPDATE llx_const SET name = __ENCRYPT('THIRDPARTY_DEFAULT_CREATE_CONTACT')__ WHERE name = __ENCRYPT('MAIN_THIRDPARTY_CREATION_INDIVIDUAL')__;'
Request 3 sql='ALTER TABLE llx_product_lot MODIFY COLUMN entity integer DEFAULT 1;'
Request 4 sql='UPDATE llx_product_lot SET entity = 1 WHERE entity IS NULL;'
Request 5 sql='ALTER TABLE llx_bank_account ADD COLUMN extraparams varchar(255);'
Request 6 sql='ALTER TABLE llx_societe ALTER COLUMN fk_stcomm SET DEFAULT 0;'
Request 7 sql='ALTER TABLE llx_c_actioncomm ADD COLUMN picto varchar(48);'
Request 8 sql='ALTER TABLE llx_facturedet ADD INDEX idx_facturedet_fk_code_ventilation (fk_code_ventilation);'
Request 9 sql='ALTER TABLE llx_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_code_ventilation (fk_code_ventilation);'
Request 10 sql='ALTER TABLE llx_facture_fourn_det ADD INDEX idx_facture_fourn_det_fk_product (fk_product);'
Request 11 sql='ALTER TABLE llx_facture_rec ADD COLUMN fk_user_modif integer;'
Request 12 sql='ALTER TABLE llx_expedition ADD COLUMN fk_user_modif integer;'
Request 13 sql='ALTER TABLE llx_projet ADD COLUMN fk_user_modif integer;'
Request 14 sql='ALTER TABLE llx_adherent ADD COLUMN model_pdf varchar(255);'
Request 15 sql='ALTER TABLE llx_don ADD COLUMN date_valid datetime;'
Request 16 sql='DELETE FROM llx_menu where module='expensereport';'
Request 17 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_user_author integer after fk_unit;'
Request 18 sql='ALTER TABLE llx_facturedet ADD COLUMN fk_user_modif integer after fk_unit;'
Request 19 sql='ALTER TABLE llx_user DROP COLUMN phenix_login;'
Request 20 sql='ALTER TABLE llx_user DROP COLUMN phenix_pass;'
Request 21 sql='ALTER TABLE llx_user ADD COLUMN dateemployment datetime;'
Request 22 sql='ALTER TABLE llx_user MODIFY login varchar(50) NOT NULL;'
Request 23 sql='ALTER TABLE llx_societe ADD COLUMN fk_account integer;'
Request 24 sql='ALTER TABLE llx_commandedet ADD COLUMN fk_commandefourndet integer DEFAULT NULL after import_key;'
Request 25 sql='ALTER TABLE llx_commandedet MODIFY COLUMN fk_commandefourndet integer DEFAULT NULL;'
Request 26 sql='ALTER TABLE llx_website ADD COLUMN virtualhost varchar(255) after fk_default_home;'
Request 27 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_account integer after fk_type;'
Request 28 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_mode_reglement integer after fk_account;'
Request 29 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_author integer;'
Request 30 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_modif integer;'
Request 31 sql='ALTER TABLE llx_chargesociales ADD COLUMN fk_user_valid integer;'
Request 32 sql='ALTER TABLE llx_ecm_files ADD COLUMN gen_or_uploaded varchar(12) after cover;'
Request 33 sql='DROP TABLE llx_document_generator;'
Request 34 sql='DROP TABLE llx_ecm_documents;'
Request 35 sql='DROP TABLE llx_holiday_events;'
Request 36 sql='DROP TABLE llx_holiday_types;'
Request 37 sql='ALTER TABLE llx_notify ADD COLUMN type_target varchar(16) NULL;'
Request 38 sql='ALTER TABLE llx_entrepot DROP COLUMN valo_pmp;'
Request 39 sql='ALTER TABLE llx_notify_def MODIFY COLUMN fk_soc integer NULL;'
Request 40 sql='create table llx_categorie_project ( fk_categorie integer NOT NULL, fk_project integer NOT NULL, import_key varchar(14) )ENGINE=innodb;'
Request 41 sql='ALTER TABLE llx_categorie_project ADD PRIMARY KEY pk_categorie_project (fk_categorie, fk_project);'
Request 42 sql='ALTER TABLE llx_categorie_project ADD INDEX idx_categorie_project_fk_categorie (fk_categorie);'
Request 43 sql='ALTER TABLE llx_categorie_project ADD INDEX idx_categorie_project_fk_project (fk_project);'
Request 44 sql='ALTER TABLE llx_categorie_project ADD CONSTRAINT fk_categorie_project_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 45 sql='ALTER TABLE llx_categorie_project ADD CONSTRAINT fk_categorie_project_fk_project_rowid FOREIGN KEY (fk_project) REFERENCES llx_projet (rowid);'
Request 46 sql='ALTER TABLE llx_societe_remise_except ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;'
Request 47 sql='ALTER TABLE llx_societe_remise ADD COLUMN entity integer DEFAULT 1 NOT NULL after rowid;'
Request 48 sql='create table llx_expensereport_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 49 sql='ALTER TABLE llx_expensereport_extrafields ADD INDEX idx_expensereport_extrafields (fk_object);'
Request 50 sql='ALTER TABLE llx_cotisation RENAME TO llx_subscription;'
Request 51 sql='ALTER TABLE llx_subscription ADD UNIQUE INDEX uk_subscription (fk_adherent,dateadh);'
Request 52 sql='ALTER TABLE llx_subscription CHANGE COLUMN cotisation subscription real;'
Request 53 sql='ALTER TABLE llx_adherent_type CHANGE COLUMN cotisation subscription varchar(3) NOT NULL DEFAULT '1';'
Request 54 sql='UPDATE llx_adherent_type SET subscription = '1' WHERE subscription = 'yes';'
Request 55 sql='CREATE TABLE llx_product_lot_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 56 sql='ALTER TABLE llx_product_lot_extrafields ADD INDEX idx_product_lot_extrafields (fk_object);'
Request 57 sql='ALTER TABLE llx_website_page MODIFY COLUMN content MEDIUMTEXT;'
Request 58 sql='CREATE TABLE llx_product_warehouse_properties ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_product integer NOT NULL, fk_entrepot integer NOT NULL, seuil_stock_alerte integer DEFAULT 0, desiredstock integer DEFAULT 0, import_key varchar(14) )ENGINE=innodb;'
Request 59 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN entity integer DEFAULT 1 NOT NULL;'
Request 60 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN fk_user_modif integer;'
Request 61 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN date_creation datetime;'
Request 62 sql='ALTER TABLE llx_accounting_bookkeeping ADD COLUMN tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;'
Request 63 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN numero_compte varchar(32) NOT NULL;'
Request 64 sql='ALTER TABLE llx_accounting_bookkeeping MODIFY COLUMN code_journal varchar(32) NOT NULL;'
Request 65 sql='ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);'
Error DB_ERROR_1072 (Req 65): ALTER TABLE llx_accounting_account ADD UNIQUE INDEX uk_accounting_account (account_number, entity, fk_pcg_version);
Key column 'entity' doesn't exist in table
Request 66 sql='ALTER TABLE llx_expensereport_det ADD COLUMN fk_code_ventilation integer DEFAULT 0;'
Request 67 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN fdm type_cdr tinyint;'
Request 68 sql='ALTER TABLE llx_facturedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 69 sql='ALTER TABLE llx_facturedet_rec ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 70 sql='ALTER TABLE llx_facture_fourn_det ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 71 sql='ALTER TABLE llx_commandedet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 72 sql='ALTER TABLE llx_commande_fournisseurdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 73 sql='ALTER TABLE llx_propaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 74 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 75 sql='ALTER TABLE llx_supplier_proposaldet ADD COLUMN fk_unit integer DEFAULT NULL;'
Request 76 sql='ALTER TABLE llx_contratdet ADD COLUMN vat_src_code varchar(10) DEFAULT '' AFTER tva_tx;'
Request 77 sql='ALTER TABLE llx_c_payment_term CHANGE COLUMN fdm type_cdr TINYINT;'
Request 78 sql='ALTER TABLE llx_entrepot ADD COLUMN fk_parent integer DEFAULT 0;'
Request 79 sql='create table llx_resource_extrafields ( rowid integer AUTO_INCREMENT PRIMARY KEY, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_object integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 80 sql='ALTER TABLE llx_resource_extrafields ADD INDEX idx_resource_extrafields (fk_object);'
Request 81 sql='INSERT INTO llx_const (name, value, type, note, visible, entity) values (__ENCRYPT('MAIN_SIZE_SHORTLIST_LIMIT')__, __ENCRYPT('3')__, 'chaine', 'Max length for small lists (tabs)', 0, 0);'
Request 82 sql='INSERT INTO llx_const (name, value, type, note, visible, entity) values (__ENCRYPT('EXPEDITION_ADDON_NUMBER')__, __ENCRYPT('mod_expedition_safor')__, 'chaine','Name for numbering manager for shipments',0,1);'
Request 83 sql='ALTER TABLE llx_bank_account ADD COLUMN note_public text;'
Request 84 sql='ALTER TABLE llx_bank_account ADD COLUMN model_pdf varchar(255);'
Request 85 sql='ALTER TABLE llx_bank_account ADD COLUMN import_key varchar(14);'
Request 86 sql='ALTER TABLE llx_projet ADD COLUMN import_key varchar(14);'
Request 87 sql='ALTER TABLE llx_projet_task ADD COLUMN import_key varchar(14);'
Request 88 sql='ALTER TABLE llx_projet_task_time ADD COLUMN import_key varchar(14);'
Request 89 sql='ALTER TABLE llx_overwrite_trans ADD COLUMN entity integer DEFAULT 1 NOT NULL AFTER rowid;'
Request 90 sql='ALTER TABLE llx_mailing_cibles ADD COLUMN error_text varchar(255);'
Request 91 sql='ALTER TABLE llx_c_actioncomm MODIFY COLUMN type varchar(50) DEFAULT 'system' NOT NULL;'
Request 92 sql='create table llx_user_employment ( rowid integer AUTO_INCREMENT PRIMARY KEY, entity integer DEFAULT 1 NOT NULL, ref varchar(50), ref_ext varchar(50), fk_user integer, datec datetime, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer, fk_user_modif integer, job varchar(128), status integer NOT NULL, salary double(24,8), salaryextra double(24,8), weeklyhours double(16,8), dateemployment date, dateemploymentend date )ENGINE=innodb;'
Request 93 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_date_debut (date_debut);'
Request 94 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_date_fin (date_fin);'
Request 95 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_statut (fk_statut);'
Request 96 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_author (fk_user_author);'
Request 97 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_valid (fk_user_valid);'
Request 98 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_user_approve (fk_user_approve);'
Request 99 sql='ALTER TABLE llx_expensereport ADD INDEX idx_expensereport_fk_refuse (fk_user_approve);'
Request 100 sql='DELETE FROM llx_actioncomm_resources WHERE fk_actioncomm not in (select id from llx_actioncomm);'
Request 101 sql='DROP TABLE tmp_links_double;'
Request 102 sql='CREATE TABLE tmp_links_double AS (SELECT objectid, label, MAX(rowid) AS max_rowid, COUNT(rowid) AS count_rowid FROM llx_links WHERE label IS NOT NULL GROUP BY objectid, label HAVING COUNT(rowid) >= 2);'
Request 103 sql='DELETE FROM llx_links WHERE (rowid, label) IN (SELECT max_rowid, label FROM tmp_links_double);'
Request 104 sql='DROP TABLE tmp_links_double;'
Request 105 sql='ALTER TABLE llx_links ADD UNIQUE INDEX uk_links (objectid,label);'
Request 106 sql='ALTER TABLE llx_expensereport ADD UNIQUE INDEX idx_expensereport_uk_ref (ref, entity);'
Request 107 sql='UPDATE llx_projet_task SET ref = NULL WHERE ref = '';'
Request 108 sql='ALTER TABLE llx_projet_task ADD UNIQUE INDEX uk_projet_task_ref (ref, entity);'
Request 109 sql='ALTER TABLE llx_contrat ADD COLUMN fk_user_modif integer;'
Request 110 sql='UPDATE llx_accounting_account SET account_parent = 0 WHERE account_parent = '';'
Request 111 sql='ALTER TABLE llx_product_price MODIFY COLUMN date_price DATETIME NULL;'
Request 112 sql='ALTER TABLE llx_product_price ALTER COLUMN date_price SET DEFAULT NULL;'
Request 113 sql='ALTER TABLE llx_product_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 114 sql='ALTER TABLE llx_product_customer_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 115 sql='ALTER TABLE llx_product_customer_price_log ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 116 sql='ALTER TABLE llx_product_fournisseur_price ADD COLUMN default_vat_code varchar(10) after tva_tx;'
Request 117 sql='ALTER TABLE llx_events MODIFY COLUMN ip varchar(250);'
Request 118 sql='UPDATE llx_bank SET label= '(SupplierInvoicePayment)' WHERE label= 'Règlement fournisseur';'
Request 119 sql='UPDATE llx_bank SET label= '(CustomerInvoicePayment)' WHERE label= 'Règlement client';'
Script processingError - Show-Hide details
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.