I'm getting a pretty big SQL error upon upgrading.
I've disabled ALL plugins EXCEPT for the Blog plug-in, yet, I'm still not able to get to the Blog page any more.
I added a standard style with no parent, and when I go to it, I'm not able to get to the Blog page. I've even edited includes\config.php and added
under
and I'm still not able to get to it under either the new style that I created or the standard style for our forums.
When I go to http://forums.xxxx.net/blog.php I get a page that tells me that there's been a DB error, but I don't get anything telling me what the DB error actually is.
When I go to my profile page, I get the following DB error that shows up.
I've disabled ALL plugins EXCEPT for the Blog plug-in, yet, I'm still not able to get to the Blog page any more.
I added a standard style with no parent, and when I go to it, I'm not able to get to the Blog page. I've even edited includes\config.php and added
Code:
define('DISABLE_HOOKS',true);
Code:
<?php
When I go to http://forums.xxxx.net/blog.php I get a page that tells me that there's been a DB error, but I don't get anything telling me what the DB error actually is.
When I go to my profile page, I get the following DB error that shows up.
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 <= 1235690735 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 @ 06:25:35 PM Error Date : Thursday, February 26th 2009 @ 06:25:35 PM Script : http://xxxxxxxxxxxxxxxxxx/member.php?action=getinfo&u=1641 Referrer : http://xxxxxxxxxxxxxx/profile.php?do=editoptions IP Address : xxxxxxxxxxxx Username : xxxxxxxx Classname : vB_Database MySQL Version : 5.0.51b-community-nt