Announcement

Collapse
No announcement yet.

mysql error number: 1054

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

  • Marco van Herwaarden
    replied
    At the official Support Board we can only support onmodified files. That is why you will always get the advise here to upload all original files.

    Looking at the error it seems to me that you had installed a shoutbox hack, and then uninstalled the database changes, without undoing the file edits.

    If you need more support in fixing this problem, i suggest you ask in the support thread/forum for the shoutbox hack over at vbulletin.org.

    Leave a comment:


  • OrangeFlea
    started a topic mysql error number: 1054

    mysql error number: 1054

    Database error in vBulletin 3.0.3:

    Invalid SQL: UPDATE user SET

    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    username = 'xxxx',
    email = '[email protected]',
    languageid = '0',
    usertitle = 'xxxxxx',
    customtitle = '2',
    homepage = '',
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    parentemail = '[email protected]',
    posts = 'xxx',
    shouts = '',
    ipaddress = 'xxxx.xxxx.xxxx.xxx',
    canhavejournal = '1',
    usergroupid = '2',
    shoutbanned = '0',
    reputation = '10',
    pmpopup = '1',
    autosubscribe = '-1',
    showvbcode = '1',
    styleid = '3',
    timezoneoffset = '-5',
    daysprune = '0',
    threadedmode = '0',
    referrerid = '0',
    joindate = 'xxxxxxxxxxx',
    lastvisit = 'xxxxxxxxxxx',
    lastactivity = '1117689240',
    lastpost = 'xxxxxxxxxxxx',
    birthday = 'xxxxxxxxx',
    birthday_search = 'xxxxxxxxx',
    options = '2519',
    reputationlevelid = '0',
    membergroupids = '',
    displaygroupid = '0'
    WHERE userid=xxx
    mysql error: Unknown column 'shouts' in 'field list'

    mysql error number: 1054
    How do I rectify this problem? It happens whenever I try to change a user's avatar. Also, if support can't be provided due to the nature of the error, can someone then explain exactly which file specifically I need to reinstall? (I've done a search for similar problems, and support would normally say, "reinstall the original files." I'm hoping for something more specific than that)
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X