Help - Search - Members - Calendar
Full Version: BUG - Problem with Serverlist (SQL Problem)
[splatterladder] Board > --:: SplatterLadder ::-- > [splatterladder] - Support
Blackskyliner
When I try to access the serverlist I get the following.

http://et.splatterladder.com/?mod=serverlist
QUELLTEXT
! SQL QUERY FAILED:
SELECT TSI.IDX, TSI.MESSAGES, TSI.PROTECTION, IF( LENGTH(TSI.MESSAGES) <1 AND TSI.RATINGMSG < 1, TRUE, FALSE ) AS ISRANKED , TSI.SPECRANK+TSI.MOJO AS MYSPECRANK ,TSI.NAME, TSI.RAWNAME, TSI.IP, UNIX_TIMESTAMP()-TSI.LASTRESPONSE, TSI.MODNAME, TSI.MODVERSION, TSI.GAMETYPE, TSI.GAMESTATUS, TSI.MAPTIMELEFT, TSI.GAMEID, TSI.PROTOCOL, TMI.IDX, TMI.MAPNAME ,TMI.CAPTION, TSI.STATUS, TSI.MAXSLOTS, TSI.CURRSLOTS, TSI.PRIVSLOTS, TSI.INVSLOTS, TSI.FLAGS, TSI.OS, TSI.COUNTRY, TSI.REGION, round(TSI.POPULARITY*100) AS POPULARITY, UNIX_TIMESTAMP()-TSI.LASTSCAN AS SCANLEFTTIME, STATUS="I" AS IGN FROM clq_server_info AS TSI, clq_map_info AS TMI WHERE TMI.MAPNAME=TSI.MAPNAME AND TMI.GAMEID=TSI.GAMEID AND TSI.ENABLED="yes" AND TSI.CURRSLOTS0 AND FIND_IN_SET("pb",FLAGS)>0 AND FIND_IN_SET("pw",FLAGS)=0 AND FIND_IN_SET("bt",FLAGS)>0 AND FIND_IN_SET("al",FLAGS)>0 AND FIND_IN_SET("bot",FLAGS)=0 AND TSI.REGION IN ("e") ORDER BY MYSPECRANK DESC, TSI.STATUS DESC, TSI.LASTRESPONSE DESC
BIGINT UNSIGNED value is out of range in '(`sl_et_corr`.`TSI`.`MAXSLOTS` - `sl_et_corr`.`TSI`.`PRIVSLOTS`)'
TomDome
Thanks for the Info. can you try it again? I dont get any errors.
Blackskyliner
Yep, the error is persistent I tried it few seconds ago:

QUELLTEXT
! SQL QUERY FAILED:
SELECT TSI.IDX, TSI.MESSAGES, TSI.PROTECTION, IF( LENGTH(TSI.MESSAGES) <1 AND TSI.RATINGMSG < 1, TRUE, FALSE ) AS ISRANKED , TSI.SPECRANK+TSI.MOJO AS MYSPECRANK ,TSI.NAME, TSI.RAWNAME, TSI.IP, UNIX_TIMESTAMP()-TSI.LASTRESPONSE, TSI.MODNAME, TSI.MODVERSION, TSI.GAMETYPE, TSI.GAMESTATUS, TSI.MAPTIMELEFT, TSI.GAMEID, TSI.PROTOCOL, TMI.IDX, TMI.MAPNAME ,TMI.CAPTION, TSI.STATUS, TSI.MAXSLOTS, TSI.CURRSLOTS, TSI.PRIVSLOTS, TSI.INVSLOTS, TSI.FLAGS, TSI.OS, TSI.COUNTRY, TSI.REGION, round(TSI.POPULARITY*100) AS POPULARITY, UNIX_TIMESTAMP()-TSI.LASTSCAN AS SCANLEFTTIME, STATUS="I" AS IGN FROM clq_server_info AS TSI, clq_map_info AS TMI WHERE TMI.MAPNAME=TSI.MAPNAME AND TMI.GAMEID=TSI.GAMEID AND TSI.ENABLED="yes" AND TSI.CURRSLOTS0 AND FIND_IN_SET("pb",FLAGS)>0 AND FIND_IN_SET("pw",FLAGS)=0 AND FIND_IN_SET("bt",FLAGS)>0 AND FIND_IN_SET("al",FLAGS)>0 AND FIND_IN_SET("bot",FLAGS)=0 AND TSI.REGION IN ("e") ORDER BY MYSPECRANK DESC, TSI.STATUS DESC, TSI.LASTRESPONSE DESC
BIGINT UNSIGNED value is out of range in '(`sl_et_corr`.`TSI`.`MAXSLOTS` - `sl_et_corr`.`TSI`.`PRIVSLOTS`)'


Sorry for the late reply, I had no time for PC matters through easter ;)
schnoog
Thanks for reporting this issue.
The error "only" occoured whit a special filter combination set.
Should be fixed. Can you confirm this?
Thx :)
Blackskyliner
Yep, it's fixed now. Thanks.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2017 Invision Power Services, Inc.