Merci @erics
J’ai testé, mais cela ne change rien.
/install/check.php donne :
Vérification des prérequis
Version de PHP 8.1.26 (Plus d’information)
Il est possible que votre configuration PHP ne supporte pas les variables POST et / ou GET. Vérifiez le paramètre variables_order dans le fichier php.ini. (Cliquez ici pour un test plus probant)
Ce PHP prend en charge les sessions.
Ce PHP prend en charge les fonctions GD.
Ce PHP prend en charge les fonctions Curl.
Ce PHP prend en charge les fonctions Calendar.
Ce PHP prend en charge les fonctions UTF8.
Ce PHP prend en charge les fonctions mbstring.
Ce PHP prend en charge les fonctions Intl.
Ce PHP prend en charge les fonctions ZIP.
Votre mémoire maximum de session PHP est définie à 2048M. Ceci devrait être suffisant.
Le fichier de configuration htdocs/conf/conf.php existe.
Le fichier htdocs/conf/conf.php est modifiable.
Cliquez ici pour un test plus probant renvoie vers :
Choisissez votre mode d’installation et cliquez sur « Démarrer »…
Mise à jour
14.0.* ou 15.0.0 → 15.0.* | Utilisez ce mode après avoir écrasé les fichiers d’une ancienne installation Dolibarr par ceux d’une version plus récente. Ce choix permet de mettre à jour votre base et vos données pour cette nouvelle version.
Choix suggéré par l’installeur. | Démarrer
Lancer le script revoie vers :
Choix du script de migration 14.0.0-15.0.0.sql
Request 1 sql='ALTER TABLE llx_partnership MODIFY COLUMN date_partnership_end date NULL;'
...
Request 24 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskConf)', 10, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskConf)__', '__(Hello)__,<br /><br />__(OrganizationEventConfRequestWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 25 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailAskBooth)', 20, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailAskBooth)__', '__(Hello)__,<br /><br />__(OrganizationEventBoothRequestWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 26 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailBoothPayment)', 30, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailBoothPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfBoothWasReceived)__<br /><br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 27 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationEmailRegistrationPayment)', 40, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationEmailRegistrationPayment)__', '__(Hello)__,<br /><br />__(OrganizationEventPaymentOfRegistrationWasReceived)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 28 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailAttendees)', 50, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailAttendees)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToAttendees)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 29 sql='INSERT INTO llx_c_email_templates (entity, module, type_template, lang, private, fk_user, datec, label, position, active, topic, content, content_lines, enabled, joinfiles) values (0, '', 'conferenceorbooth', '', 0, null, null, '(EventOrganizationMassEmailSpeakers)', 60, 1, '[__[MAIN_INFO_SOCIETE_NOM]__] __(EventOrganizationMassEmailSpeakers)__', '__(Hello)__,<br /><br />__(OrganizationEventBulkMailToSpeakers)__<br /><br />__(Sincerely)__<br />__USER_SIGNATURE__', null, '1', null);'
Request 30 sql='UPDATE llx_c_email_templates SET label = '(EventOrganizationEmailBoothPayment)' WHERE label = '(EventOrganizationEmailSubsBooth)';'
Request 31 sql='UPDATE llx_c_email_templates SET label = '(EventOrganizationEmailRegistrationPayment)' WHERE label = '(EventOrganizationEmailSubsEvent)';'
Request 32 sql='UPDATE llx_facturedet SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and subprice > 0) OR (multicurrency_subprice > 0 and subprice < 0));'
Request 33 sql='UPDATE llx_facturedet SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 34 sql='UPDATE llx_facturedet SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));'
Request 35 sql='UPDATE llx_facturedet SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 36 sql='UPDATE llx_facture SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 37 sql='UPDATE llx_facture SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));'
Request 38 sql='UPDATE llx_facture SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 39 sql='UPDATE llx_facture_fourn_det SET multicurrency_subprice = -multicurrency_subprice WHERE ((multicurrency_subprice < 0 and pu_ht > 0) OR (multicurrency_subprice > 0 and pu_ht < 0));'
Request 40 sql='UPDATE llx_facture_fourn_det SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 41 sql='UPDATE llx_facture_fourn_det SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and tva > 0) OR (multicurrency_total_tva > 0 and tva < 0));'
Request 42 sql='UPDATE llx_facture_fourn_det SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 43 sql='UPDATE llx_facture_fourn SET multicurrency_total_ht = -multicurrency_total_ht WHERE ((multicurrency_total_ht < 0 and total_ht > 0) OR (multicurrency_total_ht > 0 and total_ht < 0));'
Request 44 sql='UPDATE llx_facture_fourn SET multicurrency_total_tva = -multicurrency_total_tva WHERE ((multicurrency_total_tva < 0 and total_tva > 0) OR (multicurrency_total_tva > 0 and total_tva < 0));'
Request 45 sql='UPDATE llx_facture_fourn SET multicurrency_total_ttc = -multicurrency_total_ttc WHERE ((multicurrency_total_ttc < 0 and total_ttc > 0) OR (multicurrency_total_ttc > 0 and total_ttc < 0));'
Request 46 sql='ALTER TABLE llx_propaldet ADD COLUMN import_key varchar(14);'
Request 47 sql='ALTER TABLE llx_c_partnership_type ADD UNIQUE INDEX uk_c_partnership_type(entity, code);'
Request 48 sql='ALTER TABLE llx_partnership ADD COLUMN fk_type integer DEFAULT 0 NOT NULL;'
Request 49 sql='ALTER TABLE llx_c_holiday_types CHANGE COLUMN newByMonth newbymonth double(8,5) DEFAULT 0 NOT NULL;'
Request 50 sql='ALTER TABLE llx_product ADD COLUMN mandatory_period tinyint NULL DEFAULT 0;'
Request 51 sql='ALTER TABLE llx_holiday ADD COLUMN date_approve DATETIME DEFAULT NULL;'
Request 52 sql='ALTER TABLE llx_holiday ADD COLUMN fk_user_approve integer DEFAULT NULL;'
Request 53 sql='ALTER TABLE llx_ticket MODIFY COLUMN progress integer;'
Request 54 sql='ALTER TABLE llx_emailcollector_emailcollectoraction MODIFY COLUMN actionparam TEXT;'
Request 55 sql='ALTER TABLE llx_knowledgemanagement_knowledgerecord ADD COLUMN lang varchar(6);'
Request 56 sql='ALTER TABLE llx_knowledgemanagement_knowledgerecord ADD COLUMN entity integer DEFAULT 1;'
Request 57 sql='CREATE TABLE llx_categorie_ticket ( fk_categorie integer NOT NULL, fk_ticket integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 58 sql='ALTER TABLE llx_categorie_ticket ADD PRIMARY KEY pk_categorie_ticket (fk_categorie, fk_ticket);'
Request 59 sql='ALTER TABLE llx_categorie_ticket ADD INDEX idx_categorie_ticket_fk_categorie (fk_categorie);'
Request 60 sql='ALTER TABLE llx_categorie_ticket ADD INDEX idx_categorie_ticket_fk_ticket (fk_ticket);'
Request 61 sql='ALTER TABLE llx_categorie_ticket ADD CONSTRAINT fk_categorie_ticket_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 62 sql='ALTER TABLE llx_categorie_ticket ADD CONSTRAINT fk_categorie_ticket_ticket_rowid FOREIGN KEY (fk_ticket) REFERENCES llx_ticket (rowid);'
Request 63 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN ref_fourn varchar(128);'
Request 64 sql='ALTER TABLE llx_product_customer_price MODIFY COLUMN ref_customer varchar(128);'
Request 65 sql='ALTER TABLE llx_product_association ADD COLUMN rang integer DEFAULT 0;'
Request 66 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) VALUES ('ORDER_SUPPLIER_CANCEL','Supplier order request canceled','Executed when a supplier order is canceled','order_supplier',13);'
Request 67 sql='ALTER TABLE llx_product ADD COLUMN fk_default_bom integer DEFAULT NULL;'
Request 68 sql='ALTER TABLE llx_mrp_mo ADD COLUMN mrptype integer DEFAULT 0;'
Request 69 sql='DELETE FROM llx_menu WHERE type = 'top' AND module = 'cashdesk' AND mainmenu = 'cashdesk';'
Request 70 sql='INSERT INTO llx_c_action_trigger (code, label, description, elementtype, rang) values ('MEMBER_EXCLUDE', 'Member excluded', 'Executed when a member is excluded', 'member', 27);'
Request 71 sql='CREATE TABLE llx_categorie_knowledgemanagement ( fk_categorie integer NOT NULL, fk_knowledgemanagement integer NOT NULL, import_key varchar(14) )ENGINE=innodb;'
Request 72 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD PRIMARY KEY pk_categorie_knowledgemanagement (fk_categorie, fk_knowledgemanagement);'
Request 73 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD INDEX idx_categorie_knowledgemanagement_fk_categorie (fk_categorie);'
Request 74 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD INDEX idx_categorie_knowledgemanagement_fk_knowledgemanagement (fk_knowledgemanagement);'
Request 75 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD CONSTRAINT fk_categorie_knowledgemanagement_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 76 sql='ALTER TABLE llx_categorie_knowledgemanagement ADD CONSTRAINT fk_categorie_knowledgemanagement_knowledgemanagement_rowid FOREIGN KEY (fk_knowledgemanagement) REFERENCES llx_knowledgemanagement_knowledgerecord (rowid);'
Request 77 sql='ALTER TABLE llx_product_lot ADD COLUMN barcode varchar(180) DEFAULT NULL;'
Request 78 sql='ALTER TABLE llx_product_lot ADD COLUMN fk_barcode_type integer DEFAULT NULL;'
Request 79 sql='ALTER TABLE llx_projet ADD COLUMN max_attendees integer DEFAULT 0;'
Request 80 sql='ALTER TABLE llx_commande_fournisseur_dispatch ADD COLUMN cost_price double(24,8) DEFAULT 0;'
Request 81 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2001', 'Aktiebolag');'
Request 82 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2002', 'Publikt aktiebolag (AB publ)');'
Request 83 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2003', 'Ekonomisk förening (ek. för.)');'
Request 84 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2004', 'Bostadsrättsförening (BRF)');'
Request 85 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2005', 'Hyresrättsförening (HRF)');'
Request 86 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2006', 'Kooperativ');'
Request 87 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2007', 'Enskild firma (EF)');'
Request 88 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2008', 'Handelsbolag (HB)');'
Request 89 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2009', 'Kommanditbolag (KB)');'
Request 90 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2010', 'Enkelt bolag');'
Request 91 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2011', 'Ideell förening');'
Request 92 sql='INSERT INTO llx_c_forme_juridique (fk_pays, code, libelle) VALUES (20, '2012', 'Stiftelse');'
Request 93 sql='CREATE TABLE llx_hrm_evaluation ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, ref varchar(128) DEFAULT '(PROV)' NOT NULL, label varchar(255), description text, note_public text, note_private text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, import_key varchar(14), status smallint NOT NULL, date_eval date, fk_user integer NOT NULL, fk_job integer NOT NULL ) ENGINE=innodb;'
Request 94 sql='ALTER TABLE llx_hrm_evaluation ADD INDEX idx_hrm_evaluation_rowid (rowid);'
Request 95 sql='ALTER TABLE llx_hrm_evaluation ADD INDEX idx_hrm_evaluation_ref (ref);'
Request 96 sql='ALTER TABLE llx_hrm_evaluation ADD CONSTRAINT llx_hrm_evaluation_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 97 sql='ALTER TABLE llx_hrm_evaluation ADD INDEX idx_hrm_evaluation_status (status);'
Request 98 sql='create table llx_hrm_evaluation_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 99 sql='ALTER TABLE llx_hrm_evaluation_extrafields ADD INDEX idx_evaluation_fk_object(fk_object);'
Request 100 sql='CREATE TABLE llx_hrm_evaluationdet ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_skill integer NOT NULL, fk_evaluation integer NOT NULL, rankorder integer NOT NULL, required_rank integer NOT NULL, import_key varchar(14) ) ENGINE=innodb;'
Request 101 sql='ALTER TABLE llx_hrm_evaluationdet ADD INDEX idx_hrm_evaluationdet_rowid (rowid);'
Request 102 sql='ALTER TABLE llx_hrm_evaluationdet ADD CONSTRAINT llx_hrm_evaluationdet_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 103 sql='ALTER TABLE llx_hrm_evaluationdet ADD INDEX idx_hrm_evaluationdet_fk_skill (fk_skill);'
Request 104 sql='ALTER TABLE llx_hrm_evaluationdet ADD INDEX idx_hrm_evaluationdet_fk_evaluation (fk_evaluation);'
Request 105 sql='create table llx_hrm_evaluationdet_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 106 sql='ALTER TABLE llx_hrm_evaluationdet_extrafields ADD INDEX idx_evaluationdet_fk_object(fk_object);'
Request 107 sql='CREATE TABLE llx_hrm_job ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, label varchar(255) NOT NULL, description text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, deplacement varchar(255), note_public text, note_private text, fk_user_creat integer, fk_user_modif integer ) ENGINE=innodb;'
Request 108 sql='ALTER TABLE llx_hrm_job ADD INDEX idx_hrm_job_rowid (rowid);'
Request 109 sql='ALTER TABLE llx_hrm_job ADD INDEX idx_hrm_job_label (label);'
Request 110 sql='create table llx_hrm_job_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 111 sql='ALTER TABLE llx_hrm_job_extrafields ADD INDEX idx_job_fk_object(fk_object);'
Request 112 sql='CREATE TABLE llx_hrm_job_user( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, description text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_contrat integer, fk_user integer, fk_job integer NOT NULL, date_start date, date_end date, abort_comment varchar(255), note_public text, note_private text, fk_user_creat integer, fk_user_modif integer ) ENGINE=innodb;'
Request 113 sql='ALTER TABLE llx_hrm_job_user ADD COLUMN abort_comment varchar(255);'
Request 114 sql='ALTER TABLE llx_hrm_job_user ADD INDEX idx_hrm_job_user_rowid (rowid);'
Request 115 sql='CREATE TABLE llx_hrm_skill ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, label varchar(255), description text, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, required_level integer NOT NULL, date_validite integer NOT NULL, temps_theorique double(24,8) NOT NULL, skill_type integer NOT NULL, note_public text, note_private text ) ENGINE=innodb;'
Request 116 sql='ALTER TABLE llx_hrm_skill ADD INDEX idx_hrm_skill_rowid (rowid);'
Request 117 sql='ALTER TABLE llx_hrm_skill ADD CONSTRAINT llx_hrm_skill_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 118 sql='ALTER TABLE llx_hrm_skill ADD INDEX idx_hrm_skill_skill_type (skill_type);'
Request 119 sql='create table llx_hrm_skill_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 120 sql='ALTER TABLE llx_hrm_skill_extrafields ADD INDEX idx_skill_fk_object(fk_object);'
Request 121 sql='CREATE TABLE llx_hrm_skilldet ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, description text, fk_user_creat integer NOT NULL, fk_user_modif integer, fk_skill integer NOT NULL, rankorder integer ) ENGINE=innodb;'
Request 122 sql='ALTER TABLE llx_hrm_skilldet ADD COLUMN rankorder integer NOT NULL DEFAULT '1';'
Request 123 sql='ALTER TABLE llx_hrm_skilldet ADD INDEX idx_hrm_skilldet_rowid (rowid);'
Request 124 sql='ALTER TABLE llx_hrm_skilldet ADD CONSTRAINT llx_hrm_skilldet_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 125 sql='CREATE TABLE llx_hrm_skillrank ( rowid integer AUTO_INCREMENT PRIMARY KEY NOT NULL, fk_skill integer NOT NULL, rankorder integer NOT NULL, fk_object integer NOT NULL, date_creation datetime NOT NULL, tms timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, fk_user_creat integer NOT NULL, fk_user_modif integer, objecttype varchar(128) NOT NULL ) ENGINE=innodb;'
Request 126 sql='ALTER TABLE llx_hrm_skillrank ADD INDEX idx_hrm_skillrank_rowid (rowid);'
Request 127 sql='ALTER TABLE llx_hrm_skillrank ADD INDEX idx_hrm_skillrank_fk_skill (fk_skill);'
Request 128 sql='ALTER TABLE llx_hrm_skillrank ADD CONSTRAINT llx_hrm_skillrank_fk_user_creat FOREIGN KEY (fk_user_creat) REFERENCES llx_user(rowid);'
Request 129 sql='ALTER TABLE llx_c_units ADD COLUMN sortorder smallint AFTER code;'
Request 130 sql='ALTER TABLE llx_societe_perentity ADD COLUMN accountancy_code_customer varchar(24) AFTER entity;'
Request 131 sql='ALTER TABLE llx_societe_perentity ADD COLUMN accountancy_code_supplier varchar(24) AFTER accountancy_code_customer;'
Request 132 sql='ALTER TABLE llx_projet_task ADD COLUMN budget_amount double(24,8) AFTER priority;'
Request 133 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_ticket_by_severity.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_ticket_by_severity.php' AND entity = 1);'
Request 134 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_nb_ticket_last_x_days.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_nb_ticket_last_x_days.php' AND entity = 1);'
Request 135 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_nb_tickets_type.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_nb_tickets_type.php' AND entity = 1);'
Request 136 sql='INSERT INTO llx_boxes_def (file, entity) SELECT 'box_graph_new_vs_close_ticket.php', 1 FROM DUAL WHERE NOT EXISTS (SELECT * FROM llx_boxes_def WHERE file = 'box_graph_new_vs_close_ticket.php' AND entity = 1);'
Request 137 sql='ALTER TABLE llx_user DROP COLUMN jabberid;'
Request 138 sql='ALTER TABLE llx_user DROP COLUMN skype;'
Request 139 sql='ALTER TABLE llx_user DROP COLUMN twitter;'
Request 140 sql='ALTER TABLE llx_user DROP COLUMN facebook;'
Request 141 sql='ALTER TABLE llx_user DROP COLUMN linkedin;'
Request 142 sql='ALTER TABLE llx_user DROP COLUMN instagram;'
Request 143 sql='ALTER TABLE llx_user DROP COLUMN snapchat;'
Request 144 sql='ALTER TABLE llx_user DROP COLUMN googleplus;'
Request 145 sql='ALTER TABLE llx_user DROP COLUMN youtube;'
Request 146 sql='ALTER TABLE llx_user DROP COLUMN whatsapp;'
Request 147 sql='ALTER TABLE llx_adherent DROP COLUMN jabberid;'
Request 148 sql='ALTER TABLE llx_adherent DROP COLUMN skype;'
Request 149 sql='ALTER TABLE llx_adherent DROP COLUMN twitter;'
Request 150 sql='ALTER TABLE llx_adherent DROP COLUMN facebook;'
Request 151 sql='ALTER TABLE llx_adherent DROP COLUMN linkedin;'
Request 152 sql='ALTER TABLE llx_adherent DROP COLUMN instagram;'
Request 153 sql='ALTER TABLE llx_adherent DROP COLUMN snapchat;'
Request 154 sql='ALTER TABLE llx_adherent DROP COLUMN googleplus;'
Request 155 sql='ALTER TABLE llx_adherent DROP COLUMN youtube;'
Request 156 sql='ALTER TABLE llx_adherent DROP COLUMN whatsapp;'
Request 157 sql='ALTER TABLE llx_societe DROP COLUMN jabberid;'
Request 158 sql='ALTER TABLE llx_societe DROP COLUMN skype;'
Request 159 sql='ALTER TABLE llx_societe DROP COLUMN twitter;'
Request 160 sql='ALTER TABLE llx_societe DROP COLUMN facebook;'
Request 161 sql='ALTER TABLE llx_societe DROP COLUMN linkedin;'
Request 162 sql='ALTER TABLE llx_societe DROP COLUMN instagram;'
Request 163 sql='ALTER TABLE llx_societe DROP COLUMN snapchat;'
Request 164 sql='ALTER TABLE llx_societe DROP COLUMN googleplus;'
Request 165 sql='ALTER TABLE llx_societe DROP COLUMN youtube;'
Request 166 sql='ALTER TABLE llx_societe DROP COLUMN whatsapp;'
Request 167 sql='ALTER TABLE llx_socpeople DROP COLUMN jabberid;'
Request 168 sql='ALTER TABLE llx_socpeople DROP COLUMN skype;'
Request 169 sql='ALTER TABLE llx_socpeople DROP COLUMN twitter;'
Request 170 sql='ALTER TABLE llx_socpeople DROP COLUMN facebook;'
Request 171 sql='ALTER TABLE llx_socpeople DROP COLUMN linkedin;'
Request 172 sql='ALTER TABLE llx_socpeople DROP COLUMN instagram;'
Request 173 sql='ALTER TABLE llx_socpeople DROP COLUMN snapchat;'
Request 174 sql='ALTER TABLE llx_socpeople DROP COLUMN googleplus;'
Request 175 sql='ALTER TABLE llx_socpeople DROP COLUMN youtube;'
Request 176 sql='ALTER TABLE llx_socpeople DROP COLUMN whatsapp;'
Request 177 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (100, 'KLA', 'Klarna', 1, 0);'
Request 178 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (101, 'SOF', 'Sofort', 1, 0);'
Request 179 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (102, 'BAN', 'Bancontact', 1, 0);'
Request 180 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (103, 'IDE', 'iDeal', 1, 0);'
Request 181 sql='INSERT INTO llx_c_paiement (id,code,libelle,type,active) values (104, 'GIR', 'Giropay', 1, 0);'
Request 182 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_code varchar(3);'
Request 183 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 184 sql='ALTER TABLE llx_paiement_facture ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 185 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_code varchar(3);'
Request 186 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_tx double(24,8) DEFAULT 1;'
Request 187 sql='ALTER TABLE llx_paiementfourn_facturefourn ADD COLUMN multicurrency_amount double(24,8) DEFAULT 0;'
Request 188 sql='ALTER TABLE llx_commande_fournisseur MODIFY COLUMN multicurrency_code varchar(3);'
Request 189 sql='ALTER TABLE llx_commande_fournisseurdet MODIFY COLUMN multicurrency_code varchar(3);'
Request 190 sql='ALTER TABLE llx_commande MODIFY COLUMN multicurrency_code varchar(3);'
Request 191 sql='ALTER TABLE llx_commandedet MODIFY COLUMN multicurrency_code varchar(3);'
Request 192 sql='ALTER TABLE llx_contratdet MODIFY COLUMN multicurrency_code varchar(3);'
Request 193 sql='ALTER TABLE llx_expensereport_det MODIFY COLUMN multicurrency_code varchar(3);'
Request 194 sql='ALTER TABLE llx_expensereport MODIFY COLUMN multicurrency_code varchar(3);'
Request 195 sql='ALTER TABLE llx_facture_fourn_det MODIFY COLUMN multicurrency_code varchar(3);'
Request 196 sql='ALTER TABLE llx_facture_fourn MODIFY COLUMN multicurrency_code varchar(3);'
Request 197 sql='ALTER TABLE llx_facture_rec MODIFY COLUMN multicurrency_code varchar(3);'
Request 198 sql='ALTER TABLE llx_facture MODIFY COLUMN multicurrency_code varchar(3);'
Request 199 sql='ALTER TABLE llx_facturedet_rec MODIFY COLUMN multicurrency_code varchar(3);'
Request 200 sql='ALTER TABLE llx_facturedet MODIFY COLUMN multicurrency_code varchar(3);'
Request 201 sql='ALTER TABLE llx_paiement_facture MODIFY COLUMN multicurrency_code varchar(3);'
Request 202 sql='ALTER TABLE llx_paiementfourn_facturefourn MODIFY COLUMN multicurrency_code varchar(3);'
Request 203 sql='ALTER TABLE llx_product_fournisseur_price_log MODIFY COLUMN multicurrency_code varchar(3);'
Request 204 sql='ALTER TABLE llx_product_fournisseur_price MODIFY COLUMN multicurrency_code varchar(3);'
Request 205 sql='ALTER TABLE llx_product_price_by_qty MODIFY COLUMN multicurrency_code varchar(3);'
Request 206 sql='ALTER TABLE llx_product_price MODIFY COLUMN multicurrency_code varchar(3);'
Request 207 sql='ALTER TABLE llx_propal MODIFY COLUMN multicurrency_code varchar(3);'
Request 208 sql='ALTER TABLE llx_propaldet MODIFY COLUMN multicurrency_code varchar(3);'
Request 209 sql='ALTER TABLE llx_societe MODIFY COLUMN multicurrency_code varchar(3);'
Request 210 sql='ALTER TABLE llx_supplier_proposal MODIFY COLUMN multicurrency_code varchar(3);'
Request 211 sql='ALTER TABLE llx_supplier_proposaldet MODIFY COLUMN multicurrency_code varchar(3);'
Request 212 sql='ALTER TABLE llx_propal ADD COLUMN online_sign_ip varchar(48);'
Request 213 sql='ALTER TABLE llx_propal ADD COLUMN online_sign_name varchar(64);'
Request 214 sql='ALTER TABLE llx_entrepot ADD COLUMN warehouse_usage integer DEFAULT 1;'
Request 215 sql='ALTER TABLE llx_session MODIFY COLUMN user_agent VARCHAR(255) NULL;'
Request 216 sql='ALTER TABLE llx_inventorydet ADD COLUMN fk_movement integer NULL;'
Request 217 sql='ALTER TABLE llx_stock_mouvement MODIFY COLUMN origintype varchar(64);'
Request 218 sql='ALTER TABLE llx_intracommreport CHANGE COLUMN period periods varchar(32);'
Request 219 sql='UPDATE llx_rights_def SET perms = 'writeall' WHERE perms = 'writeall_advance' AND module = 'holiday';'
Request 220 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_CREATE','User created','Executed when a user is created','user',301);'
Request 221 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_MODIFY','User update','Executed when a user is updated','user',302);'
Request 222 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_DELETE','User update','Executed when a user is deleted','user',303);'
Request 223 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_NEW_PASSWORD','User update','Executed when a user is change password','user',304);'
Request 224 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('USER_ENABLEDISABLE','User update','Executed when a user is enable or disable','user',305);'
Request 225 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_CREATE','Holiday created','Executed when a holiday is created','holiday',800);'
Request 226 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_MODIFY','Holiday modified','Executed when a holiday is modified','holiday',801);'
Request 227 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_VALIDATE','Holiday validated','Executed when a holiday is validated','holiday',802);'
Request 228 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_APPROVE','Holiday aprouved','Executed when a holiday is aprouved','holiday',803);'
Request 229 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_CANCEL','Holiday canceled','Executed when a holiday is canceled','holiday',802);'
Request 230 sql='INSERT INTO llx_c_action_trigger (code,label,description,elementtype,rang) values ('HOLIDAY_DELETE','Holiday deleted','Executed when a holiday is deleted','holiday',804);'
Request 231 sql='ALTER TABLE llx_user MODIFY COLUMN fk_soc integer NULL;'
Request 232 sql='CREATE TABLE llx_element_tag ( rowid integer AUTO_INCREMENT PRIMARY KEY, fk_categorie integer NOT NULL, fk_element integer NOT NULL, import_key varchar(14) )ENGINE=innodb;'
Request 233 sql='ALTER TABLE llx_element_tag ADD COLUMN fk_categorie integer;'
Request 234 sql='ALTER TABLE llx_element_tag ADD COLUMN fk_element integer;'
Request 235 sql='ALTER TABLE llx_element_tag ADD UNIQUE INDEX idx_element_tag_uk (fk_categorie, fk_element);'
Request 236 sql='ALTER TABLE llx_element_tag ADD CONSTRAINT fk_element_tag_categorie_rowid FOREIGN KEY (fk_categorie) REFERENCES llx_categorie (rowid);'
Request 237 sql='ALTER TABLE llx_bank ADD COLUMN amount_main_currency double(24,8) NULL;'
Exécution du script | OK - Afficher/masquer les détails
Étape suivante →
Enfin un page blanche s’affiche : avec en haut :
Migration de la base (données)
Et puis plus rien.
URL de la dernière page : /install/upgrade2.php?versionfrom=14.0.0&versionto=15.0.0
