1267 - An error has occurred.

Hi there,

I have recently downloaded, and installed NinjaBoard onto my Joomla site 1.5.23
and all appeared to be ok with the install.

I then opened the Dashboard on the Admin and all again appeared ok.

I was able to see my users, and all other functions except "Forums"
when I click on Forums (via admin backend) the following message appears?

1267 - An error has occurred.

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull' of the following query : SELECT `tbl`.* , `first_post`.`subject` , `last_post`.`created_user_id` , `tbl`.`last_post_id` , `last_post`.`created_time` AS `last_post_date` , `last_post`.`ninjaboard_topic_id` AS `last_topic_id` , IF(`person`.`which_name` = LOWER('USERNAME'), `usr`.`username`, IF(`person`.`which_name` = LOWER('NAME'), `usr`.`name`, IF(`person`.`which_name` = LOWER('ALIAS') AND `person`.`alias` != '', `person`.`alias`, IFNULL(`usr`.`username`, IFNULL(`last_post`.`guest_name`, 'Anonymous'))))) AS `last_post_username` , IF(UNIX_TIMESTAMP(`topic`.`last_post_on`) > 1316242052, 1, 0) AS `new` , IF(`tbl`.`topics` = 0, 0, (SELECT COUNT(*) FROM `jos_ninjaboard_topics` AS `topics` WHERE `topics`.`forum_id` = `tbl`.`ninjaboard_forum_id`) - (SELECT COUNT(*) FROM `jos_ninjaboard_log_topic_reads` AS `reads` LEFT JOIN `jos_ninjaboard_topics` AS `tmp` ON (`tmp`.`ninjaboard_topic_id` = `reads`.`ninjaboard_topic_id`) WHERE `reads`.`ninjaboard_forum_id` = `tbl`.`ninjaboard_forum_id` AND `reads`.`created_by` = 62 AND `reads`.`created_on` >= `tmp`.`last_post_on`)) AS `unread` FROM `jos_ninjaboard_forums` AS `tbl` LEFT JOIN `jos_ninjaboard_posts` AS `last_post` ON (`last_post`.`ninjaboard_post_id` = `tbl`.`last_post_id`) LEFT JOIN `jos_ninjaboard_topics` AS `topic` ON (`last_post`.`ninjaboard_topic_id` = `topic`.`ninjaboard_topic_id`) LEFT JOIN `jos_ninjaboard_posts` AS `first_post` ON (`first_post`.`ninjaboard_post_id` = `topic`.`first_post_id`) LEFT JOIN `jos_users` AS `usr` ON (`usr`.`id` = `last_post`.`created_user_id`) LEFT JOIN `jos_ninjaboard_people` AS `person` ON (`person`.`ninjaboard_person_id` = `last_post`.`created_user_id`) ORDER BY `path_sort_ordering` asc LIMIT 0 , 20

Any advice on how to correct would be appreciated.

Many thanks,

John

I have a error of 1267 come up I have read how this problem was fixed granted I didn't understand where to find the places to fix it. I did some looking and found my joomla has database collation utf8_unicode_ci I checked on server the mysql connection collation is utf8_general_ci but mysql charset says UTF-8 Unicode (utf8) in the phpMyAdmin for the database my joomla is associated with I was able to find the tables (?) they all say utf8_unicode_ci . I understand everything should be the same for the 1267 error code to be fixed. If I change the ones that read utf8_unicode_ci to utf8_general_ci will that mess up my whole site? If I need to change the things the other way around how do I do that?

Hi Anne,

Just change the Joomla database from uft8_unicode_ci over to uft8_general_ci.
You should then find it all works ok :)

You can check/change the settings via your CPanel, look for the Database section then "phpMyAdmin".
Select the Joomla Database you want to change and make sure that they are all uft8_general_ci.
That is it done.

Regards,

John