Ошибка 1273 Answered

Здравствуйте!

Недавно после обновления перестал работать поиск

SS 8.3.0.7

ИПП 1.5.3.0.0

Импортирую файл прайса, хочу поискать среди позиций прайса необходимую мне. После нажатия энтер вылазиет ошибка 1273

В логах:

Query Error 1273: Unknown collation: 'utf8mb4'
Query: SELECT SQL_CALC_FOUND_ROWS
            ssk.product_sku_id shop_sku_id
          FROM shop_kmsuppliers_import_log sil
          LEFT JOIN shop_kmsuppliers_import_skus ssis ON ssis.product_sku_id = sil.product_sku_id AND ssis.import_id = 288
          LEFT JOIN shop_kmsuppliers_sku ssk ON ssk.id = ssis.supplier_sku_id
          LEFT JOIN shop_kmsuppliers_supplier ss ON ss.id = ssk.supplier_id
          LEFT JOIN shop_product_skus sps ON sps.id = sil.product_sku_id
          LEFT JOIN shop_product sp ON sp.id = sps.product_id
          WHERE
            sil.import_id = 288
            AND sil.supplier_sku_id > 0
            AND CONCAT(IF(ssk.article IS NULL, '', ssk.article), ' ', IF(ss.name IS NULL, '', ss.name), ' ', IF(sp.name IS NULL, '', sp.name), ' ', IF(sps.name IS NULL, '', sps.name), ' ', IF(sps.sku IS NULL, '', sps.sku)) LIKE '%asda%' collate utf8mb4
            
            GROUP BY ssk.product_sku_id
            
            LIMIT 50
## wa-system/database/waModel.class.php(257)

В общих настройках плагина (расширенные настройки) в поле Mysql collate написано utf8mb4

Пробовал менять эту настройку на utf8_general_ci

Тогда ошибка другая:

Query Error 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
Query: SELECT SQL_CALC_FOUND_ROWS
            ssk.product_sku_id shop_sku_id
          FROM shop_kmsuppliers_import_log sil
          LEFT JOIN shop_kmsuppliers_import_skus ssis ON ssis.product_sku_id = sil.product_sku_id AND ssis.import_id = 288
          LEFT JOIN shop_kmsuppliers_sku ssk ON ssk.id = ssis.supplier_sku_id
          LEFT JOIN shop_kmsuppliers_supplier ss ON ss.id = ssk.supplier_id
          LEFT JOIN shop_product_skus sps ON sps.id = sil.product_sku_id
          LEFT JOIN shop_product sp ON sp.id = sps.product_id
          WHERE
            sil.import_id = 288
            AND sil.supplier_sku_id > 0
            AND CONCAT(IF(ssk.article IS NULL, '', ssk.article), ' ', IF(ss.name IS NULL, '', ss.name), ' ', IF(sp.name IS NULL, '', sp.name), ' ', IF(sps.name IS NULL, '', sps.name), ' ', IF(sps.sku IS NULL, '', sps.sku)) LIKE '%zcz%' collate utf8_general_ci
            
            GROUP BY ssk.product_sku_id
            
            LIMIT 50
## wa-system/database/waModel.class.php(257)

Все бд и все таблицы всегда создавались в кодировке utf8_general_ci

mysql 5.7 - с последними обновлениями

нигде кроме вашего плагина проблем нету

таблицы kmsuppll* созданы на utf8_general_ci