This appears to be an issue beyond a compatibility issue with a plug-in I'm afraid.
I've disabled all plug-ins except for the Blog plug-in, I still get the error. I've added the code to config.php, I still get the error. I've created a new style and checked it using that style, I still get the error. I have not tried uploading the files again, but I'm not sure that would fix the problem considering the type of error I'm actually getting.
When I try to go to the Blog page, I get a page telling me that there's been a DB error, but nothing telling me exactly what the DB error is.
When I then go to my profile page, I get the following DB error:
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT
blog_text.username AS postusername, blog_text.ipaddress AS blogipaddress, blog_text.state, blog_text.blogtextid, blog_text.title, blog_text.dateline, blog_text.pagetext, blog_text.allowsmilie,
blog.userid AS blog_userid, blog.blogid, blog.title AS entrytitle, blog.state AS blog_state, blog.firstblogtextid, blog.options AS blogoptions, blog_user.memberids, blog_user.memberblogids, blog.postedby_userid, blog.postedby_username,
user2.usergroupid AS blog_usergroupid, user2.infractiongroupids AS blog_inractiongroupids, user2.membergroupids AS blog_membergroupids,
user.*,
blog_user.title AS blogtitle,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.infractiongroupid, options_ignore, options_buddy, options_member, options_guest, blog.userid AS blog_userid,
blog.state AS blog_state, blog.firstblogtextid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
, blog_read.readtime AS blogread, blog_userread.readtime AS bloguserread
FROM blog_text AS blog_text
LEFT JOIN blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN user AS user ON (user.userid = blog_text.userid)
LEFT JOIN user AS user2 ON (user2.userid = blog.userid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
LEFT JOIN blog_read AS blog_read ON (blog_read.blogid = blog.blogid AND blog_read.userid = 1641)
LEFT JOIN blog_userread AS blog_userread ON (blog_userread.bloguserid = blog.userid AND blog_userread.userid = 1641)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE blog.state IN('visible')
AND blog.dateline <= 1235692882
AND blog.pending = 0
AND blog_text.state IN('visible')
AND blog.firstblogtextid <> blog_text.blogtextid
AND blog_text.bloguserid = 1641
ORDER BY blog_text.dateline DESC
LIMIT 5;
MySQL Error : Unknown column 'blog_user.memberids' in 'field list'
Error Number : 1054
Request Date : Thursday, February 26th 2009 @ 07:01:22 PM
Error Date : Thursday, February 26th 2009 @ 07:01:22 PM
Script : http://xxxxxxx/member.php?action=getinfo&u=1641
Referrer : http://xxxxxxx/profile.php?do=editoptions
IP Address : xxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt