Error

 
[17-11-2025 18:13:42 UTC] [17-11-2025 18:13:42 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 /apparel/products 
 

Debug Backtrace

#1 RMasterModel.php:191 -- RMasterModel->getResultSet()
#2 CorporateProductsTrait.php:344 -- RMasterModel->exec_query()
#3 ProductsMaster.php:942 -- ProductsMaster->exec_query()
#4 productlist_category_wise.php:106 -- ProductsMaster->getProductsDetail()

Params: Array
(
    [:fields] => product_category_description.category_name, product_category_description.description, product_category_description.long_description, product_category_description.long_description_two, product_category_description.site_language_id, product_category.quick_add_to_cart, product_category.status, products.products_id, products.enable_stock_management, products.price_defining_method, products.predefined_product_type, products.category_id, products.multiple_category, product_category.category_id as cat_id, products_description.imagename, products_description.products_title, products_description.product_description, products_description.product_url, products_description.product_promotional_text, products.kit_type_id, products_description.imagename_alt, products_description.product_desc_image_alt, product_price.product_price_id, products_description.products_internal_title, products_description.metadata
    [:conditions] => {"site_language_id":1,"visible":1,"category_id":5,"include_kit":"false","store_access":" AND ((products.user_type_id IN ('0','1')))","corporate_id":0,"parent_corporate_id":0,"store_access_price":" AND ((product_price.user_type_id IN ('0','1')))","found_rows":"true","visible_options":"1","hidden_product":"yes","is_admin":0,"modules":"0,11,2,1,3,12,14,15,17,16","product_service_type":"2,1,3,4,5"}
    [:extra] => {"groupby":"products.products_id","orderby":"products.sort_order,products_description.products_title","offset":0,"limit":"12"}
)

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');

287:     {
288:         $this->resetVariables($var);
289:     }