John
John
Offline
0
Hi there,

I am running Joomla 3.3.6, and just downloaded/uploaded the B2J Contact which I have used on a previous website with great success,
but on the new site I am getting the following message:

Error
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM u4p7i_b2jcontact_details AS a LEFT JOIN `u4p7i_languages` AS l ON l.lang_code = a.language LEFT JOIN u4p7i_users AS uc ON uc.id=a.checked_out LEFT JOIN u4p7i_viewlevels AS ag ON ag.id = a.access WHERE (a.published = 0 OR a.published = 1) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.name, a.alias, a.checked_out, a.checked_out_time, a.user_id, a.published, a.access, a.created, a.created_by, a.ordering, a.featured, a.language, a.publish_up, a.publish_down,l.title AS language_title,uc.name AS editor,ag.title AS access_level FROM u4p7i_b2jcontact_details AS a LEFT JOIN `u4p7i_languages` AS l ON l.lang_code = a.language LEFT JOIN u4p7i_users AS uc ON uc.id=a.checked_out LEFT JOIN u4p7i_viewlevels AS ag ON ag.id = a.access WHERE (a.published = 0 OR a.published = 1) ORDER BY a.name asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*) FROM u4p7i_b2jcontact_details AS a LEFT JOIN `u4p7i_languages` AS l ON l.lang_code = a.language LEFT JOIN u4p7i_users AS uc ON uc.id=a.checked_out LEFT JOIN u4p7i_viewlevels AS ag ON ag.id = a.access WHERE (a.published = 0 OR a.published = 1)


Have you any idea why this is?
I have tried uninstalling, and re-installing twice..... but still get the same error message as above.

Would appreciate any advice,

Many thanks

John
Responses (1)
Your Reply