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

SourceBans sql error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
markg
Senior Member
Join Date: Jan 2009
Old 07-02-2013 , 09:06   SourceBans sql error
Reply With Quote #1

i edited a description for a ban, making it longer, and after i saved it started getting this error ONLY on the ban list tab.

i then tried re editing the ban description, cutting it back down in length, same error
i then deleted that ban, same error

it happens whether or not im logged in

any ideas? or is the timing just a coincidence and there is a problem with the host

im using 1.4.10

thanks



---------------------------------------------------------------------

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,7' 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,7' AND (length = 0 OR ends > UNIX_TIMESTAMP()) AND RemovedBy IS NULL AND type = '0';
SQL Params:

Last edited by markg; 07-02-2013 at 09:09.
markg is offline
Rytis
Veteran Member
Join Date: Feb 2012
Location: Germany
Old 07-02-2013 , 09:11   Re: SourceBans sql error
Reply With Quote #2

There's somewhere a wrong SteamID. Just search in your ban list and delete the ban
Rytis is offline
markg
Senior Member
Join Date: Jan 2009
Old 07-02-2013 , 09:27   Re: SourceBans sql error
Reply With Quote #3

Quote:
Originally Posted by Rytis View Post
There's somewhere a wrong SteamID. Just search in your ban list and delete the ban
thanks

There are 2438 bans, any idea how to find the wrong one?

[edit] I just started scrolling through the 82 pages. most do not have that error, a few do. I guess I can just delete the bans on the bad pages.

Last edited by markg; 07-02-2013 at 09:34.
markg is offline
Rytis
Veteran Member
Join Date: Feb 2012
Location: Germany
Old 07-02-2013 , 09:42   Re: SourceBans sql error
Reply With Quote #4

Just search the SteamID "WHERE", partial
Rytis is offline
markg
Senior Member
Join Date: Jan 2009
Old 07-02-2013 , 12:02   Re: SourceBans sql error
Reply With Quote #5

Quote:
Originally Posted by Rytis View Post
Just search the SteamID "WHERE", partial
thanks!
markg 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 08:21.


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