[KGodel]

After updating, I am getting the following error when I attempt to view anyone's profile:

MySQL Error : Illegal mix of collations for operation 'UNION'
Error Number : 1271

Here is the query

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 dbname_dbtech_usertag_mention AS mention
                                LEFT JOIN dbname_post AS post ON (post.postid = mention.postid)
                                LEFT JOIN dbname_thread AS thread ON (thread.threadid = post.threadid)
                                LEFT JOIN dbname_user AS user ON (user.userid = mention.userid)
                                LEFT JOIN dbname_user AS mentioned ON (mentioned.userid = mention.mentionedid)
                                WHERE mention.mentionedid = 3995 OR mention.userid = 3995
                                        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 dbname_dbtech_usertag_mention AS mention
                                        LEFT JOIN dbname_blog_text AS blog_text ON (blog_text.blogtextid = mention.postid)
                                        LEFT JOIN dbname_blog AS blog ON (blog.blogid = blog_text.blogid)
                                        LEFT JOIN dbname_user AS user ON (user.userid = mention.userid)
                                        LEFT JOIN dbname_user AS mentioned ON (mentioned.userid = mention.mentionedid)
                                        WHERE mention.mentionedid = 3995 OR mention.userid = 3995
                                                AND mention.type = 'blog'
                                        ORDER BY dateline DESC
                                        LIMIT 0, 20

                                )
                                ORDER BY dateline DESC;