PDA

View Full Version : I installed some hacks recently and now ...


girlzclan
11-07-2002, 07:54 AM
I'm getting errors int he admin control panel when I try to edit a users information ::


Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET birthday='1979-04-04',options='15',usergroupid='9',username='GirlzSt arLight',email='starlight@girlzclan.com',styleid=' 1',parentemail='',coppauser=0,homepage='http://www.starlightsdream.com',icq='81561064',aim='Girlz StarL1ght',yahoo='Girlz_StarLight',signature='
starlightsdream (http://www.starlightsdream.com) - anythingbutleet (http://www.anythingbutleet.com) - girlzclan (http://www.girlzclan.com)',adminemail=1,showemail=1,invis ible=0,usertitle='femme fatale',customtitle=0,joindate=UNIX_TIMESTAMP('200 2-10-22 01:46:32'),cookieuser=1,nosessionhash=0,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-11-07 04:01:26'),lastactivity=UNIX_TIMESTAMP('2002-11-07 04:50:16'),lastpost=UNIX_TIMESTAMP('2002-11-07 03:24:18'),posts='645',profileview='',,timezoneoff set='-5',emailnotification=0,receivepm='1',emailonpm='0' ,ipaddress='',award='1',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1') WHERE userid=1
mysql error: You have an error in your SQL syntax near 'timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='0' ,ipaddress=''' at line 1

mysql error number: 1064

Date: Thursday 07th of November 2002 04:50:21 AM
Script: http://www.girlzclan.com/forums/forums/admin/user.php
Referer: http://www.girlzclan.com/forums/admin/user.php?action=edit&userid=1


The hacks I installed were
Memberlist is in color
age in post bit
whos your buddy
Users last ten posts will be displayed in their user profile
Your profile, will show how many times it has been viewed..


I'm clueless as to what went wrong ..

Erwin
11-07-2002, 09:05 AM
Which hack did you install that involved hacking admin/user.php?

Try to look over that hack's instructions again and make sure you have followed it correctly.

Xenon
11-07-2002, 01:50 PM
look at the errormsg:

",profileview='',,timezoneoffset='-5',"

as you can see there is one , to much, remove one before timezoneoffset

girlzclan
11-08-2002, 12:09 AM
omg I love you :) thank you soo much :) xox

Xenon
11-08-2002, 12:03 PM
you're welcome :)