Query Failed?

Found a bug? post about it here and your fix if you have one and we will review it and make them part of the official release.
Blacking
Posts: 5
Joined: 27 Dec 2013, 22:17

Query Failed?

Postby Blacking » 27 Dec 2013, 23:09

So I just started a new server and installed AMXBans properly and...

L 12/27/2013 - 1733: [amxbans_main.amxx] [AMXBans] Query failed!
L 12/27/2013 - 1733: [amxbans_main.amxx] [AMXBans] Threaded Query Error, Place: 3
L 12/27/2013 - 1733: [amxbans_main.amxx] [AMXBans] Message: 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 'artiste|Clan-->Furien normal<--Recrute', '77.111.246.147:27015', 'czero', '6.0.3' at line 1 (1064)

How do I fix it?
(I don't know if it is the tables, I've switched of admins to amx and amxbans, but neither of them work)

As far as I know the SQL is updated. I used on Multiplayer game, but then I used on a real server and it doesn't work

EDIT
WebServer Apache
PHP Version 5.2.17
AMXBans Version 6.0.4
SQL [http://www.freemysqlhosting.net/] Yes it's free, but I only need to click a link once a week, but it works fine. Remote

YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Query Failed?

Postby YamiKaitou » 29 Dec 2013, 14:54

What is your server name?

Blacking
Posts: 5
Joined: 27 Dec 2013, 22:17

Re: Query Failed?

Postby Blacking » 29 Dec 2013, 20:52

L'artiste|Clan-->Furien normal<--Recrute
Not mine, helping some dudes setting it up

(It has the verygames tag before that)

YamiKaitou
Amxbans Developer
Posts: 257
Joined: 17 Apr 2013, 14:09

Re: Query Failed?

Postby YamiKaitou » 30 Dec 2013, 14:11

It is caused by the single-quote in the hostname. Seems whoever coded this didn't escape the string before sending it to SQL. Bug Report #5 filed for tracking

Blacking
Posts: 5
Joined: 27 Dec 2013, 22:17

Re: Query Failed?

Postby Blacking » 30 Dec 2013, 15:47

So I just discovered a new bug? :)

Zapy
Site Admin
Posts: 121
Joined: 01 Apr 2013, 15:52

Re: Query Failed?

Postby Zapy » 30 Dec 2013, 19:59

apparently :P
Project Leader for Amxbans.net from 2013
Head Community admin for Warzone Short Valley
Swedish Gaming Community since 2000
www.warzone.nu


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 1 guest