Forum

Stephen,

I suspect you are using a newer version of WordPress.  I'm using 3.3.1 and I have the same problem you do. 

From what I can see:

Under "Preachers", only one preacher is displayed no matter how many are in the DB.

Under "Services & Series", only one service and series is displayed no matter how many are the DB.

I've created a patch / diff that may help – the problem appears to be in the MySQL query.

Modify sb-includes/admin.php

The modification is pretty simple -

change GROUP BY series_id to GROUP BY wp_sb_series.id

change GROUP BY service_id to GROUP BY wp_sb_services.id

change  GROUP BY preacher_id to GROUP BY wp_sb_preachers.id

Correct version is on the top (with < ), original is on the bottom (with >)

 diff sb-includes/admin.*
550c550
<       $preachers = $wpdb->get_results("SELECT {$wpdb->prefix}sb_preachers.*, COUNT({$wpdb->prefix}sb_sermons.id) AS sermon_count FROM {$wpdb->prefix}sb_preachers LEFT JOIN {$wpdb->prefix}sb_sermons ON {$wpdb->prefix}sb_preachers.id=preacher_id GROUP BY wp_sb_preachers.id ORDER BY name ASC");
—
>       $preachers = $wpdb->get_results("SELECT {$wpdb->prefix}sb_preachers.*, COUNT({$wpdb->prefix}sb_sermons.id) AS sermon_count FROM {$wpdb->prefix}sb_preachers LEFT JOIN {$wpdb->prefix}sb_sermons ON {$wpdb->prefix}sb_preachers.id=preacher_id GROUP BY preacher_id ORDER BY name ASC");
601,602c601,602
<       $series = $wpdb->get_results("SELECT {$wpdb->prefix}sb_series.*, COUNT({$wpdb->prefix}sb_sermons.id) AS sermon_count FROM {$wpdb->prefix}sb_series LEFT JOIN {$wpdb->prefix}sb_sermons ON series_id = {$wpdb->prefix}sb_series.id GROUP BY wp_sb_series.id ORDER BY name ASC");
<       $services = $wpdb->get_results("SELECT {$wpdb->prefix}sb_services.*, COUNT({$wpdb->prefix}sb_sermons.id) AS sermon_count FROM {$wpdb->prefix}sb_services LEFT JOIN {$wpdb->prefix}sb_sermons ON service_id = {$wpdb->prefix}sb_services.id GROUP BY wp_sb_services.id ORDER BY name ASC");
—
>       $series = $wpdb->get_results("SELECT {$wpdb->prefix}sb_series.*, COUNT({$wpdb->prefix}sb_sermons.id) AS sermon_count FROM {$wpdb->prefix}sb_series LEFT JOIN {$wpdb->prefix}sb_sermons ON series_id = {$wpdb->prefix}sb_series.id GROUP BY series_id ORDER BY name ASC");
>       $services = $wpdb->get_results("SELECT {$wpdb->prefix}sb_services.*, COUNT({$wpdb->prefix}sb_sermons.id) AS sermon_count FROM {$wpdb->prefix}sb_services LEFT JOIN {$wpdb->prefix}sb_sermons ON service_id = {$wpdb->prefix}sb_services.id GROUP BY service_id ORDER BY name ASC");
2578c2578

Eric said
Quick disclaimer:

 

I'm using WordPress 3.3.1, MySQL 5.1, PHP 5.3.3 on a CentOS 6 server with no control panel – all stock CentOS RPMs.

I make no guarantee that my suggested modification will work for you.  It may completely tank your site, server, house, and car..

 

I do hope that it helped.

I am on 3.3.2 and your patches worked for me!! Thanks

Later I found out about admin.php with all fixes – I installed it.