PDA

View Full Version : database error


Roxie
06-06-2002, 06:22 PM
I get this error when I try to edit a members profile

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1969-12-31 19:00:00'),returndate='0000-00-00',awayreason='',birthday='1977-08-29'options='15',usergroupid='8',username='BabyGirl ',email='babyeskimo@hotmail.com',styleid='1',paren temail='',coppauser=0,homepage='http://members.blackplanet.com/1Babygirl2000/',icq='',aim='Babygirl1dst2000',yahoo='Babyeskimo' ,signature='',adminemail=1,showemail=1,invisible=0 ,usertitle='Co-Admin',customtitle=0,joindate=UNIX_TIMESTAMP('2002-05-20 10:28:15'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-06-06 12:57:05'),lastactivity=UNIX_TIMESTAMP('2002-06-06 13:58:45'),lastpost=UNIX_TIMESTAMP('2002-06-06 13:56:13'),posts='648',timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='0' ,ipaddress='67.104.144.141',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1') WHERE userid=6
mysql error: You have an error in your SQL syntax near 'options='15',usergroupid='8',username='BabyGirl', email='babyeskimo@hotmail.com',' at line 1

mysql error number: 1064

Date: Thursday 06th of June 2002 03:12:10 PM
Script: http://odb.dayum.net/admin/user.php
Referer: http://odb.dayum.net/admin/user.php?action=edit&userid=6


I have added a few hacks and I don't which one could have caused the error. :surprised:

Steve Machol
06-06-2002, 06:28 PM
This looks like the error that results from an incompatibility between vB and PHP 4.2.0/4.2.1. You can either upgrade to 2.2.6 (recommended) or apply the patches in the PHP 4.2.0 thread in the Announcements forum at vbulletin.com.

Roxie
06-06-2002, 06:35 PM
If I upgrade I will lose all my hacks?

Xenon
06-07-2002, 01:16 PM
birthday='1977-08-29'options='15'

the ' before options has to be a , i think :)