Publisher is EE6 compatible, but it does not support the Fluid field.

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, 2021

Hello, 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.

#1

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.

#2

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?

#3

BoldMinded (Brian)

Jan 05, 2021

Never mind, I found it.

#4

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.

#5

BoldMinded (Brian)

Mar 03, 2021

This should be fixed in 4.6

Login to reply