Database errors

[Boettiger]

Upgraded to Beta 5 this morning. Can someone tell me what this error message means? I went out of the office for a few hours and came home and found three of these in my email box. ??

thanks

Adam Boettiger

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,last activity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,showsignatures,b irthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash) VALUES (NULL,'testje','testje','[email protected]','1','','0','http://','','','','','1','0','0','Junior Member','986935462','1','45','986935462','986935462','3','0','0','1','0','1','0','40','1', '24.132.81.219','1','0','1')
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054
Date: Tuesday 10th of April 2001 01:44:22 PM
Script: /boards/register.php
Referer: http://www.i-advertising.com/boards/register.php

[John]

Make sure that you have uploaded the latest register.php file from the ZIP - it looks like you are still using the old one from beta 3/4.

John

[datman99]

another victum

Glad to know it's not just me...I'll monitor this thread.
Datman

[Boettiger]

Hi John,

Thanks for your help. I have verified that I am using the Beta 5 version of register.php and I am still getting the following error message.

<snip>
Database error in vBulletin: Invalid SQL: UPDATE user
SET styleid='1',adminemail='1',
showemail='1',invisible='0',cookieuser='1',
maxposts='-1',daysprune='-1',
timezoneoffset='0',emailnotification='0',
startofweek='1',showsignatures='0',receivepm='0',
emailonpm='0',pmpopup='0',usergroupid='6',
nosessionhash='0'
WHERE userid='1'
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054
Date: Tuesday 10th of April 2001 05:28:07 PM
Script: /boards/member.php?invisible=no&cookieuser=yes&nosessionhash=no&allowmail=yes&showemail=yes&emailn otification=no&receivepm=no&emailonpm=no&pmpopup=no&showsignatures=no&prunedays=-1&umaxposts=-1&startofweek=1&timezoneoffset=0&newstyleset=1&modifyavatar=Change+Avatar&action=updateopt ions
Referer: http://www.i-advertising.com/boards/...on=editoptions
</snip>

I can tell you what I was doing when it occurred. Most likely you can tell from the message, but I clicked on Profile, then Edit Options and was attempting to change or add an icon to my profile. Any time I click add icon or try to save modifications to the profile I get a database error message.

Anything else you want me to try? My board is at http://www.i-advertising.com/boards/index.php

Adam Boettiger

[Freddie Bingham]

You can verify if you are using the correct register.php if it only contains a reference to showsignatures 1 time.

[Mike Sullivan]

Sounds like your forgot to upload some of the files -- I suggest you reupload all the PHP files (except for config.php of course )