No announcement yet.

member profile db error

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


    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       :
    Referrer     :
    IP Address   :
    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
    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.


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

      it was this modification >
      Last edited by mknjhill; Thu 28th May '09, 11:19am.
      MKNJHILL | cPanel Hosting


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