Announcement

Collapse
No announcement yet.

Database error when changing usergroup

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

  • Database error when changing usergroup

    Hello,

    I tried to change to usergroup of a member in the Admin-CP and got following database error :

    Database error in vBulletin Control Panel 2.2.1:

    Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
    mysql error: You have an error in your SQL syntax near '' at line 1

    mysql error number: 1064

    Date: Sunday 07th of July 2002 11:02:31 PM
    Script: http://board.pc-helpnet.de/admin/user.php
    Referer : ...

    Does anyone have a clue ?

  • #2
    It looks like the same error that I was having with PHP 4.2.0. John has some patches out that fix them though.

    Run a PHPInfo on your server, if it's 4.2.0 then that is your problem.

    Comment


    • #3
      Thank you for your help. I will try the PHP 4.2 Update

      Comment

      Loading...
      Working...
      X