No announcement yet.

strange sudden appearance of this database error:

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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...

    Database error in vBulletin 3.8.3:
    Invalid SQL:
    			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))
    			blogid IN (16)
    		 	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        :
    Referrer      :
    IP Address    :
    Username      : Bdiddy
    Classname     : vB_Database
    MySQL Version :
    Something to do with a moderation issue for a member without permissions or something??

  • #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.


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