AMXBans Search Page Problem.

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.
cristopherx2019
Posts: 3
Joined: 13 Jun 2019, 19:22

AMXBans Search Page Problem.

Postby cristopherx2019 » 13 Jun 2019, 19:34

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 :D

User avatar
indianiso1
Posts: 130
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBans Search Page Problem.

Postby indianiso1 » 21 Jun 2019, 20:38

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
Posts: 3
Joined: 13 Jun 2019, 19:22

Re: AMXBans Search Page Problem.

Postby cristopherx2019 » 22 Jun 2019, 00:21

indianiso1 wrote: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. :D

User avatar
indianiso1
Posts: 130
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBans Search Page Problem.

Postby indianiso1 » 24 Jun 2019, 21:09

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
Posts: 3
Joined: 13 Jun 2019, 19:22

Re: AMXBans Search Page Problem.

Postby cristopherx2019 » 25 Jun 2019, 23:39

indianiso1 wrote: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.

User avatar
indianiso1
Posts: 130
Joined: 16 Oct 2015, 01:59
Contact:

Re: AMXBans Search Page Problem.

Postby indianiso1 » 26 Jun 2019, 07:30

Hi,

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

Greetings,
indianiso1


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 1 guest