Announcement

Collapse
No announcement yet.

Database/Script Error...Help?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database/Script Error...Help?

    I received the following database error message when I tried to move a new member from the "Users Awaiting Confirmation" group to "Registered":

    Database error in vBulletin Control Panel: Invalid SQL: UPDATE user SET birthday='0',options='15',usergroupid='2',username='[email protected]',email='[email protected] t',styleid='',parentemail='',coppauser=0,homepage='http://',icq='107235766',aim='',yahoo='',signature='',adminemail=1,showemail=1,invisible=0,userti tle='New Member',customtitle=0,joindate=UNIX_TIMESTAMP('2001-04-19 18:06:29'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2001-04-22 12:56:05'),lastactivity=UNIX_TIMESTAMP('2001-04-22 13:05:11'),lastpost=UNIX_TIMESTAMP('1969-12-31 19:00:00'),posts='0',timezoneoffset='-6',emailnotification=1,receivepm='1',emailonpm='0',ipaddress='204.42.31.3',pmpopup=IF(pmpo pup=2 AND =1,pmpopup,'') WHERE userid=720
    mysql error: You have an error in your SQL syntax near '=1,pmpopup,'') WHERE userid=720' at line 1
    mysql error number: 1064
    Date: Sunday 22nd of April 2001 01:08:32 PM
    Script: /forums/admin/user.php

    It appeard there is a keyword missing as seen by: pmpopup=IF(pmpopup=2 AND =1,pmpopup,'') WHERE

    Any ideas??
    Rob
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X