Raised This Month: $51 Target: $400
 12% 

Error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
maxolahird
Veteran Member
Join Date: Dec 2012
Old 05-03-2013 , 16:31   Error
Reply With Quote #1

well for some reason after I removed a player ban I'm getting this in the banlist

Code:
Debug 
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 ') AS srv_group, srv_flags,2' AND (length = 0 OR ends > UNIX_TIMESTAMP()) AND Rem' at line 1

SQL Query type: EXECUTE
Script: '/index.php'
SQL Query: SELECT count(bid) as count FROM `sb_bans` WHERE authid = 'WHERE name = srv_group AND flags != ') AS srv_group, srv_flags,2' AND (length = 0 OR ends > UNIX_TIMESTAMP()) AND RemovedBy IS NULL AND type = '0';
SQL Params:

Last edited by DJ Tsunami; 05-15-2013 at 08:02.
maxolahird is offline
ecca
Sexy Santa
Join Date: Jan 2011
Old 05-08-2013 , 20:43   Re: Error
Reply With Quote #2

I'm not sure this is the same error. But search for a ban with a wierd steamid or name that can cause anything with ' todo.
__________________
ecca is offline
DoPe^
Veteran Member
Join Date: Jul 2008
Location: Denmark / Copenhagen
Old 05-09-2013 , 04:35   Re: Error
Reply With Quote #3

Quote:
Originally Posted by ecca View Post
I'm not sure this is the same error. But search for a ban with a wierd steamid or name that can cause anything with ' todo.
ye it is that one, he could also search after anything wrote in the query, like "AS srv_group".
But im also still getting this, even tho I got smac_validate_auth turned on.
DoPe^ is offline
Dravu
Senior Member
Join Date: May 2010
Old 05-09-2013 , 11:20   Re: Error
Reply With Quote #4

Whenever I get those bans, it's because the player is banned before their steam id is authorized.
Dravu is offline
ecca
Sexy Santa
Join Date: Jan 2011
Old 05-09-2013 , 11:56   Re: Error
Reply With Quote #5

I think they updated sourcemod 1.5.0 to validate steamids better. So try upgrade if you haven't.
__________________
ecca is offline
maxolahird
Veteran Member
Join Date: Dec 2012
Old 05-09-2013 , 16:05   Re: Error
Reply With Quote #6

well it aparently got fixed automagically
maxolahird is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:26.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode