# Access to Login impossible (14.0.3) **URL:** \ **Category:** Maintaining my Dolibarr\ **Tags:** Bug, v13, v14, Upgrades, Issue\ **Created:** [November 8, 2021, 4:05pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404 "2021-11-08T16:05:02Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![rb3800](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rb3800](https://www.dolibarr.org/forum/u/rb3800)\ **Post date:** [November 8, 2021, 4:05pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/1 "2021-11-08T16:05:02Z")
Hello, I need your help because I’m in a endless loop. As usual, I updated Dolibarr (13.0 to 14.0.3 version) but the message after the installation process is still the same: _"The application tried to self-upgrade, but the install/upgrade pages have been disabled for security (by the existence of a lock file **install.lock** in the dolibarr documents directory)._ _If an upgrade is in progress, please wait. If not, click on the following link. If you always see this same page, you must remove/rename the file install.lock in the documents directory._ _[Click here to go to your application] "_ During the installation, the user or SuperUser access is denied: ![Screenshot 2021-11-08 at 16.58.36](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/3/3fe96758a04177aee0998f9a9e191aaef5dc0623.png) I detail the environment: - OSX - MYSQL v.5.6 - OVH server - dolibarr-14.0.3.zip - DB was already existed What I tried: 1. Removed the file conf.php and reinstalled from start 2. Renamed the install.lock file (444 permission) Thanks for you help. Raf ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [November 8, 2021, 7:31pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/2 "2021-11-08T19:31:22Z")
Try deleting the `install.lock` file ---
**Author:** ![rb3800](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rb3800](https://www.dolibarr.org/forum/u/rb3800)\ **Post date:** [November 8, 2021, 9:26pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/3 "2021-11-08T21:26:05Z")
Hi aljawaid, Thanks. I did it and the process is a loop. The point is that the process blocks when the Administrator Account has to be completed. It is already existing so I insert the same user name + psswd ; even if I create a new user ! ![Screenshot 2021-11-08 at 22.19.31](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/c/cf3ed14666d27fc76459a8da0e9ab172f7ba21d1.png) Do you think I should I remove the existing one in the Database ? Thanks. Raf ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [November 8, 2021, 9:37pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/4 "2021-11-08T21:37:53Z")
Hello Temporarily edit the email for the admin account in the database then re-run the installer. Try that. ---
**Author:** ![rb3800](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rb3800](https://www.dolibarr.org/forum/u/rb3800)\ **Post date:** [November 8, 2021, 11:06pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/5 "2021-11-08T23:06:21Z")
Hi aljawaib, I edited, even removed the User info in the DB but the message is still indicating error: ![Screenshot 2021-11-08 at 23.54.53](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/3/392b28593c0021083663640655ac90a57b2a2ba8.png) Do you think that if I save the DB then I create a new one with new User/Psswd and finally restore it, it could work ? Thanks Raf ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [November 8, 2021, 11:18pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/6 "2021-11-08T23:18:16Z")
yes it should work. **Keep a backup copy of the database though.** ---
**Author:** ![rb3800](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rb3800](https://www.dolibarr.org/forum/u/rb3800)\ **Post date:** [November 11, 2021, 8:39am UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/7 "2021-11-11T08:39:21Z")
Hi aljawaid, I had to reinstall the previous version (13.0) and restore the DB. Before upgrade it to the last version, I have to fix the following message: _Dolibarr has detected a technical error._ _This information can be useful for diagnostic purposes (you can set option $dolibarr\_main\_prod to ‘1’ to remove such notices):_ _ **Date:** 20211111093051_ _ **Dolibarr:** 13.0.5 - https : //www. dolibarr. org_ _ **Level of features:** 0_ _ **PHP:** 7.0.33_ _ **Server:** Apache_ _ **OS:** Linux webm009.cluster002.gra.hosting.ovh. net 4.14.253-ovh-vps-grsec-zfs-classid #1 SMP Thu Oct 28 11:15:35 CEST 2021 x86\_64_ _ **UserAgent:** Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:94.0) Gecko/20100101 Firefox/94.0_ _ **Requested URL:** /dolibarr-13.0.5/htdocs/index.php?mainmenu=home&leftmenu=home_ _ **Referer:** http: //URL/dolibarr-13.0.5/htdocs/admin/ihm.php?mainmenu=home&leftmenu=setup_ _ **Menu manager:** eldy\_menu.php_ _ **Modules/Applications:** user, comptabilite, product, categorie, propal, expensereport, facture, societe, service, banque_ _ **Database type manager:** mysqli_ _ **Latest database access request error:** SELECT date\_format(datef,’%m’) as dm, SUM(f.total) FROM llx\_facture as f WHERE f.datef BETWEEN ‘2020-01-01 00:00:00’ AND ‘2020-12-31 23:59:59’ AND f.fk\_statut \>= 0 AND f.entity IN (1) AND (f.fk\_statut \<\> 3 OR f.close\_code \<\> ‘replaced’) AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC_ _ **Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD_ _ **Information for latest database access request error:** Unknown column ‘f.total’ in ‘field list’_ _Dolibarr has detected a technical error._ _This information can be useful for diagnostic purposes (you can set option $dolibarr\_main\_prod to ‘1’ to remove such notices):_ _ **Date:** 20211111093051_ _ **Dolibarr:** 13.0.5 - https: //www. dolibarr. org_ _ **Level of features:** 0_ _ **PHP:** 7.0.33_ _ **Server:** Apache_ _ **OS:** Linux webm009.cluster002.gra.hosting.ovh. net 4.14.253-ovh-vps-grsec-zfs-classid #1 SMP Thu Oct 28 11:15:35 CEST 2021 x86\_64_ _ **UserAgent:** Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:94.0) Gecko/20100101 Firefox/94.0_ _ **Requested URL:** /dolibarr-13.0.5/htdocs/index.php?mainmenu=home&leftmenu=home_ _ **Referer:** http: //URL/dolibarr-13.0.5/htdocs/admin/ihm.php?mainmenu=home&leftmenu=setup_ _ **Menu manager:** eldy\_menu.php_ _ **Modules/Applications:** user, comptabilite, product, categorie, propal, expensereport, facture, societe, service, banque_ _ **Database type manager:** mysqli_ _ **Latest database access request error:** SELECT date\_format(datef,’%m’) as dm, SUM(f.total) FROM llx\_facture as f WHERE f.datef BETWEEN ‘2021-01-01 00:00:00’ AND ‘2021-12-31 23:59:59’ AND f.fk\_statut \>= 0 AND f.entity IN (1) AND (f.fk\_statut \<\> 3 OR f.close\_code \<\> ‘replaced’) AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC_ _ **Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD_ _ **Information for latest database access request error:** Unknown column ‘f.total’ in ‘field list’_ _Dolibarr has detected a technical error._ _This information can be useful for diagnostic purposes (you can set option $dolibarr\_main\_prod to ‘1’ to remove such notices):_ _ **Date:** 20211111093051_ _ **Dolibarr:** 13.0.5 - https ://www. dolibarr. org_ _ **Level of features:** 0_ _ **PHP:** 7.0.33_ _ **Server:** Apache_ _ **OS:** Linux webm009.cluster002.gra.hosting.ovh. net 4.14.253-ovh-vps-grsec-zfs-classid #1 SMP Thu Oct 28 11:15:35 CEST 2021 x86\_64_ _ **UserAgent:** Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:94.0) Gecko/20100101 Firefox/94.0_ _ **Requested URL:** /dolibarr-13.0.5/htdocs/index.php?mainmenu=home&leftmenu=home_ _ **Referer:** http: //URL/dolibarr-13.0.5/htdocs/admin/ihm.php?mainmenu=home&leftmenu=setup_ _ **Menu manager:** eldy\_menu.php_ _ **Modules/Applications:** user, comptabilite, product, categorie, propal, expensereport, facture, societe, service, banque_ _ **Database type manager:** mysqli_ _ **Latest database access request error:** SELECT f.rowid, f.date\_lim\_reglement as datefin,f.fk\_statut, f.total FROM llx\_facture as f WHERE f.paye=0 AND f.entity IN (1) AND f.fk\_statut = 1_ _ **Return code for latest database access request error:** DB\_ERROR\_NOSUCHFIELD_ _ **Information for latest database access request error:** Unknown column ‘f.total’ in ‘field list’_ Many thanks. Raf ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [November 11, 2021, 8:12pm UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/8 "2021-11-11T20:12:16Z")
> [@rb3800](#): > > llx\_facture You seem to have a problem with this database table. The fields don’t exist. Check you database installation files (install folder) to see if you can identify in which version those fields were meant to be created then try to create them. Thats how I would try to approach the issue. ---
**Author:** ![rb3800](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rb3800](https://www.dolibarr.org/forum/u/rb3800)\ **Post date:** [November 12, 2021, 9:03am UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/9 "2021-11-12T09:03:34Z")
Hi aljawaid, I removed the 14.0.3 version, restored the DB and reinstalled the previous Dolibarr version (13.0.5). Everything works. Then I downloaded and installed again the 14 version by upload the htdocs folder. Again appears the following error message: ![Screenshot 2021-11-11 at 23.50.04](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/0/01a880a9eec21393c009f9f31248a470447c60d0.png) Thanks ---
**Author:** ![aljawaid](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/aljawaid/32/388_2.png) [@aljawaid](https://www.dolibarr.org/forum/u/aljawaid)\ **Post date:** [November 12, 2021, 10:32am UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/10 "2021-11-12T10:32:37Z")
> > > \# Fix #17258\[\*fk\_warehouse missing\*\] > Bug in new install because fk\_entrepot to …fk\_warehouse not change in sql script > > > \# Close #17258\[\*fk\_warehouse missing\*\] > \[\*Long description\*\] Possibly try this manual change in the file, then re-upload and try again to upgrade. ---
**Author:** ![Klaas](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/klaas/32/486_2.png) [@Klaas](https://www.dolibarr.org/forum/u/Klaas)\ **Post date:** [November 13, 2021, 11:12am UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/11 "2021-11-13T11:12:35Z")
Hi, Did you to update from 13.0.5 to 14.0.3 in one session? Try first 14.0.0 then update to 14.0.1 then update to 14.0.2 and at last upgrade to 14.0.3. ---
**Author:** ![mama71850](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/13edae/32.png) [@mama71850](https://www.dolibarr.org/forum/u/mama71850)\ **Post date:** [November 15, 2021, 8:22am UTC](https://www.dolibarr.org/forum/t/access-to-login-impossible-14-0-3/21404/12 "2021-11-15T08:22:22Z")
Hi rb3800, I have the same issue that you. I reinstall the previous version (13.0) and restore the DB. So if somebody have the solution, let me know too. Maybe it’s an issue of added modules maybe?