[Leica.Robbiani]

Hi there,

I get the following error when I call forumhome:

Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT
				entry.*,
				user.*
				,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
			FROM (
				(
	SELECT
		post.postid,
		post.title AS posttitle,
		thread.title AS threadtitle,
		thread.title AS title,
		thread.threadid,
		thread.forumid,
		entry_post.*
	FROM (SELECT * FROM vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'post' ORDER BY entryid DESC LIMIT 5) AS entry_post
	LEFT JOIN vbs420_post AS post ON (post.postid = entry_post.contentid)
	LEFT JOIN vbs420_thread AS thread ON (thread.threadid = post.threadid)
) UNION ALL (
		SELECT
			image.imageid AS postid,
			image.title AS posttitle,
			image.filename AS threadtitle,		
			image.userid,
			image_instance.shortname AS threadid,
			0 AS forumid,
			entry_dbgallery_image.*
		FROM (SELECT * FROM vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'dbgallery_image' ORDER BY entryid DESC LIMIT 5) AS entry_dbgallery_image
		LEFT JOIN vbs420_dbtech_gallery_images AS image ON (image.imageid = entry_dbgallery_image.contentid)
		LEFT JOIN vbs420_dbtech_gallery_instances AS image_instance ON (image_instance.instanceid = image.instanceid)		
	) UNION ALL (
		SELECT
			groupmessage.gmid AS postid,
			groupmessage.title AS posttitle,
			firstgroupmessage.title AS threadtitle,		
			groupmessage.postuserid AS userid,
			groupmessage.discussionid AS threadid,
			0 AS forumid,
			entry_socialgroup.*
		FROM (SELECT * FROM vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'socialgroup' ORDER BY entryid DESC LIMIT 5) AS entry_socialgroup
		LEFT JOIN vbs420_groupmessage AS groupmessage ON (groupmessage.gmid = entry_socialgroup.contentid)
		LEFT JOIN vbs420_discussion AS discussion ON (discussion.discussionid = groupmessage.discussionid)		
		LEFT JOIN vbs420_groupmessage AS firstgroupmessage ON (firstgroupmessage.gmid = discussion.firstpostid)		
	) UNION ALL (
		SELECT
			usernote.usernoteid AS postid,
			usernote.title AS posttitle,
			'N/A' AS threadtitle,		
			usernote.posterid AS userid,
			usernote.userid AS threadid,
			0 AS forumid,
			entry_usernote.*
		FROM (SELECT * FROM vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'usernote' ORDER BY entryid DESC LIMIT 5) AS entry_usernote
		LEFT JOIN vbs420_usernote AS usernote ON (usernote.usernoteid = entry_usernote.contentid)
	) UNION ALL (
		SELECT
			visitormessage.vmid AS postid,
			visitormessage.title AS posttitle,
			'N/A' AS threadtitle,		
			visitormessage.postuserid AS userid,
			visitormessage.userid AS threadid,
			0 AS forumid,
			entry_visitormessage.*
		FROM (SELECT * FROM vbs420_dbtech_thanks_entry WHERE varname IN('thanks', 'likes') AND contenttype = 'visitormessage' ORDER BY entryid DESC LIMIT 5) AS entry_visitormessage
		LEFT JOIN vbs420_visitormessage AS visitormessage ON (visitormessage.vmid = entry_visitormessage.contentid)
	)
			) AS entry
			LEFT JOIN vbs420_user AS user USING(userid)
			LEFT JOIN vbs420_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbs420_customavatar AS customavatar ON(customavatar.userid = user.userid)
			WHERE 1=1;

MySQL Error   : Illegal mix of collations for operation 'UNION'
Error Number  : 1271
Request Date  : Thursday, September 13th 2012 @ 05:09:12 PM
Error Date    : Thursday, September 13th 2012 @ 05:09:12 PM
Script        : http://localhost/vbs420/upload/forum.php
Referrer      : http://localhost/vbs420/upload/dbtgallery.php?do=view_image&id=3&gal=gallery
IP Address    : 127.0.0.1
Username      : XXX
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.16

Best regards

L.R.