Error 0

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='. The SQL statement executed was: SELECT DISTINCT `t`.`id`, `t`.`name_en`, `t`.`name_ar`, `t`.`manufacturer_id`, `t`.`description_en`, `t`.`sell_price`, `t`.`stock_price`, `t`.`quantity`, `t`.`in_carts_quantity`, `t`.`weight`, `t`.`tax_id`, `t`.`created_at`, `t`.`updated_at`, `t`.`image_uri`, `t`.`is_available`, `t`.`is_featured`, `t`.`description_ar`, `t`.`sale_id`, `t`.`has_shipping_method`, `t`.`more_info`, `t`.`attributes_checksum`, `t`.`reviews_rate`, `t`.`reviews_stat`, `t`.`sold_quantity`, `t`.`short_name`, `t`.`status`, `t`.`item_code`, `t`.`pieces_per_pack`, `t`.`packs_per_box`, `t`.`cbm`, `t`.`name_fr`, `t`.`description_fr`, `t`.`price_in_dollar`, `t`.`collection_id`, `t`.`sku`, `t`.`dimensions`, `t`.`on_sale`, `t`.`old_price`, `t`.`item_order`, `t`.`new_price`, `t`.`artwork_id` FROM `tbl_item` `t` inner join tbl_item_attribute_value as iv on t.id = iv.item_id left join tbl_artwork as art on t.artwork_id = art.id WHERE (iv.attribute_value=:ycp0) AND ( t.status > 0 and (t.artwork_id is null or art.expiry_date > 1568900940)). Bound with :ycp0='Bedroom‚Ć©=en/?lang=en'

line: 543 in:/home/ubuntu/yii/yii-1.1.17.467ff50/framework/db/CDbCommand.php

Take Me Home