[3.0.4] Manage Banned Members returns Driver Error

After an upgrade to IP.Board 3.0.4 or higher, you may receive a driver error when going to ACP --> Members --> Manage Banned Users if you originally installed IP.Board on a version prior to 2.2.0.

Prior to IP.Board 2.2.0, on installation, there was no reference to the banned group in the conf_global.php file. This is now called starting in IPB 3.0.4. If that entry is not present in your conf_global.php file, you will get a driver error, with the log entry showing something similar to

Date: Fri, 09 Oct 2009 04:06:36 +0000
Error Number: 1064
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
IP Address:
Page: /admin/index.php?adsess=a76df91f8859eeb941af7e7ce9c43f14&app=members&module=members&section=tools&do=banned
Debug: array (
1 =>
array (
'file' => '/ips_kernel/classDb.php',
'line' => 1010,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => '//admin/applications/members/modules_admin/members/tools.php',
'line' => 107,
'function' => '_viewQueue',
'class' => 'admin_members_members_tools',
),
5 =>
array (
'file' => '/admin/sources/base/ipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'admin_members_members_tools',
),
)
mySQL query error: SELECT COUNT(*) as queue FROM ibf_members WHERE member_banned=1 OR member_group_id=

To correct this, you will need to go to ACP->Members and look next to your banned group and see what the ID number of the banned group is. Note that number.

Edit your conf_global.php file, and add this line after the 'admin_group' line.

$INFO['banned_group'] = 'X';

Where X is the ID number of the banned group.

If the problem persists, or you're not sure how to make this change, please contact technical support for assistance.