[KGodel]

I am still getting a MYSQL error when attempting to view people's profiles.

Database error in vBulletin 4.2.2:

Invalid SQL:

(

SELECT
post.pagetext AS message,
post.title AS posttitle,
post.visible AS postvisible,
thread.title AS threadtitle,
thread.visible,
thread.forumid,
mention.dateline,
mention.postid,
mention.type,
user.userid,
user.username,
user.usergroupid,
user.infractiongroupid,
user.displaygroupid,
mentioned.userid AS mentioneduserid,
mentioned.username AS mentionedusername,
mentioned.usergroupid AS mentionedusergroupid,
mentioned.infractiongroupid AS mentionedinfractiongroupid,
mentioned.displaygroupid AS mentioneddisplaygroupid

FROM table_dbtech_usertag_mention AS mention
LEFT JOIN table_post AS post ON (post.postid = mention.postid)
LEFT JOIN table_thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN table_user AS user ON (user.userid = mention.userid)
LEFT JOIN table_user AS mentioned ON (mentioned.userid = mention.mentionedid)
WHERE (mention.mentionedid = 1 OR mention.userid = 1)
AND mention.type = 'post'
ORDER BY dateline DESC
LIMIT 0, 20
) UNION ALL (
SELECT
blog_text.pagetext AS message,
blog_text.title AS posttitle,
IF(blog_text.state = 'visible', 1, 0) AS postvisible,
blog.title AS threadtitle,
IF(blog.state = 'visible', 1, 0) AS visible,
0 AS forumid,
mention.dateline,
mention.postid,
mention.type,
user.userid,
user.username,
user.usergroupid,
user.infractiongroupid,
user.displaygroupid,
mentioned.userid AS mentioneduserid,
mentioned.username AS mentionedusername,
mentioned.usergroupid AS mentionedusergroupid,
mentioned.infractiongroupid AS mentionedinfractiongroupid,
mentioned.displaygroupid AS mentioneddisplaygroupid

FROM table_dbtech_usertag_mention AS mention
LEFT JOIN table_blog_text AS blog_text ON (blog_text.blogtextid = mention.postid)
LEFT JOIN table_blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN table_user AS user ON (user.userid = mention.userid)
LEFT JOIN table_user AS mentioned ON (mentioned.userid = mention.mentionedid)
WHERE (mention.mentionedid = 1 OR mention.userid = 1)
AND mention.type = 'blog'
ORDER BY dateline DESC
LIMIT 0, 20

)
ORDER BY dateline DESC;

MySQL Error : Illegal mix of collations for operation 'UNION'
Error Number : 1271
MySQL Version : 5.5.32-cll-lve