PDA

View Full Version : Small DB Problem...


globalwin
06-08-2002, 12:39 AM
Invalid SQL: UPDATE user
SET styleid='1',adminemail='1',
showemail='1',invisible='0',cookieuser='1',
maxposts='-1',daysprune='-1',
timezoneoffset='0',emailnotification='1',
startofweek='2',options='15',receivepm='1',
emailonpm='1',pmpopup='1',pmpopupfull='0',usergrou pid='6',
nosessionhash='1',hideposts='0'
WHERE userid='1'
mysql error: Unknown column 'pmpopupfull' in 'field list'

mysql error number: 1054

I installed the pop up message on full inbox hack and I get this when I try to enable the setting for it in my user profile. :surprised:

globalwin
06-08-2002, 12:45 AM
silly me, needed to do this:

ALTER TABLE user ADD pmpopupfull SMALLINT(6) DEFAULT '0' NOT NULL AFTER pmpopup

:(