Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.
Ticket: Illegal mix of collations error when installing Bloqs
Status | Resolved |
Add-on / Version | Bloqs 4.5.1 |
Severity | |
EE Version | 6.0.0 |
Jarod Clark
Jan 05, 2021Hello, we’re having an issue with installing Bloqs on a new EE6 installation.
This error comes up during the install process:
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE) for operation '=':
SELECT * FROM information_schema.columns WHERE table_schema = database() and table_name = "exp_blocks_atom" and column_name = "data" and is_nullable = "NO"
The database is set to utf8mb4_general_ci, so not sure where the other collations are coming from.
This is on a MySql 8.0.22 server.
BoldMinded (Brian)
I haven’t tested any add-ons on MySQL 8. For the time being your best bet is to downgrade.
BoldMinded (Brian)
Is there more to that error message? E.g. the call stack so I know what is generating that query?
BoldMinded (Brian)
Never mind, I found it.
Jarod Clark
Here’s the full error:
<pre><code>SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE) for operation ‘=’: SELECT * FROM information_schema.columns WHERE table_schema = database() and table_name = “exp_blocks_atom” and column_name = “data” and is_nullable = “NO” ee/legacy/database/drivers/mysqli/mysqli_connection.php:117
Stack Trace: Please include when reporting this error
0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query()
1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute()
2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query()
3 user/addons/bloqs/updates/up_1_02_04.php(36): CI_DB_driver->query()
4 user/addons/bloqs/Library/Basee/Updater.php(95): Update_1_02_04->doUpdate()
5 user/addons/bloqs/upd.bloqs.php(144): BoldMinded\Bloqs\Library\Basee\Updater->runUpdates()
6 user/addons/bloqs/upd.bloqs.php(75): Bloqs_upd->update()
7 ee/legacy/libraries/addons/Addons_installer.php(68): Bloqs_upd->install()
8 ee/legacy/libraries/addons/Addons_installer.php(358): Addons_installer->install_module()
9 ee/legacy/libraries/addons/Addons_installer.php(35): Addons_installer->_update_addon()
10 ee/ExpressionEngine/Controller/Addons/Addons.php(1395): Addons_installer->install()
11 ee/ExpressionEngine/Controller/Addons/Addons.php(564): ExpressionEngine\Controller\Addons\Addons->installModule()
12 [internal function]: ExpressionEngine\Controller\Addons\Addons->install()
13 ee/ExpressionEngine/Core/Core.php(268): call_user_func_array()
14 ee/ExpressionEngine/Core/Core.php(118): ExpressionEngine\Core\Core->runController()
15 ee/ExpressionEngine/Boot/boot.php(162): ExpressionEngine\Core\Core->run()
16 admin.php(154): require_once(‘…’)
16 admin.php(154): require_once(‘…’)<pre><code>
Ah yeah, that makes sense. I can see what we can do there. I think MySql 8 is the default install on Ubuntu server 20.04.3 LTS.
BoldMinded (Brian)
This should be fixed in 4.6