How can i fix "Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '=' in accountancy

Using my Dolibarr Financial modules
1

FireShot Capture 271 - Products accounts - cassvita.cloud
FireShot Capture 271 - Products accounts - cassvita.cloud1088Ă—545 24.7 KB

I am using dolibarr on a cloud host. What do i have to change to make it work properly? Thanks

2

Just browse to : /install/repair.php?force_utf8_on_tables=confirmed

3

Thanks Ksar,
I have browse through the different responds to similar issues but still not working. Is there any i need to change in my database / directories ?

4

Hello,

Yes you need to run the repair script.
To do that, browse on your internet browser to the adresse : http://my-beautiful-dolibarr.com/install/repair.php?force_utf8_on_tables=confirmed

5

I now get the following error message:

"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, you must remove the file install.lock or create a file upgrade.unlock into the Dolibarr documents directory."
Click here to go to your application

6

I have changed the lock file install.lock to install.lock.old but problem still not fix

7

which error message? Maybe a picture?

8

FireShot Capture 271 - Products accounts - cassvita.cloud
FireShot Capture 271 - Products accounts - cassvita.cloud1088Ă—545 24.7 KB

9

Then you need to go on your database manager (phpmyadmin or other) and change all the table interclassement to utf8mb3_general_ci

1 Like
10

Ok. will do that immediately

11

I succeeded to change all table in phpmyadmin apart from the “gzrb_accounting_account” which had the error message:
FireShot Capture 273 - auth-db1054.hstgr.io _ 127.0.0.1 _ u836212010_bTlg0 - phpMyAdmin 5.2._ - auth-db1054.hstgr.io

Is it possible to change “gzrb_accounting_account” to utf8mb3_unicode_ci ?
It is now utf8mb4_inicode_ci while all other tables are utf8mb3_unicode_ci.

12

Hello,

I’m not a specialist on this type of issue, but if think you can leave like that for the moment.

13

Hello dear , i have the same issue .
dolibar version 20.0.3

14

can you help me please

15

please be more specific, post a picture of the exact error, and if it really is exactly like this I believe @ksar posted a fix higher up involving phpmyadmin

16

Hello,

Should solve the issue

17

This is the message that i have

The application tried to upgrade automatically, but the install/upgrade pages were disabled for security reasons (due to the existence of an install.lock lock file in the dolibarr documents directory).

If an update is in progress, please wait… Otherwise, you must delete the install.lock file (or create an upgrade.unlock file) in the Dolibarr documents folder. [Click here to go to your application]

18

Hello,

Remove the install.lock file in the document folder.

19

thanks you for your help