[Phaiz]

Originally Posted by paiske For some reason the bans-page is not loading at all in version 1.5.2F but works just fine in 1.5.1F.. All other pages load just fine. For example, comms page shows all ~2000 blocks. I have tested this using updater and clean install. Same issue. The web-server configuration I have is nginx + php5-fpm + mariadb

https://forums.alliedmods.net/showpo...&postcount=344

Originally Posted by Sarabveer The banlist uses a new feature only available in MySQL 5.6. It fixes that lag that happens while loading the list with MySQL 5.6.x

You need to upgrade mysql, you most likely have 5.5.

[Sarabveer]

Originally Posted by Phaiz https://forums.alliedmods.net/showpo...&postcount=344 You need to upgrade mysql, you most likely have 5.5.

But If you have MySQL 5.5 or lower, it would not use the fix.

https://github.com/Sarabveer/SourceB...16e22e56e17f55

[Phaiz]

Originally Posted by Sarabveer But If you have MySQL 5.5 or lower, it would not use the fix. https://github.com/Sarabveer/SourceB...16e22e56e17f55

Unless he is using a version he downloaded before you updated it. Personally I didn't update my install afterwards, I just updated mysql.

[Sarabveer]

Originally Posted by Phaiz Unless he is using a version he downloaded before you updated it. Personally I didn't update my install afterwards, I just updated mysql.

He's using git192.

[paiske]

Hmm.. I updated sourcebans today but its still not working..
The database im using currently is:

mysql Ver 15.1 Distrib 10.0.16-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

There is no newer version available from packet manager. Also, the ban-page does not output any errors to mysql's error log or web server's error log.

[Sarabveer]

Originally Posted by paiske Hmm.. I updated sourcebans today but its still not working.. The database im using currently is: mysql Ver 15.1 Distrib 10.0.16-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 There is no newer version available from packet manager. Also, the ban-page does not output any errors to mysql's error log or web server's error log.

Try using MySQL without MariaDB.

[paiske]

That would be a system wide change. I quess I will just stick to the older version for now. Thanks anyway.

[Sarabveer]

Originally Posted by paiske That would be a system wide change. I quess I will just stick to the older version for now. Thanks anyway.

https://github.com/Sarabveer/SourceB...16e22e56e17f55

This commit is messing with you're DB, because it's asking for a MySQL version, and gets a MariaDB response. Install 1.5.2F-dev again, and remove that line from page.banlist.php

[bret]

I wonder if anyone's encountered this themselves.. If I ban someone from the web panel, it works fine, it bans them and when I unban them via the web panel they can rejoin again. If however, I ban someone from the ingame menu and then try to unban them from the web panel it doesn't unban them on the server. The strange thing here though, is that if I ban someone for 10 minutes ingame, unban via the web panel. They can rejoin again after around 5 minutes of the ban has been served (which makes me think there's a 5 minute timer, is ProcessQueueTime 5 the culprit?). Although! If I don't unban them via the web panel, after the same 5ish minute timeframe, the ban changes into a 10 hour ban? I've no idea what's going on here but I just want to be able to ban and unban people immediately, for obvious reasons!

[Sarabveer]

Originally Posted by bret I wonder if anyone's encountered this themselves.. If I ban someone from the web panel, it works fine, it bans them and when I unban them via the web panel they can rejoin again. If however, I ban someone from the ingame menu and then try to unban them from the web panel it doesn't unban them on the server. The strange thing here though, is that if I ban someone for 10 minutes ingame, unban via the web panel. They can rejoin again after around 5 minutes of the ban has been served (which makes me think there's a 5 minute timer, is ProcessQueueTime 5 the culprit?). Although! If I don't unban them via the web panel, after the same 5ish minute timeframe, the ban changes into a 10 hour ban? I've no idea what's going on here but I just want to be able to ban and unban people immediately, for obvious reasons!

Whoa, thats some crazy Shizz right there.