Forum

When I add a new preacher it IS added to the Database because his name appears in the combobox to choose from when I add a sermon but on the preacher page only the first preacher is visible. Could anyone help?
TIA

RB

I am having this problem too.

Could someone on the admin side address/fix this problem. I cant move on until this is done.
TIA

The problem is in admin.php. They added code to display the number of sermons preached by a preacher but it broke something. I am not skilled in MYSQL so maybe someone can see what needs fixed but here is a temp fix to show all the preachers. It will just have a blank spot under "sermons" in the admin…

In admin.php, change the following line (near line 550):
$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");

to:
$preachers = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}sb_preachers ORDER BY name asc");

It turns out that a similar problem is there for the "Services" list. Here's how to fix that as well:

In admin.php, change the following line (near line 600):
$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");

to:
$services = $wpdb->get_results("SELECT s.*, m.id AS mid FROM {$wpdb->prefix}sb_services AS s LEFT OUTER JOIN {$wpdb->prefix}sb_sermons AS m ON s.id = m.service_id ORDER BY s.name asc");