What is the error when updating bitrix public_html/bitrix/modules/main/lib/db/mysqliconnection.php:137?

Question

1C-Bitrix

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1271) Illegal mix of collations for operation 'UNION' (400)

        SELECT NULL AS SITE_ID, NAME, VALUE 
        FROM b_option 
        WHERE MODULE_ID = 'main' 
        UNION
        SELECT SITE_ID, NAME, VALUE 
        FROM b_option_site 
        WHERE MODULE_ID = 'main' 
      
/home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/config/option.php:200
#2: Bitrix\Main\Config\Option::load(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/config/option.php:38
#3: Bitrix\Main\Config\Option::get(string, string, string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/httprequest.php:392
#4: Bitrix\Main\HttpRequest->prepareCookie(array)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/httprequest.php:69
#5: Bitrix\Main\HttpRequest->__construct(object, array, array, array, array)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/httpapplication.php:46
#6: Bitrix\Main\HttpApplication->initializeContext(array)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/lib/application.php:122
#7: Bitrix\Main\Application->initializeExtendedKernel(array)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/include.php:22
#8: require_once(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/include/prolog_before.php:14
#9: require_once(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/include/prolog.php:10
#10: require_once(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/header.php:1
#11: require(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/index.php:2
#12: include_once(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/modules/main/include/urlrewrite.php:159
#13: include_once(string)
  /home/s/suppornr/suppornr.bget.ru/public_html/bitrix/urlrewrite.php:2

Guys when updating Bitrix from version 18 got out. What's wrong? how to fix?

Answer 1

https://dev.1c-bitrix.ru/support/forum/forum6/topi...