Raised This Month: $165 Target: $400
 41% 

Source Ban++ 1.6.3 Import Bans - not working


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
NetworkGuy0246
New Member
Join Date: Aug 2017
Old 09-21-2018 , 11:27   Source Ban++ 1.6.3 Import Bans - not working
Reply With Quote #1

I have tried about 8 different times with different sourceban builds by changing the admin.bans.php to older version to see if that would be the reason, but it does not import the bans. The exported banned_user.cfg is 100kb and it is in banid 0 STEAM_0:0:0000000 format. I have looked everywhere but it does not seem that people are having this same issue. Any help on this would be very helpful. Also as far as the webhosting it is unlimited\unlimited.

Thanks!

Here is the error i receive:

[256] mysqli error: [1048: Column 'aid' cannot be null] in EXECUTE("INSERT INTO sb_bans(created,authid,ip,name,ends,length,re ason,aid,adminIp,type) VALUES
(UNIX_TIMESTAMP(),'STEAM_0:0:91825077','','Im ported Ban',(UNIX_TIMESTAMP() + 0),0,'banned_user.cfg import',NULL,'adminip',0)")


Fatal error on line 79 in file /usr/www/sb101/web/includes/adodb/adodb-errorhandler.inc.php
Parent Function /usr/www/sb101/web/includes/adodb/adodb-errorhandler.inc.php - 79
/usr/www/sb101/web/includes/adodb/adodb.inc.php - 1250
/usr/www/sb101/web/includes/adodb/adodb.inc.php - 1190
/usr/www/sb101/web/pages/admin.bans.php - 96
Query String p=admin&c=bans
IP adminip

============================================= =============

Here is another error, same action:

[256] mysqli error: [1048: Column 'aid' cannot be null] in EXECUTE("INSERT INTO sb_bans(created,authid,ip,name,ends,length,re ason,aid,adminIp,type) VALUES
(UNIX_TIMESTAMP(),'STEAM_0:0:91825077','','Im ported Ban',(UNIX_TIMESTAMP() + 0),0,'banned_user.cfg import',NULL,'AdminIP',0)")


Fatal error on line 79 in file /usr/www/sb101/public/web/includes/adodb/adodb-errorhandler.inc.php
Parent Function /usr/www/sb101/public/web/includes/adodb/adodb-errorhandler.inc.php - 79
/usr/www/sb101/public/web/includes/adodb/adodb.inc.php - 1250
/usr/www/sb101/public/web/includes/adodb/adodb.inc.php - 1190
/usr/www/sb101/public/web/pages/admin.bans.php - 96
Query String p=admin&c=bans
IP adminIP

Last edited by NetworkGuy0246; 09-21-2018 at 11:28.
NetworkGuy0246 is offline
Groruk
AlliedModders Donor
Join Date: Jul 2016
Old 09-21-2018 , 12:11   Re: Source Ban++ 1.6.3 Import Bans - not working
Reply With Quote #2

Replacing $_COOKIE['aid'] with $_SESSION['aid'] on Lines L61 and L94 in pages/admin.bans.php should fix the problem.
Groruk is offline
NetworkGuy0246
New Member
Join Date: Aug 2017
Old 09-21-2018 , 21:17   Re: Source Ban++ 1.6.3 Import Bans - not working
Reply With Quote #3

Everything worked thank you so much!
NetworkGuy0246 is offline
Tiger50
Member
Join Date: Feb 2010
Location: Southampton UK
Old 09-27-2019 , 10:04   Re: Source Ban++ 1.6.3 Import Bans - not working
Reply With Quote #4

Quote:
Originally Posted by Groruk View Post
Replacing $_COOKIE['aid'] with $_SESSION['aid'] on Lines L61 and L94 in pages/admin.bans.php should fix the problem.
Thank you ever so much for this, it work like a dream

I take my hat off to you
Tiger50 is offline
Send a message via Yahoo to Tiger50
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: US
Old 09-27-2019 , 13:35   Re: Source Ban++ 1.6.3 Import Bans - not working
Reply With Quote #5

I also have an external import tool available: https://github.com/rumblefrog/sbpp-ban-import
__________________


Fingerprint: 91CC4E84AE4BFA89F2E431DD462F405E7D61ED35

Reach me @ https://keybase.io/rumblefrog

Github: https://github.com/rumblefrog

RumbleFrog is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:11.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode