A Database Error Occurred

Error Number: 1267

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

SELECT SQL_CALC_FOUND_ROWS prop.*, state.title AS statename, neighborhood.title AS localityname, city.title as cityname, usr.user_type AS usertype, usr.user_name as uemail FROM (`tbl_property` as prop) INNER JOIN `tbl_users` AS usr ON `prop`.`mem_id`=`usr`.`user_id` INNER JOIN `tbl_states` AS state ON `prop`.`state`=`state`.`id` INNER JOIN `tbl_city` AS city ON `prop`.`city`=`city`.`id` INNER JOIN `tbl_neighborhood` AS neighborhood ON `prop`.`locality`=`neighborhood`.`id` WHERE `usr`.`status` ='1' AND state.status='1' AND city.status='1' AND prop.status='1' AND prop.city_name='Damān' ORDER BY `prop`.`post_date` desc LIMIT 20

Filename: /home/propertyhubworld/public_html/modules/property/models/property_model.php

Line Number: 524