view member journals


Search All Journals

MySQL error 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
When executing:
SELECT SQL_CALC_FOUND_ROWS journal_count, ld.LD_id, ld.LD_firstname, ld.LD_gender, ld.LD_about_yourself, ld.LD_date_of_birth, ld.image_name, jd.JED_journal, jd.JED_title, jd.JED_server_time, jd.JED_timezone, jd.JED_id, concat(jd.JED_date,' ',jd.JED_time) as d1, cd.CD_country, sn.state_name FROM journal_entry_details jd ignore index (status2) left join login_details ld on jd.LD_ID=ld.LD_ID left join count_journals_per_user_cache as jee on jee.LD_id=jd.LD_id left join journal_tags on jd.JED_ID=journal_tags.JED_ID left JOIN country_details cd ON cd.CD_id=ld.CD_id left join state_names sn on sn.state_id=ld.state_id where LD_status = 'A' AND JED_entry_type = 'P' AND JED_status = 'A' AND JD_tags ='���������������������������������������������������������' order by d1 desc LIMIT 0 , 10
Please report this error to
You searched for: Tag: ���������������������������������������������������������
No journals.
Matches: 5