Error
[17-11-2025 18:08:53 UTC] [17-11-2025 18:08:53 UTC] [ERROR] : [Exception, 0] Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation 'locate' @line 1022 in file /home/promo/public_html/lib/Classes/Models/RMasterModel.php
GET promo.fourprintshop.com /product-list-withoutimage.html
Debug Backtrace
#1 RMasterModel.php:191 -- RMasterModel->getResultSet()
#2 CorporateProductsTrait.php:344 -- RMasterModel->exec_query()
#3 ProductsMaster.php:942 -- ProductsMaster->exec_query()
#4 sitemap.php:41 -- ProductsMaster->getProductsDetail()
#5 cms.php:195 -- require_once(...)
Last Query :
CALL USPGetProductsDetail('products_description.products_title,products.products_id, products.category_id, product_category_description.category_name', '{\"visible\":1,\"store_access\":\" AND ((products.user_type_id IN (\'0\',\'1\')))\",\"site_language_id\":1,\"multiple_category\":\"false\",\"corporate_id\":0,\"status\":\"1\",\"is_admin\":0,\"modules\":\"0,11,2,1,3,12,14,15,17,16\",\"product_service_type\":\"2,1,3,4,5\"}', '{\"orderby\":\"product_category.sort_order ASC, product_category.category_id ASC,products.sort_order ASC, products_description.products_title ASC, products.products_id ASC\",\"groupby\":\"products.products_id\"}') Prepared Statement :
CALL USPGetProductsDetail(:fields, :conditions, :extra) Params: Array
(
[:fields] => products_description.products_title,products.products_id, products.category_id, product_category_description.category_name
[:conditions] => {"visible":1,"store_access":" AND ((products.user_type_id IN ('0','1')))","site_language_id":1,"multiple_category":"false","corporate_id":0,"status":"1","is_admin":0,"modules":"0,11,2,1,3,12,14,15,17,16","product_service_type":"2,1,3,4,5"}
[:extra] => {"orderby":"product_category.sort_order ASC, product_category.category_id ASC,products.sort_order ASC, products_description.products_title ASC, products.products_id ASC","groupby":"products.products_id"}
)
Show Less...
#0 /home/promo/public_html/model/ProductsMaster.php(939): RMasterModel->setProcedure('CALL USPGetProductsDetail(:fields, :conditions, :extra)', Array, Array)938: $Query = 'CALL USPGetProductsDetail(:fields, :conditions, :extra)';
939: $this->setProcedure($Query, array(':fields' => $fields, ':conditions' => opsJsonEncode($conditions), ':extra' => opsJsonEncode($extraParams)), array(':fields' => 'string', ':conditions' => 'string', ':extra' => 'string'));
940: if ($cache) $this->setCache('product');
#1 /home/promo/public_html/lib/Classes/Models/RMasterModel.php(288): RMasterModel->resetVariables()287: {
288: $this->resetVariables($var);
289: }