Error #40 again...

[iraqiboy90]

Hello

I've been trying to install this but I always get:
[sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'where clause')

The fix which was supposed to be applied at 11.Jule isnt really applied everywhere.
The sourceban.sp file is for one isnt updated.

So here is what I did:
(While server is shutdown)

1. Installed/Configured the webpanel
2. Uploaded the Game folder to the server
3. Add the server on webpanel
   (now turning server on)
4. Looking at the logs: Failed to query database. (Unknown column 'ip' in 'where clause')
   (shutdown the server)
5. Delete all Game files on servers
6. Drop all DB
7. Remove all webpanel files.
8. Reupload the webpanel files
9. Modified the original sourceban.sp file, changing "ip" to "host", then upload the Game folder to the game server.
10. Install & config webpanel & add server
    (Turning server on)
11. Looking at the logs: Failed to query database. (Unknown column 'ip' in 'where clause')

So, what is missing?

[TaigaSama]

I have the same problem, tried the same things to but won't work..

console:
L 08/24/2014 - 14:59:44: [sourcebans.smx] Failed to query database. (Cannot add or update a child row: a foreign key constraint fails (sourcebans.sb_actions, CONSTRAINT action_server FOREIGN KEY (server_id) REFERENCES sb_servers (id) ON DELETE CASCADE))
80.161.12.58:27005: password failed.

logs:
[sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'where clause'

[JabLuszko]

You need to fix the plugin, restarting/rebooting/clearing won't help ;)
Yes, the sourceban.sp was never fixed at github.
What to fix was provided in previous ticket #40

After fixing host/ip in .sp you need to recompile plugin via spcomp (https://wiki.alliedmods.net/Compiling_SourceMod_Plugins). After compling you will get sourcemod._smx_ which need to be put into the plugins/ directory on server. For compiling you also need the include/sourcebans.inc in the same directory. It depends on this file.

If you trust random strangers over the Internet (LOL!) I've compiled it on my own: http://jabluszko.org/sourcebans.smx

[TaigaSama]

I put your plugin in and also tried it on my self. But it won't work. Now im getting this error:
L 08/25/2014 - 20:21:54: [sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'field list')

[JabLuszko]

Ah, you did not add a server via webpanel and in-game plugin is trying add new one. I didn't fix that part because I do not use that feature. Now it should be fixed, download file from the same URL and update :)

[iraqiboy90]

Regarding tables on DB, if sourmod uses its own prefix, and sourceban uses its own, then how would what I do on the webpanel being recognized by sourcemod?
This is regarding adding admins, bans, etc.

[TaigaSama]

Its LOL somehow it runs (if the server adds him auto. but then it shows "could not connect to server" on the webpanel but admin rights are working fine) created a new Thread for it. #59

[WildCard65]

The webpanel runs things on the server via rcon. It queries the server VIA a UDP Port that the server opens(I believe it uses the port number passed to -port, or default if not passed which is 27015). The rcon stuff is done via TCP as the webpanel needs a response and needs to know if it needs to resend the rcon stuff or if GS needs to resend response.
Another thing, if the server bans a client automatically(like SMAC), SB 2.0 catches that via the OnBanClient forward. Infact, the SB 2.0 plugin adds the DB stuff in that forward and uses the BanClient native to ban(which triggers the forward).

[iraqiboy90]

👍

[ErikMinekus]

Fixed in #46.