Announcement

Collapse
No announcement yet.

member profile db error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • member profile db error

    when i click on MOST of my usernames i get a db error, my username however doesnt have that problem.

    problem: http://www.web-hosting-talk.org/member.php?u=733

    Code:
    Database error in vBulletin 3.6.8:
    
    Invalid SQL:
    SELECT `avatar`.`avatarpath`,`customavatar`.*,`customprofilepic`.*,`user`.*,`usertextfield`.`buddylist` FROM `mst_user` AS `user` LEFT OUTER JOIN `mst_usertextfield` AS `usertextfield` ON (`usertextfield`.`userid` = `user`.`userid`) LEFT OUTER JOIN `mst_avatar` AS `avatar` ON (`avatar`.`avatarid` = `user`.`avatarid`) LEFT OUTER JOIN `mst_customavatar` AS `customavatar` ON (`customavatar`.`userid` = `user`.`userid`) LEFT OUTER JOIN `mst_customprofilepic` AS `customprofilepic` ON (`customprofilepic`.`userid` = `user`.`userid`) WHERE `user`.`userid` IN (mknjhill) ORDER BY `user`.`username` ASC;
    
    MySQL Error  : Unknown column 'mknjhill' in 'where clause'
    Error Number : 1054
    Date         : Thursday, May 28th 2009 @ 10:56:13 AM
    Script       : http://www.web-hosting-talk.org/member.php?u=733
    Referrer     : http://www.web-hosting-talk.org/
    IP Address   : 216.67.27.120
    Username     : mknjhill
    Classname    : vB_Database
    any ideas?? i have like 100 mods installed, and am kinda freaking out i dont want to reinstall for a stupid member profile issue...
    MKNJHILL | cPanel Hosting

  • #2
    There is no 'mknhjill' field in the vB database. That query and error is from an add-on. I'm afraid you will have to try and find the add-on that is causing this and either fix or remove it. I suggestion asking for further help over at www.vbulletin.org.
    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


    • #3
      mknjhill is my username....
      edit: I started disabling mods to find out if they were causing it.

      it was this modification > http://www.vbulletin.org/forum/showthread.php?t=134181
      Last edited by mknjhill; Thu 28th May '09, 11:19am.
      MKNJHILL | cPanel Hosting

      Comment

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