| logic@ |
06-22-2016 12:43 PM |
Hello. MYSQL error when attempting to view people's profiles. Help me please.
Code:
Database error in vBulletin 4.2.3:
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 prxdbtech_usertag_mention AS mention
LEFT JOIN prxpost AS post ON (post.postid = mention.postid)
LEFT JOIN prxthread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN prxuser AS user ON (user.userid = mention.userid)
LEFT JOIN prxuser 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 prxdbtech_usertag_mention AS mention
LEFT JOIN prxblog_text AS blog_text ON (blog_text.blogtextid = mention.postid)
LEFT JOIN prxblog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN prxuser AS user ON (user.userid = mention.userid)
LEFT JOIN prxuser 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
Request Date : Wednesday, June 22nd 2016 @ 02:41:37 PM
Error Date : Wednesday, June 22nd 2016 @ 02:41:37 PM
Classname : vB_Database
MySQL Version : 5.5.50-cll
|
More Information