All,
I tried to upgrade to the newest version of Dolibarr. This failed so I restored the previous 3.4.1 installation. If I now try to log in it always shows the error message Unknown column ‘u.fk_societe’ in ‘field list’. I don´t know how to fix this and I urgently need my system to send out invoices.
Any help or assistance would be great.
Thanks
Which version of dolibarr did you install ?
Can you provide a screenshot of page where you get error ?
Did your run all migration steps suggested by upgrae process ?
Hey
I tried to install 3.8.3. As this failed I pulled back the 3.4.1 installation. So now I am back on 3.4.1 but get the error message when I try to log in.
Attached you will find a screen shot from the error.
Hope this helps. Any help would be much appreciated.
Thanks in advance.
It seems your restore only the files of 3.4.1 not the database 3.4.1
If you started t omigrate to 3.8.3, you must go until the end.
If not, you must restore not only 3.4.1 file but also a backup of your database when you were in 3.4.1 version
Why the 3.8.3 migration failed ? Which error did you get ?
Hi Please find following the error messages I received during the upgrade to 3.8.3. This is the reason why i tried to pull back as nothing was moving.
Hope you can assist.
Datenbank
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_type_fees (code,label,active) values (‘TF_OTHER’, ‘Other’, 1); - Unknown column ‘label’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_type_fees (code,label,active) values (‘TF_TRIP’, ‘Transportation’, 1); - Unknown column ‘label’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_type_fees (code,label,active) values (‘TF_LUNCH’, ‘Lunch’, 1); - Unknown column ‘label’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 0, ‘TE_UNKNOWN’, ‘-’, NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 1, ‘TE_STARTUP’, ‘Start-up’, NULL, 0); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 2, ‘TE_GROUP’, ‘Grand groupe’, NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 3, ‘TE_MEDIUM’, ‘PME/PMI’, NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 4, ‘TE_SMALL’, ‘TPE’, NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 5, ‘TE_ADMIN’, ‘Administration’,NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 6, ‘TE_WHOLE’, ‘Grossiste’, NULL, 0); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 7, ‘TE_RETAIL’, ‘Revendeur’, NULL, 0); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values ( 8, ‘TE_PRIVATE’, ‘Particulier’, NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values (100, ‘TE_OTHER’, ‘Autres’, NULL, 1); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values (231, ‘TE_A_RI’, ‘Responsable Inscripto’, 23, 0); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values (232, ‘TE_B_RNI’, ‘Responsable No Inscripto’, 23, 0); - Unknown column ‘fk_country’ in ‘field list’
SQL-Fehler : DB_ERROR_NOSUCHFIELD - insert into llx_c_typent (id,code,libelle,fk_country,active) values (233, ‘TE_C_FE’, ‘Consumidor Final/Exento’, 23, 0); - Unknown column ‘fk_country’ in ‘field list’
Serververbindung : localhost Ok
Datenbankversion 5.5.44-MariaDB
Name der Datenbank P2P_ERP
Erstellen der Tabellen und Primärschlüssel Ok
Erstellen der Fremdschlüssel und Indizes für Tabelle llx_holiday.key
Request 455 : ALTER TABLE llx_holiday ADD INDEX idx_holiday_fk_user_create (fk_user_create) SQL-Fehler DB_ERROR_1072 Key column ‘fk_user_create’ doesn’t exist in table
Erstellen der Fremdschlüssel und Indizes für Tabelle llx_product.key
Request 513 : ALTER TABLE llx_product ADD CONSTRAINT fk_product_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid) SQL-Fehler DB_ERROR_1452 Cannot add or update a child row: a foreign key constraint fails (P2P_ERP.#sql-3798_ad9, CONSTRAINT fk_product_barcode_type FOREIGN KEY (fk_barcode_type) REFERENCES llx_c_barcode_type (rowid))
Erstellen der Fremdschlüssel und Indizes für Tabelle llx_projet_task_time.key
Request 557 : ALTER TABLE llx_projet_task_time ADD INDEX idx_projet_task_time_datehour (task_datehour) SQL-Fehler DB_ERROR_1072 Key column ‘task_datehour’ doesn’t exist in table
Erstellen der Funktionen Ok
Referenzdaten werden geladen Error
FailedToCreateAdminLogin Unknown column ‘weeklyhours’ in ‘field list’
Die Installation wurde erfolgreich abgeschlossen.
Aus Sicherheitsgründen sollten Sie nach abgeschlossenem Installations-/Aktualisierungsvorgang das Installationsverzeichnis (install) löschen oder in “install.lock” umbenennen.
Nun sollten Sie dolibarr an Ihre Bedürfnisse anpassen (Aussehen, Funktionen, …). Hierzu folgen Sie bitte dem untenstehenden Link:
Hi Eldy,
have you hab some time to look into my last comment?
BR
If you receive this error is probably because you did not run the previous migration step.
If you are coming from 3.4, did your run first the migration process 3.4 to 3.5, the 3.5 to 3.6 … as suggested by the migration wizard provided with 3.8
Hi,
So I got this same error when trying to upgrade from 3.7.0 to 3.8.0.
Do you know how I can resolve it?
