I just installed this mod and if I don't have any forums blocked, I get a driver error when attempting to view "Today's Active Content":
LEFT JOIN ibf_members m ON ( m.member_id=p.author_id )
LEFT JOIN ibf_forums f ON ( f.id=t.forum_id ) WHERE t.forum_id IN (88,89,24,46,104,105,50,51,52,53,54,55,60,103,98,59,64,115,109,92,93,107,69,77,78,79,101,56,100,66,67,68,63,102,16,3,4,13,14,19,12,20,17,116,21,36,18,5,8,23,9,26,10,15,22,106,118,111,110,82,62,29,11,30,76,84,7,32,33,34,35,112,70,85,45,6,61,27,25,72,49,81,37,31,65,73,75,86,91,90,99,87,94,95,97,108,96,117) AND t.state != 'link' AND t.last_post BETWEEN 1257789480 AND 1257875880 AND t.forum_id NOT IN ( ) ORDER BY t.last_post desc LIMIT 0,1001 SELECT t.*,p.*,m.members_display_name, m.members_seo_name, m.member_id,f.id as forum_id FROM ibf_topics t LEFT JOIN ibf_posts p ON ( p.pid=t.topic_firstpost )
Looks like the problem is with the "NOT IN ( )" near the end of the statement. I fixed this by modifying the block of code in search.php as follows:
if( $this->request['search_app'] == 'forums' AND
$this->settings['sos30_blockforums_on'] AND
in_array( $this->member->getProperty('member_group_id') , explode(',', $this->settings['sos30_blockforums_groups'] ) ) AND
$this->memberData['blocked_forums'] != '' )
{
$this->search_plugin->setCondition( 't.forum_id', 'NOT IN', $this->memberData['blocked_forums'] );
} /* (SOS30) Block Forums from 'View New Content' v1.0.1 */
Basically just added another check to the if statement to make sure there are forums to be blocked before adding the NOT IN statement.
..Al