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 More...