No announcement yet.

Changing User Group Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Changing User Group Error

    We are attempting to chage a users access from a Registered User to a Super Moderator. We got this error:

    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    This has never happened before and we have always been able to upgrade peoples access
    to help us run the board, until we upgraded to Release Candidate 1.

    Then I got an email that went with that error message, this is what it said:

    Database error in vBulletin Control Panel: Invalid SQL: UPDATE user SET birthday='1974-01-07',options='15',usergroupid='5',username='goose',password='muzzy1',email='[email protected]',styleid='1',parentemail='',coppauser=0,homepage='',icq='',aim='',yahoo='g0000se',signature='Goose
    ',adminemail=1,showemail=1,invisible=0,usertitle='Super Moderator',customtitle=,joindate=UNIX_TIMESTAMP('2001-03-26 15:44:55'),cookieuser=1,nosessionhash=1,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2001-04-23 07:56:31'),lastactivity=UNIX_TIMESTAMP('2001-04-23 08:45:06'),lastpost=UNIX_TIMESTAMP('2001-04-20 11:15:59'),posts='53',timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='1',ipaddress='',pmpopup=IF(pmp opup=2 AND 1=1,pmpopup,'1') WHERE userid=26
    mysql error: You have an error in your SQL syntax near 'joindate=UNIX_TIMESTAMP('2001-03-26 15:44:55'),cookieuser=1,nosessionhash=1,days' at line 1
    mysql error number: 1064
    Date: Monday 23rd of April 2001 08:55:01 AM
    Script: /forums/admin/user.php
    Any ideas?
    Last edited by Rishel; Mon 23rd Apr '01, 5:01am.