Bug #1471
error in daemon
| Status: | Resolved | Start date: | 11/09/2011 | |
|---|---|---|---|---|
| Priority: | High | Due date: | ||
| Assignee: | - | % Done: | 0% |
|
| Category: | Daemon | |||
| Target version: | - | |||
| Affected Version: | 1.6.15 | Blocking Target Version: | No |
Description
DBD::mysql::st execute failed: 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 ''10'' at line 12 at .//HLstats.
plib line 213.
Unable to execute query (get_top_players):
SELECT
?, lastName,
kills / IF(deaths=0,1,deaths) AS kpd
FROM
hlstats_Players
WHERE
game=?
AND hideranking = 0
AND kills >= 1
ORDER BY
? DESC, kpd DESC
LIMIT 0, ?
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 ''10'' at line 12 at .//HLstats.plib line 213.
<Patilus> [Nov 09 23:11:04 ] Peterson : I come to have the same problem : http://pastebin.com/raw.php?i=XKjQeicV
<@Peterson> [Nov 09 23:11:25 ] still with the new files?
<@Peterson> [Nov 09 23:12:11 ] are you sure you stopped the daemon and upload the FRESH script files?
<Patilus> [Nov 09 23:12:21 ] Yes, hummm but it's not the same problem
<@Peterson> [Nov 09 23:12:27 ] downloaded like no more than half an hour ago?
<@Peterson> [Nov 09 23:12:42 ] lolol
<@Peterson> [Nov 09 23:12:45 ] Packhead, fail
<@Peterson> [Nov 09 23:13:02 ] hlxce needs a lot more beta testers
<@Peterson> [Nov 09 23:13:06 ] with various installs
<Patilus> [Nov 09 23:13:49 ] It's the last yes, but now it a syntax error, before it was 4 vars and should have 3
<Patilus> [Nov 09 23:22:11 ] Ok, i find the problem .... $limit return '10' (with the '') and it should return 10
History
#2
Updated by snoopass 6 months ago
I installed the new files but i became the same error-Message :
DBD::mysql::st execute failed: called with 4 bind variables when 3 are needed at .//HLstats.plib line 213.
Unable to execute query (get_top_players):
SELECT
?, lastName,
kills / IF AS kpd
FROM
hlstats_Players
WHERE
game=?
AND hideranking = 0
AND kills >= 1
ORDER BY
DESC, kpd DESC
LIMIT 0, ?
called with 4 bind variables when 3 are needed at .//HLstats.plib line 213.
And we test ist, and the stats crashed when anyone type "top10" ingame.