AlliedModders - upgrade from 1.4.9 to 1.4.10 got me this

AlliedModders (https://forums.alliedmods.net/index.php)

- SourceBans / SourceBans++ (https://forums.alliedmods.net/forumdisplay.php?f=152)

- - upgrade from 1.4.9 to 1.4.10 got me this (https://forums.alliedmods.net/showthread.php?t=199054)

Zapy	10-23-2012 17:26

upgrade from 1.4.9 to 1.4.10 got me this

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?

Peace-Maker

10-23-2012 19:05

Re: upgrade from 1.4.9 to 1.4.10 got me this

Did you upload all the files correctly?

Zapy	10-24-2012 13:50

Re: upgrade from 1.4.9 to 1.4.10 got me this

Quote:

Originally Posted by Peace-Maker (Post 1824410)

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.

Peace-Maker

10-24-2012 15:42

Re: upgrade from 1.4.9 to 1.4.10 got me this

That guys steamid is messed up. How did that ban get into the database?

Zapy	10-24-2012 16:10

Re: upgrade from 1.4.9 to 1.4.10 got me this

Quote:

Originally Posted by Peace-Maker (Post 1824943)

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.

Peace-Maker

10-24-2012 16:14

Re: upgrade from 1.4.9 to 1.4.10 got me this

Quote:

Originally Posted by Zapy (Post 1824965)

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.

Zapy	10-24-2012 16:15

Re: upgrade from 1.4.9 to 1.4.10 got me this

Quote:

Originally Posted by Peace-Maker (Post 1824970)

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.

All times are GMT -4. The time now is 02:23.