The Arcive of vBulletin Modifications Site.

Modify member record failure :( · **Released**: 08-28-2002

Suddenly, when I try to change a member password, or change an avatar, the get the following:

Quote:

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/adm...t&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 · #2 08-28-2002, 03:25 PM

Update: I can modify my OWN record, but no one else's.
Apache was upgraded this morning, if that matters?

Logician · #3 08-29-2002, 06: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..