Error 'dolibarr.llx_user' doesn't exist

Installing my Dolibarr
1

Hi Dolibarr Community

I tried to install Dolibarr on our Synology Nas and I encounter this error after trying to log in:

‘dolibarr.llx_user’ doesn’t exist

for reference, I follow this vlog for the installation:

Any suggestion or recommendation on how to fix this issue

Thank you

2

I found out it was Database Charset problem
the error was happen during installation on utf8mb4_general_ci
then I reinstall it in utf8mb4_bin ### It works, Yeah!!! :grinning:

3

Hello,

Dolibarr database charset should be utf8_general_ci
If a table does not exist, and then, when you change charset, it exist : That’s means that the table was corrupted.

4

Dolibarr version 18.0.3
Php7.4&8.1
Mariadb 10

I take a over night to test it, it nothing relate to charset. is the module issue
neither nothing relate to php version

When I enable module “PARTNERSHIP MANAGEMENT” could not create customer/vendor/
When I enable module “STOCKS” could not open [Products > Inventory]

but when I disabled these two modules, everything looks fine

5

could dolibarr working on utf8mb4_general_ci ?

6

Yes but you could have some bugs.
Exemple : migration issues · Issue #16315 · Dolibarr/dolibarr · GitHub

7

Hi,
I am having excactly this issue. Can you please guide me through on your solution?
I have a ds124, followed the guide but the last step gives me the same error message.

Thanks in advance.

8

Hi,
Have you solved the issue?

9

which dolibarr version do you run @Shapord ?

10

Hi Jon,
I am on 21.0.2, but managed to make it work.
I deleted the container folders, the images and the stack. Basically started over and now I am setting up dolibarr finally. I don’t know where the mistake was but most importantly it works now.
Cheers!

1 Like