AMXBans Search Page Problem.

[cristopherx2019]

Hello,

In page, /amxbans/search.php. I'm facing an error preventing me from opening the page.

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 'T0x' GROUP BY `steamid`' at line 1

→ Information ←
[Web-server: CENTOS 7.6]
[PHP Version: 5.6.40]
[MySQL Version: 5.6.44]
[AMXBans Version: 6.13]
↑↑↑

Please help me to fix this problem because it's necessary function.

Best regards, Thanks a lot

[indianiso1]

Hi!

Sorry for the late reply.

1. What does that error says more?
2. Which file & line?
3. Is it on opening search or when you try to search exactly something?
4. Are you logged in as admin?
5. Do you use clean AMXBans version or some modification?

Greetings,
indianiso1

[cristopherx2019]

Hi!

Sorry for the late reply.

1. What does that error says more?
2. Which file & line?
3. Is it on opening search or when you try to search exactly something?
4. Are you logged in as admin?
5. Do you use clean AMXBans version or some modification?

Greetings,
indianiso1

Hello,
No problems about late reply.
•1 The error says only "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 'T0x' GROUP BY `steamid`' at line 1".
•2 File: search.php & I don't know which line.
•3 It's on opening search.
•4 Yeah, I'm logged as admin & also as guest does not works.
•5 Yeah, I'm using clean AMXBans version without some modifications.
I hope you would be able to help me in fixing this problem.
Best regards,
Thanks a lot.

[indianiso1]

Does your admin (that ...T0x) has any specific character before "T"? I just can't seem to find what could be the problem then. Maybe it has " or ' (or any other) which program could skip and break site.

[cristopherx2019]

Does your admin (that ...T0x) has any specific character before "T"? I just can't seem to find what could be the problem then. Maybe it has " or ' (or any other) which program could skip and break site.

Hello,
Yeah, There is admin his name includes ' symbol. That's why this problem happened.
Obviously, " or ' symbols is not supported in AMXBans (Admins), In this case you need to add support for those symbols.
By the way, I removed the admin which his name includes ' symbol from amx_bans table in database, Then the problem is Fixed!
Means, If any admin used in his name " or ' symbols, This problem will happen again..!
This problem is related to AMXBans side, Requires a definitive solution.
Lastly, Thanks a lot.
Best regards.

[indianiso1]

Hi,

Thank you for your feedback! We will be looking forward to manage this bug.

Greetings,
indianiso1