IPB

Welcome Guest ( Log In | Register )

> 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
 
Reply to this topicStart new topic
> BUG - Problem with Serverlist (SQL Problem)
Blackskyliner
post Apr 3 2015, 10:28 AM
Post #1


Group Icon 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`)'
Go to the top of the page
 
+Quote Post
TomDome
post Apr 3 2015, 10:53 AM
Post #2


Group Icon 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.



Go to the top of the page
 
+Quote Post
Blackskyliner
post Apr 6 2015, 01:24 PM
Post #3


Group Icon 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
Go to the top of the page
 
+Quote Post
schnoog
post Apr 6 2015, 03:41 PM
Post #4


Group Icon 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 :)


--------------------



Go to the top of the page
 
+Quote Post
Blackskyliner
post May 17 2015, 01:50 PM
Post #5


Group Icon Private 1st Class

Group: Members

Joined: 16-June 07
Member No.: 54269



Yep, it's fixed now. Thanks.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 21st November 2017 - 10:16 PM