Announcement

Collapse
No announcement yet.

mysql problem

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

  • Floris
    replied
    The field shouts is still in the query, you have not uninstalled the hack 100%

    Leave a comment:


  • ihatethisclass
    started a topic mysql problem

    mysql problem

    I recently installed a hack that apparently turned into non functioning. Now, when I try to ban a user on my board...I'm getting these crazy MySQL errors, and I can't figure it out.

    Database error in vBulletin 3.0.3:

    Invalid SQL: UPDATE user SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    username = 'Mel',
    email = '[email protected]',
    languageid = '0',
    usertitle = 'Banned',
    customtitle = '0',
    homepage = '',
    icq = '',
    aim = 'Melipop111',
    yahoo = '',
    msn = '',
    parentemail = '[email protected]',
    posts = '463',
    shouts = '',
    ipaddress = '66.30.252.53',
    canhavejournal = '1',
    usergroupid = '8',
    shoutbanned = '0',
    reputation = '24',
    pmpopup = '0',
    autosubscribe = '-1',
    showvbcode = '1',
    styleid = '2',
    timezoneoffset = '-5',
    daysprune = '0',
    threadedmode = '0',
    referrerid = '0',
    joindate = '1094054400',
    lastvisit = '1129856220',
    lastactivity = '1129866960',
    lastpost = '1129865700',
    birthday = '11-01-1984',
    birthday_search = '1984-11-01',
    options = '3415',
    reputationlevelid = '5',
    membergroupids = '',
    displaygroupid = '0'
    WHERE userid=74
    mysql error: Unknown column 'shouts' in 'field list'

    mysql error number: 1054

    Date: Friday 21st of October 2005 12:02:20 AM
    Script: http://www.ifyourehappyandyouknowitc...mincp/user.php
    Referer: http://www.ifyourehappyandyouknowitc...edit&userid=74
    Username: XXXXXXXXXXXXXXX
    IP Address: XXXXXXXXXXXXXX


    sometimes it says mysql error: Unknown column 'shoutbanned' in 'field list'
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X