Плагин прайс листы поставщиков не работает поиск Answered

3

Здравствуйте, при попытке поиска товара в плагине ыдает вот такую ошибку

<h2>Query Error 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4'
Query: SELECT SQL_CALC_FOUND_ROWS skus.article article, skus.id article_id, sss.id supplier_id, sss.name supplier_name, skus.description description, skus.exclude exclude, pdcts.id product_id, pdcts.name product_name, pskus.id product_sku_id, pskus.name product_sku_name, pskus.sku product_sku_sku
FROM shop_kmsuppliers_sku skus
LEFT JOIN shop_kmsuppliers_supplier sss ON sss.id = skus.supplier_id LEFT JOIN shop_product_skus pskus ON skus.product_sku_id = pskus.id LEFT JOIN shop_product pdcts ON pskus.product_id = pdcts.id
WHERE skus.supplier_id IN (13) AND pskus.product_id IS NULL AND skus.exclude = 0 AND CONCAT(skus.article, ' ', sss.name, ' ', skus.description, ' ', IF(pdcts.name IS NULL, '', pdcts.name) , ' ', IF(pskus.name IS NULL, '', pskus.name), ' ', IF(pskus.sku IS NULL, '', pskus.sku)) LIKE '%ботоны%' collate utf8_general_ci
ORDER BY skus.exclude, skus.id
LIMIT 50 code 1253</h2>
## wa-system/database/waModel.class.php(257)
#0 wa-system/database/waModel.class.php(357): waModel->run('SELECT SQL_CALC...')
#1 wa-system/database/waDbStatement.class.php(229): waModel->query('SELECT SQL_CALC...')
#2 wa-system/database/waModel.class.php(337): waDbStatement->query(Array)
#3 wa-apps/shop/plugins/kmsuppliers/lib/model/shopKmsuppliersPluginSku.model.php(162): waModel->query('SELECT SQL_CALC...', Array)
#4 wa-apps/shop/plugins/kmsuppliers/lib/actions/supplier/shopKmsuppliersPluginSupplier.action.php(30): shopKmsuppliersPluginSkuModel->getSuppliersSkus(13, 'unrelated', 0, 50, '/xD0/xB1/xD0/xBE/xD1/x82/xD0/xBE/xD0/xBD/xD1/x8B', true)
#5 wa-system/controller/waViewAction.class.php(160): shopKmsuppliersPluginSupplierAction->execute()
#6 wa-system/controller/waViewController.class.php(86): waViewAction->display()
#7 wa-system/controller/waDefaultViewController.class.php(48): waViewController->executeAction(Object(shopKmsuppliersPluginSupplierAction))
#8 wa-system/controller/waController.class.php(21): waDefaultViewController->execute()
#9 wa-system/controller/waViewController.class.php(46): waController->run(NULL)
#10 wa-system/controller/waFrontController.class.php(254): waViewController->run(NULL)
#11 wa-system/controller/waFrontController.class.php(189): waFrontController->runController(Object(waDefaultViewController), NULL)
#12 wa-system/controller/waFrontController.class.php(83): waFrontController->execute('kmsuppliers', 'supplier', NULL)
#13 wa-system/waSystem.class.php(582): waFrontController->dispatch()
#14 wa-system/waSystem.class.php(501): waSystem->dispatchBackend('G1abr8NskIa3lIe...')
#15 index.php(7): waSystem->dispatch()
#16 {main}
<h2>GET</h2>
array(
  'plugin' => 'kmsuppliers',
  'module' => 'supplier',
  'id' => '13',
  'skus' => 'unrelated',
  'start' => '0',
  'records' => '50',
  'search' => 'ботоны',
  '_' => '1564831505915',
)
<h2>Params</h2>
array()
Posted: August 3, 2019

7 comments

Add comment

To add a comment please sign up or login