Announcement

Collapse
No announcement yet.

Database Error After Upgrade

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

  • Database Error After Upgrade

    I'm now getting the following database error when user tries to modify their profile. Does anyone have any ideas?

    Database error in vBulletin: Invalid SQL: UPDATE user
    SET styleid='',adminemail='1',
    showemail='1',invisible='1',cookieuser='1',
    maxposts='-1',daysprune='45',
    timezoneoffset='-5',emailnotification='0',
    startofweek='1',showsignatures='1',receivepm='1',
    emailonpm='1',pmpopup='1',usergroupid='6',
    nosessionhash='1'
    WHERE userid='5'
    mysql error: Unknown column 'showsignatures' in 'field list'
    mysql error number: 1054
    Date: Wednesday 09th of May 2001 10:05:35 PM
    Script: /forums/member.php?invisible=yes&cookieuser=yes&nosessionhash=yes&allowmail=yes&showemail=yes&emai lnotification=no&receivepm=yes&emailonpm=yes&pmpopup=yes&showsignatures=yes&prunedays=45&u maxposts=-1&startofweek=1&timezoneoffset=-5&vbcode=yes&action=updateoptions&Submit=Submit+Modifications
    Referer: http://www.corvetteactioncenter.com/...on=editoptions
    Rob

  • #2
    The showsignatures field was killed in beta (i think) 4... rename the field to 'options' and you should be okay.

    Comment


    • #3
      Thanks Kier,

      I was just about to delete this thread. I figured out what I did wrong. It's fixed.
      Rob

      Comment

      Loading...
      Working...
      X