Just installed vbblog and when I click on "post to your Blog" I get this error:
Database error in vBulletin 3.7.0 Beta 5:
Invalid SQL:
SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title
FROM vb_blog AS blog
LEFT JOIN vb_blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid)
LEFT JOIN vb_user AS user ON (blog_text.userid = user.userid)
WHERE blog.userid = 1
AND blog_text.blogtextid <> blog.firstblogtextid
AND blog_text.state IN ('visible','moderation','deleted')
AND blog.state IN ('visible','moderation')
AND blog.dateline <= 1203688965
AND blog.pending = 0
ORDER BY blog.lastcomment DESC
LIMIT 5;
MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Database error in vBulletin 3.7.0 Beta 5:
Invalid SQL:
SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title
FROM vb_blog AS blog
LEFT JOIN vb_blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid)
LEFT JOIN vb_user AS user ON (blog_text.userid = user.userid)
WHERE blog.userid = 1
AND blog_text.blogtextid <> blog.firstblogtextid
AND blog_text.state IN ('visible','moderation','deleted')
AND blog.state IN ('visible','moderation')
AND blog.dateline <= 1203688965
AND blog.pending = 0
ORDER BY blog.lastcomment DESC
LIMIT 5;
MySQL Error : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'if'
Error Number : 1267
Comment