PDA

View Full Version : mysql error number : 1054 , I really NeEd Help


NAIF
06-30-2003, 03:41 AM
Hello ,
since i upgraded my bB forum from vB 2.2.8 to vB2.3.0, i have faced a problem that when i user lose a password and tries to use the lost apssword action, after he insert his email he gets a database error mesage( error is attached) ...I wish you can help me solve this problem>

--------------------------------------------------
Database error in vBulletin 2.3.0:

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 53941377, 1056947111, '97957961', 1, 80)

mysql error: Unknown column 'usergroupid' in 'field list'

mysql error number: 1054

Date: Monday 30th of June 2003 07:25:11 AM
Script: http://www.abdu.net/vb/vb/member.php
Referer: http://www.abdu.net/vb/member.php?action=lostpw
-----------------------------------------

thank you

Cloudrunner
06-30-2003, 03:49 AM
Well, it looks as tho during your upgrade you lost the column 'usergroupid' in the table 'useractivation'.

double check for this column in the useractivation table, if it's not there then run this query:

ALTER TABLE `useractivation` ADD `usergroupid` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;

NAIF
06-30-2003, 12:47 PM
thank you very very much Cloudrunner
It's Ok now :) It's working ,,

NAIF :)

lasto
09-06-2003, 09:50 PM
i just had this as well

i ran the fix above said sql query ran ok so hopes thats end of matter :)

Invalid SQL:
INSERT INTO useractivation
(useractivationid, userid, dateline, activationid, type, usergroupid)
VALUES
(NULL, 75, 1062886818, '20948814', 1, 10)

mysql error: Unknown column 'usergroupid' in 'field list'

mysql error number: 1054

mariannet
10-15-2003, 07:43 AM
Here we go again!

Having installed a user rating hack I have come across this problem:

*************************************

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE user SET birthday='1990-10-29',options='15',usergroupid='8',username='xxxx',e mail='xxxx@xxxx.dk',styleid='8',parentemail='',cop pauser=0,homepage='http://www.xxxx.tk',icq='',aim='',yahoo='',signature='Tje ck>>>> www.xxxx.tk (www.xxx.tk)

Get hvem der har f?s?dag d 29. oktober...
x055

Msn: xxxx@ofir.dk',adminemail=1,showemail=1,invisible=0 ,usertitle='Lovely girl...',customtitle=2,joindate=UNIX_TIMESTAMP('20 03-04-24 19:19:55'),cookieuser=1,nosessionhash=1,daysprune= '1000',lastvisit=UNIX_TIMESTAMP('2003-10-14 20:48:26'),lastactivity=UNIX_TIMESTAMP('2003-10-14 22:25:58'),lastpost=UNIX_TIMESTAMP('2003-10-14 22:16:42'),userrating='',posts='1293',timezoneoffs et='+1',emailnotification=0,receivepm='1',emailonp m='0',ipaddress='80.62.119.214',pmpopup=IF(pmpopup =2 AND 1=1,pmpopup,'1') WHERE userid=358
mysql error: Unknown column 'userrating' in 'field list'

mysql error number: 1054

*************************************

I have a feeling where the problem is.

When I add a new user the field "User Rating" is present on the form, just under "Parent email address". I can add ok.

If I want to change the detailes of someone who is already a member, the field "User Rating" is NOT present on the form and when saving I get the error.

I don't really think that the problem is in mySQL, rather somewhere in the admin files, I just don't know where to start looking?