WoltLab Community Forum

Source code

Fatal error: Invalid SQL: SELECT rankID FROM wcf1_user_rank WHERE groupID IN () AND neededPoints <= 375 AND gender IN (0,0) ORDER BY neededPoints DESC, gender DESC LIMIT 1

You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1064
Information:

error message: Invalid SQL: SELECT rankID FROM wcf1_user_rank WHERE groupID IN () AND neededPoints <= 375 AND gender IN (0,0) ORDER BY neededPoints DESC, gender DESC LIMIT 1
error code: 1064
sql type: MySQLDatabase
sql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND neededPoints <= 375 AND gender IN (0,0) ORDER BY neededPoint' at line 3
sql error number: 1064
sql version:
file: /home/www/forum/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.3
wcf version: 1.1.8 (Tempest)
date: Wed, 09 May 2012 17:47:41 +0000
request: /acp/index.php?action=UpdateUsers&limit=100&packageID=48&
referer: http://freie-spielgemeinschaft.de/acp/index.php?form=UpdateCounters
Stacktrace:

#0 /home/www/forum/wcf/lib/system/database/Database.class.php(118): MySQLDatabase->sendQuery('SELECT??rankID?...', 1, 0)
#1 /home/www/forum/wcf/lib/data/user/rank/UserRank.class.php(98): Database->getFirstRow('SELECT??rankID?...')
#2 /home/www/forum/lib/acp/action/UpdateUsersAction.class.php(161): UserRank::updateActivityPoints(0, '20')
#3 /home/www/forum/wcf/lib/action/AbstractAction.class.php(25): UpdateUsersAction->execute()
#4 /home/www/forum/wcf/lib/acp/action/WorkerAction.class.php(26): AbstractAction->__construct()
#5 /home/www/forum/lib/acp/action/UpdateCounterAction.class.php(23): WorkerAction->__construct()
#6 /home/www/forum/wcf/lib/util/RequestHandler.class.php(64): UpdateCounterAction->__construct()
#7 /home/www/forum/wcf/lib/util/RequestHandler.class.php(98): RequestHandler->__construct('UpdateUsers', Array, 'action')
#8 /home/www/forum/acp/index.php(8): RequestHandler::handle(Array)
#9 {main}