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)
Jan 05, 2021
I haven’t tested any add-ons on MySQL 8. For the time being your best bet is to downgrade.
BoldMinded (Brian)
Jan 05, 2021
Is there more to that error message? E.g. the call stack so I know what is generating that query?
BoldMinded (Brian)
Jan 05, 2021
Never mind, I found it.
Jarod Clark
Jan 05, 2021
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)
Mar 03, 2021
This should be fixed in 4.6