Problem with login after upgrade to V18.0.0

Installing my Dolibarr
1

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

2

i found it my self it was related to user rights on server

1 Like
3

I wanted to update today so happy i didn’t. I’ll just wait a little. How did you solve it?

4

just change owner on all files in web folder

5

do you mean permissions? or what? it’s not clear what owner should i change

6

i did this
root@eksampel:/# chown -R www-data /usr/share/dolibarr/

remember to be superuser
normal user= root@eksampel:/$
super user = root@eksampel:/#

7

how did you fix it? i have the same problem

8

i change owners on file in folder /usr/share/dolibarr/

9

How to change user rights if anyone has solved the issue?

10

what system are we talking about

11

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?

12

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

13

what operation system are you using

14

i can see you are using Lws.fr hosting you have to change ownership of files

15

Thank a lot.
Do you have an idea how i can do that ?

16

i think you shut contact LWS.fr and see if they have a help forum that can guide you to change ownership of file

17

Thank a lot. i will ask them

1 Like
18

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

19

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,