Log In
Register
Home
Topic RSS
5:23 pm
8 February, 2010
Offline
Hi, thanks for the great plugin! I have it installed on my site (in development), and the sermon page works, but when I click on the title of a sermon either from the sermon page or from the widget, it errors out. The only way I can link from the widget is by clicking the speaker link.
Can anyone help? My site is here: http://www.mhbridge.ca/wp
Thanks!
-Cam Hart
8:22 pm
18 June, 2009
Offline
Interesting. I haven't seen that before. I see that when you visit the sermon page, it says "No sermons found", but the title of the sermon and the preacher name are in the title of the HTML.
Would you mind adding a second sermon, even if it doesn't have an audio file on it?
4:01 pm
8 February, 2010
Offline
Hi, I added another sermon (w/o audio), and have the same issue. As far as I can tell I've set this up correctly, so I'm stumped on this one! Thanks for your help :)
4:09 pm
18 June, 2009
Offline
One thing I noticed is that your podcast links are incorrect. Under Sermons, Options, what do you have for "Public podcast feed"? Try setting it to:
http://mhbridge.ca/wp/media-re…..s/?podcast
I don't think this will fix your other problem, but who knows? It's something that should be fixed anyway.
4:30 pm
18 June, 2009
Offline
This is just a hunch – do you know what version of PHP you are using on your server?
6:21 pm
8 February, 2010
Offline
Hmmm, not sure, I'll have to find out. I'm hosting with hostgator, so I'm sure it will be current…
Also, I fixed the podcast link I think…
9:42 pm
8 February, 2010
Offline
It's PHP 5.
10:04 pm
18 June, 2009
Offline
Here is something you can try. It involves editing one of the PHP files in the Sermon Browser plugin.
First, the theory:
SQL queries are in the form "SELECT … FROM … WHERE …". In the Sermon Browser file "frontend.php" there are lots of these queries. In two of them, however, the "WHERE" keyword is in lowercase instead of upper case ("where"). One of these is the query that loads an individual sermon from the database for display on a single sermon page. SQL queries are supposed to be case-insensitive, but perhaps you have an unusual version of database that requires the keywords to be all uppercase.
It's a guess.
Anyway, if you'd like to try changing this and see if it makes a difference, here's is what you need to do.
Open up the file frontend.php from the Sermon Browser plugin. You'll find it on your site at /wp/wp-content/plugins/sermon-browser/sb-includes/.
You'll find "where" on lines 292 and 725. Replace it with "WHERE".
Save it, upload it, and see if it helps. If you aren't comfortable with a text editor and FTP, you can edit the file right from the WordPress control panel. It's easy, but there aren't any line numbers to help you find the spots to edit; you'll have to search yourself. To edit the file through the WordPress control panel, go to Plugins, and then under Sermon Browser, click Edit. Select the "sermon-browser/sb-includes/frontend.php" file on the right. Then search for "where" and change it to "WHERE". When you are done editing, click on "Update File" at the bottom.
I don't know if this will work or not, but it is my only guess right now. If you mess something up, Sermon Browser could quit working altogether, but you can just delete the plugin and reinstall.
After you try it, please let us know so we can see if it worked or not.
11:30 pm
8 February, 2010
Offline
Hi, thanks for your detailed response! I made the changes to those lines, but still no go. Wow, would never have come up with that on my own though, good thinking, lol.
Any other thoughts? Should I reinstall the plugin? Would it help for you to have access to my WP installation?
3:11 pm
18 June, 2009
Offline
It would have been even better if it would have worked. :)
So here are a couple more things you can try:
1. Delete both of your sermons, then add a new one.
2. Sermon browser has an uninstall button (Sermons, Uninstall). This will Drop all of the Sermon Browser tables before deactivating the plugin. So hit the uninstall button, then delete the plugin, if it is still there by clicking Plugins, find Sermon Browser (you might need to click "All" to find it), then click Delete. After that, reinstall Sermon Browser and add a new sermon.
I hope one of those ideas helps!
4:33 pm
18 June, 2009
Offline
Cam, something else you can try, even before you go through uninstalling and reinstalling. Currently your sermons are not attached to a Series. Define a Series (call it Miscellaneous or something) and then edit your two Sermons to make them a part of this new series. Then see if that fixes the problem.
Please let us know after you try this.
5:31 pm
9 February, 2010
Offline
This is a bug. I had the same problem and while investigating I noticed that the SQL used to return individual sermons expects there to be a valid record in the series table, thus if you have not created any series, your sermon will no display and you will see No Sermons available.
To fix this you need to edit frontend.php
goto the function called:
function sb_get_single_sermon($id)
and change the contents in double quotes for line starting with: $sermon =
to:
"SELECT m.id, m.title, m.datetime, m.start, m.end, m.description, p.id as pid, p.name as preacher, p.image as image, p.description as preacher_description, s.id as sid, s.name as service, ss.id as ssid, ss.name as series FROM {$wpdb->prefix}sb_sermons as m left outer join {$wpdb->prefix}sb_preachers as p ON m.preacher_id = p.id left outer join {$wpdb->prefix}sb_services as s ON m.service_id = s.id left outer join {$wpdb->prefix}sb_series as ss ON m.series_id = ss.id where m.id = {$id}"
so the whole line would read:
$sermon = $wpdb->get_row("SELECT m.id, m.title, m.datetime, m.start, m.end, m.description, p.id as pid, p.name as preacher, p.image as image, p.description as preacher_description, s.id as sid, s.name as service, ss.id as ssid, ss.name as series FROM {$wpdb->prefix}sb_sermons as m left outer join {$wpdb->prefix}sb_preachers as p ON m.preacher_id = p.id left outer join {$wpdb->prefix}sb_services as s ON m.service_id = s.id left outer join {$wpdb->prefix}sb_series as ss ON m.series_id = ss.id where m.id = {$id}");
Thanks
10:21 pm
8 February, 2010
Offline
Hey guys, that last fix (editing frontend.php) seems to have worked. Thanks!!!
While the both of you are checking this thread, any idea why there is a set of parenthesis after my sermon titles? lol… lots of tweaking to do yet…
11:08 pm
9 February, 2010
Offline
Can you show us exactly what you mean (copy and paste the output into a post)
2:08 am
18 June, 2009
Offline
Cam, the parenthesis after your sermon titles are where the scripture reference would go, if you had defined a scripture text for the sermon. See this recent sermon on my church's website as an example. It does look odd if you don't have a scripture text defined for a particular sermon. If you generally don't have a scripture text and would like to remove this altogether, you can do this by editing your Sermon page template. Remove the following code:
Mark Vejvoda, thanks for the bug fix and the information!
Mark Barnes, could this bug fix be incorporated into a future version of Sermon Browser?
Most Users Ever Online: 40
Currently Online:
12 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
malpan: 2453
jogen: 2440
VanWatterson: 652
GeraldSebring: 364
LucasWoltman: 362
RandellFeenstra: 362
Member Stats:
Guest Posters: 7
Members: 2062
Moderators: 1
Admins: 1
Forum Stats:
Groups: 1
Forums: 2
Topics: 1071
Posts: 4042
Newest Members: richdorm, Aaron Velasquez, aaronv, dave5884, tomduckering, ccwebb
Moderators: Ben Miller (386)
Administrators: Mark Barnes (425)
