BUG - Problem with Serverlist (SQL Problem)

Welcome Guest ( Log In | Register )

[splatterladder] Board > --:: SplatterLadder ::-- > [splatterladder] - Support

Attention / Bitte beachten

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)

Options

Blackskyliner View Member Profile	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`)'

TomDome View Member Profile	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. -------------------- cheers Tom ...providing service for the sl since 2006. Dont forget, this site is about games, friends and fun. Keep it all nice and friendly.

Blackskyliner View Member Profile	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.POPULARITY100) 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

schnoog View Member Profile	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 :) --------------------

Blackskyliner View Member Profile	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.

« Next Oldest · [splatterladder] - Support · Next Newest »

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version

Time is now: 24th July 2024 - 04:18 PM

Licensed to: www.splatterladder.com