# How can i fix "Illegal mix of collations (utf8mb3\_general\_ci,IMPLICIT) and (utf8mb3\_unicode\_ci,IMPLICIT) for operation '=' in accountancy **URL:** \ **Category:** Financial modules\ **Tags:** Issue\ **Created:** [March 12, 2024, 11:14am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085 "2024-03-12T11:14:32Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 11:14am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/1 "2024-03-12T11:14:32Z")
![FireShot Capture 271 - Products accounts - cassvita.cloud](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/7/733bf1515838898f11098e1b9e52b76e3c764fc0.png) I am using dolibarr on a cloud host. What do i have to change to make it work properly? Thanks ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [March 12, 2024, 12:08pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/2 "2024-03-12T12:08:22Z")
Just browse to : /install/repair.php?force\_utf8\_on\_tables=confirmed > **[Troubleshooting](https://wiki.dolibarr.org/index.php?title=Troubleshooting)** > > Online wiki documentation of Dolibar ERP CRM software ---
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 12:57pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/3 "2024-03-12T12:57:16Z")
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 ? ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [March 12, 2024, 1:06pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/4 "2024-03-12T13:06:51Z")
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` ---
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 1:30pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/5 "2024-03-12T13:30:17Z")
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](https://cassvita.cloud/admin/index.php?mainmenu=home&leftmenu=setup) ---
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 2:15pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/6 "2024-03-12T14:15:17Z")
I have changed the lock file install.lock to install.lock.old but problem still not fix ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 12, 2024, 4:21pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/7 "2024-03-12T16:21:36Z")
which error message? Maybe a picture? ---
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 4:27pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/8 "2024-03-12T16:27:57Z")
![FireShot Capture 271 - Products accounts - cassvita.cloud](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/7/733bf1515838898f11098e1b9e52b76e3c764fc0.png) ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [March 12, 2024, 4:31pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/9 "2024-03-12T16:31:07Z")
Then you need to go on your database manager (phpmyadmin or other) and change all the table interclassement to utf8mb3\_general\_ci ---
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 4:33pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/10 "2024-03-12T16:33:34Z")
Ok. will do that immediately ---
**Author:** ![Bawish](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@Bawish](https://www.dolibarr.org/forum/u/Bawish)\ **Post date:** [March 12, 2024, 4:51pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/11 "2024-03-12T16:51:13Z")
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](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/b/bc4e5dd63cfa8a160ef23d669ccab466d8d2de6d.png) 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. ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [March 12, 2024, 5:53pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/12 "2024-03-12T17:53:42Z")
Hello, I’m not a specialist on this type of issue, but if think you can leave like that for the moment. ---
**Author:** ![nawnaw](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/5f8ce5/32.png) [@nawnaw](https://www.dolibarr.org/forum/u/nawnaw)\ **Post date:** [February 1, 2025, 6:18am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/13 "2025-02-01T06:18:54Z")
Hello dear , i have the same issue . dolibar version 20.0.3 ---
**Author:** ![nawnaw](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/5f8ce5/32.png) [@nawnaw](https://www.dolibarr.org/forum/u/nawnaw)\ **Post date:** [February 1, 2025, 6:19am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/14 "2025-02-01T06:19:57Z")
can you help me please ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [February 1, 2025, 8:28am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/15 "2025-02-01T08:28:13Z")
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 ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [February 1, 2025, 10:02am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/16 "2025-02-01T10:02:57Z")
Hello, > [@ksar](#): > > To do that, browse on your internet browser to the adresse : `http://my-beautiful-dolibarr.com/install/repair.php?force_utf8_on_tables=confirmed` Should solve the issue ---
**Author:** ![nawnaw](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/5f8ce5/32.png) [@nawnaw](https://www.dolibarr.org/forum/u/nawnaw)\ **Post date:** [February 1, 2025, 11:29am UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/17 "2025-02-01T11:29:17Z")
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] ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [February 1, 2025, 4:01pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/18 "2025-02-01T16:01:00Z")
Hello, > [@nawnaw](#): > > (due to the existence of an **install.lock** lock file in the dolibarr documents directory) Remove the install.lock file in the document folder. ---
**Author:** ![nawnaw](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/n/5f8ce5/32.png) [@nawnaw](https://www.dolibarr.org/forum/u/nawnaw)\ **Post date:** [February 1, 2025, 9:58pm UTC](https://www.dolibarr.org/forum/t/how-can-i-fix-illegal-mix-of-collations-utf8mb3-general-ci-implicit-and-utf8mb3-unicode-ci-implicit-for-operation-in-accountancy/25085/19 "2025-02-01T21:58:53Z")
thanks you for your help