strange sudden appearance of this database error:

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stardotstar
    Member
    • Feb 2007
    • 83

    strange sudden appearance of this database error:

    Can anyone fathom what is happening here - i have neither modified any of the blog options/code nor is is particularly heavily used...

    Code:
    Database error in vBulletin 3.8.3:
    
    Invalid SQL:
    
    		SELECT
    			blog.blogid, blog.userid, blog.state, blog.pending, blog.options AS blogoptions,
    			bu.memberids, bu.memberblogids,
    			user.membergroupids, user.usergroupid, user.infractiongroupids,
    			gm.permissions AS grouppermissions
    		FROM blog AS blog
    		LEFT JOIN blog_user AS bu ON (bu.bloguserid = blog.userid)
    		LEFT JOIN user AS user ON (user.userid = blog.userid)
    		LEFT JOIN blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 34541)
    		LEFT JOIN blog_categoryuser AS cu ON (cu.blogid = blog.blogid AND cu.blogcategoryid IN (2))
    		WHERE
    			blogid IN (16)
    		 		AND
    		 	blog.state IN ('moderation')
    		 	AND (cu.blogcategoryid IS NULL OR blog.userid = 34541);
    
    MySQL Error   : Column 'blogid' in where clause is ambiguous
    Error Number  : 1052
    Request Date  : Tuesday, July 14th 2009 @ 10:20:44 AM
    Error Date    : Tuesday, July 14th 2009 @ 10:20:45 AM
    Script        : [URL]http://www.archeli.com.au/forums/blog_inlinemod.php[/URL]
    Referrer      : [URL]http://www.archeli.com.au/forums/blog.php?u=34541&blogcategoryid=-1[/URL]
    IP Address    : 122.49.175.146
    Username      : Bdiddy
    Classname     : vB_Database
    MySQL Version :
    Something to do with a moderation issue for a member without permissions or something??
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    That error is usually from a modification that conflicts with the blog. Do you have any third-party add-ons installed?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...