Forum

This forum is now read-only. Support is provided at https://wordpress.org/support/plugin/sermon-browser/

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Adding Preachers not working correctly
20 July, 2011
4:35 pm
sarahwhg
New Member
Members
Forum Posts: 2
Member Since:
20 July, 2011
sp_UserOfflineSmall Offline

I just installed Sermon Browser. I am using version 0.45.4 of the plugin and Wordpress 3.2.1.

When I go to the "Preachers" section, there is just the default preacher listed. I click "add new" preacher, fill out the form and click save. It then says that the preacher has been added, but he is not listed on this page. I tried logging out and back in again, deactivating and activating the plugin, but still only the default preacher is listed on the "Preachers" page. However, I then I clicked "Add Sermon" and all the preachers are listed that I added before (many are duplicates). Is there any way to delete the ones I am not using, since they aren't listed on the "Preachers" page?

It seems like the only preachers that are listed on the "Preachers" page are the default one and any that have sermons assigned to them. Of course you can't delete preachers who have sermons assigned to them.

Thanks

25 July, 2011
3:33 pm
Brian
Member
Members
Forum Posts: 3
Member Since:
30 December, 2008
sp_UserOfflineSmall Offline

Same thing happening to me. Really need to get this fixed as the plugin is not usable without it.

25 July, 2011
3:39 pm
Brian
Member
Members
Forum Posts: 3
Member Since:
30 December, 2008
sp_UserOfflineSmall Offline

Ahhh...just figured it out. The preacher is added to the database but does not show up in the list of preachers until a sermon is created and assigned to him. A little confusing but it definitely works for me now.

25 July, 2011
3:58 pm
sarahwhg
New Member
Members
Forum Posts: 2
Member Since:
20 July, 2011
sp_UserOfflineSmall Offline

Glad to hear I'm not the only one. The problem is that once you add a sermon to a preacher, you can't delete the preacher.

I ended up having to completely uninstall the plugin and reinstall it to get rid of all the preachers. I hope this bug is fixed soon.

Sarah

1 August, 2011
3:32 pm
joelg
chicago, il
New Member
Members
Forum Posts: 1
Member Since:
1 August, 2011
sp_UserOfflineSmall Offline

Thanks for the fix! You are right, It's rather confusing. I hope this is made easier in the next version of the plugin. Perhaps make sure all preachers are listed even if they don't have a sermon assigned to them. Thanks!

2 October, 2011
4:50 pm
Doug Sjoquist
Ohio, USA
New Member
Members
Forum Posts: 1
Member Since:
2 October, 2011
sp_UserOfflineSmall Offline

I am in the process of converting our church website to WordPress and found this plugin (much appreciated, thanks!)

I found the cause of this bug, in the 'admin.php' page, the MySQL queries for preachers, series, and services all have the same bug.

Each does something like this:

$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");

Which in this case returns zero records if there are no sermons. To show preachers regardless of whether there are sermons (which I think is the intent), the "GROUP BY preacher_id" clause needs to be changed to "GROUP BY id". The reason is even though the initial query finds preachers without sermons, the group by clause removes them since there are no sermons. By changing it to "id" (the column on the sb_preachers table), it works as I expected.

The corrected query is:

$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 id ORDER BY name ASC");

There is a similar problem with the GROUP BY for the series and services queries in admin.php

Doug

1 December, 2011
9:41 pm
James T. Jones
New Member
Members
Forum Posts: 1
Member Since:
1 December, 2011
sp_UserOfflineSmall Offline

Thank you everyone, I am new to sermon-browser and had found that adding a sermon made the preacher appear but the above code fix made it work porperly. It was driving me crazy! (My wife says that is a short trip 🙂

 

Jim Jones

21 March, 2013
4:49 am
Baptistengemeinde Baptistengemeinde
Innsbruck, Austria
New Member
Members
Forum Posts: 1
Member Since:
21 March, 2013
sp_UserOfflineSmall Offline

I also fixed the same bug with the series using this code

$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 id ORDER BY name ASC");

instead of this code

$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");

in admin.php.

22 March, 2013
3:25 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Thanks for the bug fixes, and thanks for finding this old post.  I've added it to the new FAQ:

http://www.sermonbrowser.com/f.....oting-faq/

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

Forum Timezone: Europe/London

Most Users Ever Online: 381

Currently Online:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Rich Brown: 358

Matt Schlueter: 93

Mindy: 72

Don Johnson: 65

anointed: 57

0be1: 55

Member Stats:

Guest Posters: 7

Members: 3188

Moderators: 1

Admins: 1

Forum Stats:

Groups: 1

Forums: 2

Topics: 1713

Posts: 7499

Newest Members:

marktest, deatles50, ValeriaGoodriz, dapedPup, oapedPup, Margarettoimb

Moderators: Ben Miller: 1628

Administrators: Mark Barnes: 435