PDA

View Full Version : Getting DB errors in CP after installing hacks!


FleaBag
06-24-2002, 03:26 PM
I've installed 37 hacks, and then I came to edit a user in my Admin CP, only to be greeted by the following database error. I have no idea what's wrong, is anyone able to help me? Thanks to all in advance. :)


Invalid SQL: UPDATE user SET
birthday='1987-05-21',options='15',usergroupid='2',username='Leo
182',email='leo182@nme.com',styleid='1',parentemai l='',coppauser=0,homepage='http://',icq='',aim='leom182',yahoo='',signature='I
like the hobo life, stabbing people with my hobo
knife.',adminemail=1,receivebulletin=0,receivebull etin_type=0,showemail=1,invisible=0,usertitle='Hob o',customtitle=2,joindate=UNIX_TIMESTAMP('1999-11-01
01:00:00'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-06-23
22:31:16'),lastactivity=UNIX_TIMESTAMP('2002-06-23
23:08:20'),lastpost=UNIX_TIMESTAMP('2002-06-23
23:08:00'),posts='1544',timezoneoffset='0',emailno tification=0,receivepm='1',emailonpm='0',ipaddress ='194.165.171.229',pmpopup=IF(pmpopup=2
AND 1=1,pmpopup,'1') WHERE userid=1206
mysql error: Unknown column 'receivebulletin' in 'field list'

mysql error number: 1054

Date: Sunday 23rd of June 2002 11:09:15 PM
Script: http://www.gamerforums.com/board/board/admin/user.php
Referer:
http://www.gamerforums.com/board/admin/user.php?s=&action=edit&userid=1206

Xenon
06-24-2002, 03:43 PM
perhaps you have forgotten to add the field recievebulletin in your usertable

FleaBag
06-24-2002, 04:45 PM
Duh, I'm stupid. I forgot to make the tables in my database when moving the hacked php files over from my test board. Thanks for pointing out the obvious. :D All working now. ;)