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

upgrade from 1.4.9 to 1.4.10 got me this


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Zapy
SourceMod Donor
Join Date: Oct 2004
Location: Stockholm, Sweden
Old 10-23-2012 , 17:26   upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #1

http://sbans.warzone.nu


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

Does anyone have any idea whats wrong?

__________________
Community Admin for Warzone.nu
http://www.warzone.nu
Swedish Gaming Community since 2000
Zapy is offline
Send a message via Skype™ to Zapy
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 10-23-2012 , 19:05   Re: upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #2

Did you upload all the files correctly?
__________________
Peace-Maker is offline
Zapy
SourceMod Donor
Join Date: Oct 2004
Location: Stockholm, Sweden
Old 10-24-2012 , 13:50   Re: upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #3

Quote:
Originally Posted by Peace-Maker View Post
Did you upload all the files correctly?
Yup, downloaded the zipfile on the server directly with ms remote desktop, unziped, and copy paste it over the old dir (took a backup first)

And ran the /upgrade script to update the database.
__________________
Community Admin for Warzone.nu
http://www.warzone.nu
Swedish Gaming Community since 2000
Zapy is offline
Send a message via Skype™ to Zapy
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 10-24-2012 , 15:42   Re: upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #4

That guys steamid is messed up. How did that ban get into the database?
__________________
Peace-Maker is offline
Zapy
SourceMod Donor
Join Date: Oct 2004
Location: Stockholm, Sweden
Old 10-24-2012 , 16:10   Re: upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #5

Quote:
Originally Posted by Peace-Maker View Post
That guys steamid is messed up. How did that ban get into the database?
lol i have no idea, must have happen with the upgrade or someone have found a loophole in the search function and tried a sql injection.

after removing it the site shows no errors.

thx for the find, didn't even have the thought that it could be that.

If Viper would like to have a look at the database you can PM me and ill send you a backup i have.
__________________
Community Admin for Warzone.nu
http://www.warzone.nu
Swedish Gaming Community since 2000

Last edited by Zapy; 10-24-2012 at 16:13.
Zapy is offline
Send a message via Skype™ to Zapy
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 10-24-2012 , 16:14   Re: upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #6

Quote:
Originally Posted by Zapy View Post
lol i have no idea, must have happen with the upgrade or someone have found a loophole in the search function and tried a sql injection.
I doubt it's some sql injection. It seems like it already happened in the plugin. Maybe the player wasn't authenticated while being banned or similar.
__________________
Peace-Maker is offline
Zapy
SourceMod Donor
Join Date: Oct 2004
Location: Stockholm, Sweden
Old 10-24-2012 , 16:15   Re: upgrade from 1.4.9 to 1.4.10 got me this
Reply With Quote #7

Quote:
Originally Posted by Peace-Maker View Post
I doubt it's some sql injection. It seems like it already happened in the plugin. Maybe the player wasn't authenticated while being banned or similar.
then it's a bug somewhere, cause that shouldn't happen.
__________________
Community Admin for Warzone.nu
http://www.warzone.nu
Swedish Gaming Community since 2000
Zapy is offline
Send a message via Skype™ to Zapy
Reply


Thread Tools
Display Modes

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 18:09.


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