# Problem with login after upgrade to V18.0.0 **URL:** \ **Category:** Installing my Dolibarr\ **Created:** [August 18, 2023, 2:42pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159 "2023-08-18T14:42:56Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [August 18, 2023, 2:42pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/1 "2023-08-18T14:42:56Z")
it is giving an error “Unknown column ‘flagdelsessionsbefore’ in ‘field list’” this is after upgrade from V17.0.3 to V18.0.0 and system is Ubuntu V22.04.3 with MariaDB and PHPv8.1.3 ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [August 18, 2023, 3:02pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/2 "2023-08-18T15:02:25Z")
i found it my self it was related to user rights on server ---
**Author:** ![piromanu](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/p/d07c76/32.png) [@piromanu](https://www.dolibarr.org/forum/u/piromanu)\ **Post date:** [August 18, 2023, 4:53pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/3 "2023-08-18T16:53:20Z")
I wanted to update today so happy i didn’t. I’ll just wait a little. How did you solve it? ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [August 18, 2023, 8:30pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/4 "2023-08-18T20:30:39Z")
just change owner on all files in web folder ---
**Author:** ![piromanu](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/p/d07c76/32.png) [@piromanu](https://www.dolibarr.org/forum/u/piromanu)\ **Post date:** [August 18, 2023, 9:30pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/5 "2023-08-18T21:30:08Z")
do you mean permissions? or what? it’s not clear what owner should i change ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [August 19, 2023, 7:08am UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/6 "2023-08-19T07:08:00Z")
i did this root@eksampel:/# chown -R www-data /usr/share/dolibarr/ remember to be superuser normal user= root@eksampel:/$ super user = root@eksampel:/# ---
**Author:** ![edupulpillo](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/e/7ab992/32.png) [@edupulpillo](https://www.dolibarr.org/forum/u/edupulpillo)\ **Post date:** [December 11, 2023, 3:17am UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/7 "2023-12-11T03:17:19Z")
> [@nemprinter](#): > > user rights on server how did you fix it? i have the same problem ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [December 11, 2023, 6:00am UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/8 "2023-12-11T06:00:13Z")
i change owners on file in folder /usr/share/dolibarr/ ---
**Author:** ![refedo](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/refedo/32/3533_2.png) [@refedo](https://www.dolibarr.org/forum/u/refedo)\ **Post date:** [May 23, 2024, 9:44pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/9 "2024-05-23T21:44:35Z")
How to change user rights if anyone has solved the issue? ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [May 24, 2024, 4:43am UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/10 "2024-05-24T04:43:02Z")
what system are we talking about ---
**Author:** ![refedo](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/refedo/32/3533_2.png) [@refedo](https://www.dolibarr.org/forum/u/refedo)\ **Post date:** [May 25, 2024, 10:08am UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/11 "2024-05-25T10:08:09Z")
Now i have upgraded to Dolibarr 19.0.2 and I’m facing Unknown column ‘flagdelsessionsbefore’ in ‘field list’ Anyone came through this issue and solved it? ---
**Author:** ![Metzo](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@Metzo](https://www.dolibarr.org/forum/u/Metzo)\ **Post date:** [July 21, 2024, 12:32pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/12 "2024-07-21T12:32:49Z")
Hello I face the same issue after upgrading dto V190.2. message error : Unknown column ‘flagdelsessionsbefore’ in ‘field list’ Can anyone help to fix this issue ? I read also previous help but i can’t understand how to fix it. Thanks for your help ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [July 21, 2024, 1:50pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/13 "2024-07-21T13:50:23Z")
what operation system are you using ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [July 21, 2024, 1:55pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/14 "2024-07-21T13:55:15Z")
i can see you are using [Lws.fr](http://Lws.fr) hosting you have to change ownership of files ---
**Author:** ![Metzo](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@Metzo](https://www.dolibarr.org/forum/u/Metzo)\ **Post date:** [July 21, 2024, 1:57pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/15 "2024-07-21T13:57:48Z")
Thank a lot. Do you have an idea how i can do that ? ---
**Author:** ![nemprinter](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/nemprinter/32/433_2.png) [@nemprinter](https://www.dolibarr.org/forum/u/nemprinter)\ **Post date:** [July 21, 2024, 2:27pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/16 "2024-07-21T14:27:52Z")
i think you shut contact [LWS.fr](http://LWS.fr) and see if they have a help forum that can guide you to change ownership of file ---
**Author:** ![Metzo](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@Metzo](https://www.dolibarr.org/forum/u/Metzo)\ **Post date:** [July 21, 2024, 2:40pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/17 "2024-07-21T14:40:42Z")
Thank a lot. i will ask them ---
**Author:** ![JRoch](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/ed655f/32.png) [@JRoch](https://www.dolibarr.org/forum/u/JRoch)\ **Post date:** [February 6, 2025, 8:45am UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/18 "2025-02-06T08:45:55Z")
Hello, I have the same problem : I updated Dolibarr from v17 to v20. The updates went well but I got this message on the login page: Unknown column ‹ flagdelsessionsbefore › in ‹ field list › I can’t go any further. Dolibarr is installed on my web hosting **Database server:** ``` Server: Localhost via UNIX socket Server type: MariaDB Connecting to the server: SSL is not used Server version: 10.11.6-MariaDB-0+deb12u1 - Debian 12 Protocol version: 10 Server character set: UTF-8 Unicode (utf8mb4) ``` **Web server** ``` Apache/2.4.62 (Debian) Database client version: libmysql - mysqlnd 8.2.26 PHP extension: mysqli mbstring sodium PHP version: 8.2.26 ``` **phpMyAdmin** ``` Version: 5.2.1 ``` I tried 2 update methods: ``` With the AutoUpgrade extension AutoUpgrade Module/Update Manually by overwriting the v20 files on my FTP ``` I arrive at the same result. What files need to be modified legally? I have to start the update again and if so how? Thank you very much for your help ---
**Author:** ![cbarbozac](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/c/9e8a1a/32.png) [@cbarbozac](https://www.dolibarr.org/forum/u/cbarbozac)\ **Post date:** [February 13, 2025, 8:50pm UTC](https://www.dolibarr.org/forum/t/problem-with-login-after-upgrade-to-v18-0-0/24159/19 "2025-02-13T20:50:34Z")
Hello JROCh. I resolved this same problem with update 16.04 version to 20.02 ( Feb 2025 ) directly. We I did this process, the Indexpage show me 3 erros: 1. Unkown column “flagdelsessionsbefore” in “Select” This column must exist in llx\_user so it is necessary to add it. Please check your llx\_user table first and if it does not exist, please proceed. - DESCRIBE llx\_user; If dont not exits flagdelsessionsbefore colum pĺease add: - ALTER TABLE llx\_user MODIFY COLUMN flagdelsessionsbefore DATETIME DEFAULT NULL; 1. Please repeate the same the process ( in your index page or Login Page) if show Alert now with Unknown column "email\_oauth2 " in Select - ALTER TABLE llx\_user ADD COLUMN email\_oauth2 VARCHAR(255) DEFAULT NULL; 1. And the lastone, with the Unkown column "note\_private ": - ALTER TABLE llx\_user ADD COLUMN note\_private TEXT DEFAULT NULL; With the above, I simply had access to the platform with the new version. Best Regards,