PDA

View Full Version : Modify member record failure :(


Okiewan
08-28-2002, 03:50 PM
Suddenly, when I try to change a member password, or change an avatar, the get the following:


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: Wednesday 28th of August 2002 12:38:53 PM
Script: http://www.dirtrider.net/forums3/forums3/admin/user.php
Referer: http://www.dirtrider.net/forums3/admin/user.php?s=&action=edit&userid=29192


This just started happening out of the blue, the last hack I installed was the "flags" hack a couple of days ago. Any suggestions would be MUCH appreciated.

Okiewan
08-28-2002, 04:25 PM
Update: I can modify my OWN record, but no one else's.
Apache was upgraded this morning, if that matters?

Logician
08-29-2002, 07:23 AM
probably PHP is also upgraded and that's your problem. Latest version of the PHP causes problems with vb ver. <2.2.6 so you need to upgrade your board to at least ver. 2.2.6

There is also a fix in vb.com but I couldnt make it work and IMO your best bet is to upgrade your board..