x
ETF2L is looking for new Staff to recruit! Are you interested in supporting the league? Then click here for more details on what we can offer and how to apply! 

Forum

SQL Error in the Playerslist

Created 17th May 2011 @ 12:26

Add A Reply Pages: 1

slate

(ETF2L Donator)
AMG

There is an SQL-Error when you filter the Player-List by country. (Other -> Players)

It does seem to work “a little bit” but it only shows the first page and breaks the pagination.

octochris

(0v0)

I can’t replicate that.

Spike Himself

TC

slate, could you perhaps make a screenshot of what you mean? I don’t see any problems.

Quoted from octochris

I can’t replicate that.

is anyone really surprised?


WordPress database 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 '.meta_value = 'Belarus'' at line 1]
SELECT count(*) FROM wp_lg_steamidsWHERE c.meta_value = 'Belarus'

considering the fact that etf2l use a horribly outdated WP version and rs-discuss (forum plugin) has no security at all, i highly doubt youll ever come around to fixing anything, but the bbcode XSS is still a go.

also: video section

Skyride

DUCS

Quoted from d1ck j0nes

SELECT count(*) FROM wp_lg_steamidsWHERE c.meta_value = 'Belarus'

Haha. Derp.

slate

(ETF2L Donator)
AMG

I was under the impression the error wasn’t on my end as I tried it on 2 different machines / Internet-Lines and my iPhone.

http://slate-tf2.de/fastdl/files/sql-error.png

SQL-error shows up after selecting a country.

http://etf2l.org/about/players/?country=Germany

Spike Himself

TC

derp, I sorted by country rather than filtered, hence I got no error..

Quoted from slate

I was under the impression the error wasn’t on my end

they never are, unless you’re hosting the server usd

Spike Himself

TC

DeNeusbeer gone huge again, this is now fixed :)

Thanks for reporting :)

Add A Reply Pages: 1