Source Ban++ 1.6.3 Import Bans - not working
 

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

Re: Source Ban++ 1.6.3 Import Bans - not working
 

Replacing $_COOKIE['aid'] with $_SESSION['aid'] on Lines L61 and L94 in pages/admin.bans.php should fix the problem.

Re: Source Ban++ 1.6.3 Import Bans - not working
 

Everything worked thank you so much!

Re: Source Ban++ 1.6.3 Import Bans - not working
 

Thank you ever so much for this, it work like a dream

I take my hat off to you

Re: Source Ban++ 1.6.3 Import Bans - not working
 

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