Bug #1471

error in daemon

Added by Peterson 6 months ago. Updated 6 months ago.

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.

#3 Updated by Packhead 6 months ago

  • Status changed from New to Resolved

Resolved this in hlx-16:0f583a439ecd

Also available in: Atom PDF