[mariannet]

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

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?