sl.Home | sl.Search | sl.Forum | sl.Settings | sl.Serverlist | sl.Maplist | sl.Team | sl.Wiki |
If you're asking for a clan-registritation, please provide us with following details: - clantag without color-codes - clantag with color-codes - link to your registered/reserved player nick or the player who should be assigned to this tag Rules: - only one clan per user (which means: no second squads, no second funclans, no second clans) - the registered/reserved playername has to be used at least 5 hours (5 hours playtime!) - the playername has to contain the clantag - the clantag has to contain 3 letters/numbers excluding spacebar » further information | Wenn ihr Hilfe bei der Registrierung eines neuen Clantags benötigt, brauchen wir unbedingt folgende Details: - Clantag ohne Farbcodes - Clantag mit Farbcodes - Link zu eurem registrierten/reservierten Spielernamen oder dem Spieler, der diesem Clan zugefügt werden soll. Regeln: - Nur ein Clan pro User (was bedeuted: keine zweiten Squads, keinen zweiten Funclan, keinen zweiten Clan!) - Der registrierte/reservierte Spielername muss bereits eine Spielzeit von mindestens 5 Stunden haben - Der Spielername muss den Clantag beinhalten - Der Clantag muss aus mindestens 3 Zeichen/Buchstaben ohne Leerzeichen bestehen » weitere Informationen |
BUG - Problem with Serverlist (SQL Problem) |
Apr 3 2015, 10:28 AM
Post
#1
|
|
Private 1st Class Group: Members Joined: 16-June 07 Member No.: 54269 |
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`)' |
|
|
Apr 3 2015, 10:53 AM
Post
#2
|
|
Tastenklimperer Group: Management Joined: 4-August 06 From: "Toscana of Germany" (Dreieck KA-LU-NW) Member No.: 31172 |
Thanks for the Info. can you try it again? I dont get any errors.
-------------------- |
|
|
Apr 6 2015, 01:24 PM
Post
#3
|
|
Private 1st Class Group: Members Joined: 16-June 07 Member No.: 54269 |
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 ;) This post has been edited by Blackskyliner: Apr 6 2015, 01:25 PM |
|
|
Apr 6 2015, 03:41 PM
Post
#4
|
|
Master of Desaster Group: Management Joined: 7-March 06 From: Wehr Member No.: 23716 |
Thanks for reporting this issue.
The error "only" occoured whit a special filter combination set. Should be fixed. Can you confirm this? Thx :) -------------------- |
|
|
May 17 2015, 01:50 PM
Post
#5
|
|
Private 1st Class Group: Members Joined: 16-June 07 Member No.: 54269 |
Yep, it's fixed now. Thanks.
|
|
|
Lo-Fi Version | Time is now: 26th September 2024 - 05:53 PM |