Erreur SQL

Bonjour,

Voici le message d’erreur auquel je suis confronté quand j’essaye de passer de la version 6 à la version 7.

Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, ‹ PCG99-ABREGE ›, ‹ The simple accountancy french plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, ‹ PCG99-BASE ›, ‹ The base accountancy french plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 1, ‹ PCG14-DEV ›, ‹ The developed accountancy french plan 2014 ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 2, ‹ PCMN-BASE ›, ‹ The base accountancy belgium plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 4, ‹ PCG08-PYME ›, ‹ The PYME accountancy spanish plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 6, ‹ PCG_SUISSE ›, ‹ Switzerland plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 7, ‹ ENG-BASE ›, ‹ England plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 10, ‹ PCT ›, ‹ The Tunisia plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 67, ‹ PC-MIPYME ›, ‹ The PYME accountancy Chile plan ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 80, ‹ DK-STD ›, ‹ Standardkontoplan fra SKAT ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (140, ‹ PCN-LUXEMBURG ›, ‹ Plan comptable normalisé Luxembourgeois ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 12, ‹ PCG ›, ‹ The Moroccan chart of accounts ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 49,‹ SYSCOHADA-BJ ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 60,‹ SYSCOHADA-BF ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 24,‹ SYSCOHADA-CM ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 65,‹ SYSCOHADA-CF ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 71,‹ SYSCOHADA-KM ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 72,‹ SYSCOHADA-CG ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 21,‹ SYSCOHADA-CI ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 16,‹ SYSCOHADA-GA ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 87,‹ SYSCOHADA-GQ ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (147,‹ SYSCOHADA-ML ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (168,‹ SYSCOHADA-NE ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 73,‹ SYSCOHADA-CD ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 22,‹ SYSCOHADA-SN ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 66,‹ SYSCOHADA-TD ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 15,‹ SYSCOHADA-TG ›, ‹ Plan comptable Ouest-Africain ›, 1); - Unknown column ‹ fk_country › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines) VALUES (0,‹ adherent ›,‹ member ›,’’,0,null,null,’(SendAnEMailToMember)’,1,1,1,’(CardContent)’,’(Hello),

\n\n__(ThisIsContentOfYourCard)__
\n__(ID)__ : ID
\n__(Civiliyty)__ : MEMBER_CIVILITY
\n__(Firstname)__ : MEMBER_FIRSTNAME
\n__(Lastname)__ : MEMBER_LASTNAME
\n__(Fullname)__ : MEMBER_FULLNAME
\n__(Company)__ : MEMBER_COMPANY
\n__(Address)__ : MEMBER_ADDRESS
\n__(Zip)__ : MEMBER_ZIP
\n__(Town)__ : MEMBER_TOWN
\n__(Country)__ : MEMBER_COUNTRY
\n__(Email)__ : MEMBER_EMAIL
\n__(Birthday)__ : MEMBER_BIRTH
\n__(Photo)__ : MEMBER_PHOTO
\n__(Login)__ : MEMBER_LOGIN
\n__(Password)__ : MEMBER_PASSWORD
\n__(Phone)__ : MEMBER_PHONE
\n__(PhonePerso)__ : MEMBER_PHONEPRO
\n__(PhoneMobile)__ : MEMBER_PHONEMOBILE

\n__(Sincerely)__
USER_SIGNATURE’,null); - Unknown column ‹ enabled › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - INSERT INTO llx_c_email_templates (entity,module,type_template,lang,private,fk_user,datec,label,position,enabled,active,topic,content,content_lines) VALUES (0,‹ banque ›,‹ thirdparty ›,’’,0,null,null,’(YourSEPAMandate)’,1,1,0,’(YourSEPAMandate)’,’(Hello),

\n\n__(FindYourSEPAMandate)__ :
\n__MYCOMPANY_NAME__
\n__MYCOMPANY_FULLADDRESS__

\n__(Sincerely)__
\n__USER_SIGNATURE__’,null); - Unknown column ‹ enabled › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - insert into llx_c_revenuestamp(rowid,fk_pays,taux,revenuestamp_type,note,active) values (101, 10, 0.4, ‹ fixed ›, ‹ Revenue stamp tunisia ›, 1); - Unknown column ‹ revenuestamp_type › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - insert into llx_c_revenuestamp(rowid,fk_pays,taux,revenuestamp_type,note,active) values (1541, 154, 1.5, ‹ percent ›, ‹ Revenue stamp mexico ›, 1); - Unknown column ‹ revenuestamp_type › in ‹ field list ›
Erreur SQL : DB_ERROR_NOSUCHFIELD - insert into llx_c_revenuestamp(rowid,fk_pays,taux,revenuestamp_type,note,active) values (1542, 154, 3, ‹ percent ›, ‹ Revenue stamp mexico ›, 1); - Unknown column ‹ revenuestamp_type › in ‹ field list ›
Connexion au serveur : localhost Ok
Version de la base 5.1.73
Nom de la base de données dolibarr2
Création des tables et des clés primaires Ok
Création des clés étrangères et des index pour la table llx_c_payment_term.key
Request 359 : ALTER TABLE llx_c_payment_term ADD UNIQUE INDEX uk_c_payment_term(rowid, entity, code) Erreur SQL DB_ERROR_1072 Key column ‹ entity › doesn’t exist in table
Création des clés étrangères et des index pour la table llx_entrepot.key
Request 497 : ALTER TABLE llx_entrepot ADD UNIQUE INDEX uk_entrepot_label (ref, entity) Erreur SQL DB_ERROR_1072 Key column ‹ ref › doesn’t exist in table
Création des clés étrangères et des index pour la table llx_inventory.key
Request 596 : ALTER TABLE llx_inventory ADD INDEX idx_inventory_date_creation (date_creation) Erreur SQL DB_ERROR_1072 Key column ‹ date_creation › doesn’t exist in table
Création des clés étrangères et des index pour la table llx_resource.key
Request 728 : ALTER TABLE llx_resource ADD INDEX idx_resource_fk_country (fk_country) Erreur SQL DB_ERROR_1072 Key column ‹ fk_country › doesn’t exist in table
Création des clés étrangères et des index pour la table llx_resource.key
Request 729 : ALTER TABLE llx_resource ADD CONSTRAINT fk_resource_fk_country FOREIGN KEY (fk_country) REFERENCES llx_c_country (rowid) Erreur SQL DB_ERROR_1072 Key column ‹ fk_country › doesn’t exist in table
Création des fonctions Ok
Chargement des données de référence Error

tu a un problème sur ta basse de donnée sur celle qui gère les compte