SQL Error on Upgrade from 1.0 to 2.0.l PL1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JDuc
    Senior Member
    • Dec 2006
    • 132
    • 3.6.x

    SQL Error on Upgrade from 1.0 to 2.0.l PL1

    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
    Code:
    define('DISABLE_HOOKS',true);
    under
    Code:
    <?php
    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.

    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
    Last edited by JDuc; Sun 1 Mar '09, 4:41am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...