Comments (9)
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'
from sourcebans.
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
from sourcebans.
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')
from sourcebans.
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 :)
from sourcebans.
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.
from sourcebans.
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
from sourcebans.
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).
from sourcebans.
👍
from sourcebans.
Fixed in #46.
from sourcebans.
Related Issues (20)
- Does sourcebans work on a linux server? HOT 4
- Wrong group assigned to servers
- Sourcebans and mysql admin HOT 2
- Insurgency Standalone support HOT 1
- "Login" button is broken.
- Won't add new bans to website - Getting this error!
- GetClientAuthId not implemented ! HOT 1
- Hackers can easy get always admin
- Sourcebans seems to work on server but not connect on website HOT 1
- Sourcebans doesn't show CTBans HOT 3
- Adding a search to view admins
- How to install the new version? HOT 2
- PHP7 Compatibility HOT 2
- Install Tutorial HOT 2
- nginx server block HOT 2
- date_default_timezone_set() error HOT 3
- Admin's aren't getting game server permissions
- Database HOT 1
- Fatal error HOT 2
- Ban Imports HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sourcebans.