Comments (16)
If you give an admin ban flag, they cannot do perm bans without the unban flag. Other than that, it should be fine.
from sourcebans-pp.
And the second is that on css server everything works very well except that admins work only if i add them manualy to admins.cfg or sb_admins.cfg but it dosnt work when i add them from web interface, this problem persists only on css server, in csgo when i add from web interface it works fine.
I reveice this error everyday:
[sourcebans.smx] Failed to retrieve admins from the database, Subquery returns more than 1 row
the database.cfg is copied from csgo server to be sure everything is good but still i receive this error.
from sourcebans-pp.
So they need unban flag to have permanent ban acces, ok, is there a way to change the permanent ban from ''e'' flag to other for ex ''t'' or ''s'' ? Because i dont give unban acces but i want them to have permanent ban acces.
from sourcebans-pp.
Flags are set by SourceMod, not SourceBans
from sourcebans-pp.
Please download the latest sourcemod, and recompile the plugins with that version of sourcemod, and then also put the new version of sourcemod on the cs:s server.
from sourcebans-pp.
Since there was no reply, I am closing the issue.
from sourcebans-pp.
thank you very much for you answer, i will try and i will let you know.
i dont have much time thats why sometimes it can take a few days for me to reply, sorry for that :)
from sourcebans-pp.
I succesufuly compiled it but i still receive the same error which i dont receive on csgo server.
[sourcebans.smx] Failed to retrieve admins from the database, Subquery returns more than 1 row
Also is that posible that this release could make lag spikes? because players started to say that server lags when there are too many people (32/32) and this started after i updated sourcebans :(
from sourcebans-pp.
Sourcemod creates new threads for queries. If your server is multi-threaded then this plugin shouldn't be causing lag spikes, because the queries will execute on a processor core different from the game.
from sourcebans-pp.
before i was using 1.4.11 , maybe if i use 1.5.2 it will be better? btw i compiled sb with newest sm and uploaded sb and sm to server and i still receive this :(
[sourcebans.smx] Failed to retrieve admins from the database, Subquery returns more than 1 row
from sourcebans-pp.
You should be using 1.5.3 here.
https://github.com/Sarabveer/SourceBans-Fork/releases
from sourcebans-pp.
yes, this is the one that im using since a week, and the coincidence is that server started to lag after updating, but im not sure yet if it is because of sourcebans, ill test tomorrow and i will let you know :)
but im still stuck at the other problem - [sourcebans.smx] Failed to retrieve admins from the database, Subquery returns more than 1 row , can you please help me? thank you in advance :)
from sourcebans-pp.
Is your server multi-threaded and does it have access to more than one processor core?
from sourcebans-pp.
I will ask the host and i will be back with an answer :)
from sourcebans-pp.
he said yes
from sourcebans-pp.
That error means you have multiple admins registered with the same Steam ID.
from sourcebans-pp.
Related Issues (20)
- Not able to login in... HOT 10
- Too many bans and gags - on player connected join lag HOT 1
- Invalid SteamID input! - /includes/SteamID/SteamID.php on line 108 HOT 2
- Web-panel admin login issue after upgrading from SBPP 1.6.4 to 1.7.0 HOT 2
- i can't add admin
- JWT secret outside <?php> HOT 1
- Sidepanel menu buttons don't work after 1.7 update HOT 2
- Bad SteamID Format in DB can broke comms page HOT 1
- Comms not working from in-game HOT 1
- Most recent ban list does not show nick of some players HOT 5
- Sourcebans Ban list not showing anymore HOT 5
- Mute/Gag not applied in game when permanently muted/gaged on Sourceban database HOT 4
- Query_AddBlockInsert failed: Subquery returns more than 1 row
- [SourceSleuth] Duplicate account AUTO BAN HOT 5
- SourceBans ++ not working properly with connection to the server HOT 2
- [WebPanel] IPv6 issue
- Shorttags in the php code breaks on php 8.0+
- PHP Deprecated: Implicit conversion from float 4294966783 to int loses precision HOT 3
- HTTP ERROR 500 HOT 1
- Error connecting to server HOT 2
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-pp.