Forum

Please consider registering
guest

Log In Register

Register | Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

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

Topic RSS
Help with the most-popular widget
25 October, 2010
5:57 pm
reformedstudent
Member
Forum Posts: 6
Member Since:
25 October, 2010
Offline

Hello,

First, I love Sermon Browser!
Now, I have set up my sermons page to the way that I want and installed the "Most Popular" widget in the sidebar on that page. However, I noticed that it is not counting the hits or downloads of my sermons?? – I looked in phpmyadmin and noticed that there is also a field for 'duration' in the #_sp_stuff table. Both the 'count' and the 'duration' fields are empty for all my sermons.

Can you help me with this?

Perhaps the problem is that I have not put the site on a live server yet and only have it on my local machine?

Thanks,
Andy -

25 October, 2010
7:00 pm
Ben Miller
Appleton, WI, USA
Moderator
Forum Posts: 386
Member Since:
18 June, 2009
Offline

Andy, a few questions for you:

When you add your sermons, how are you uploading the audio files? FTP or Sermon Browser admin pages?

At the bottom of your Edit Sermon pages, under Attachments: Do you see "Choose an existing file" or "Enter an URL"?

Ben Miller
Pathways Church, Appleton, WI, USA
25 October, 2010
7:03 pm
reformedstudent
Member
Forum Posts: 6
Member Since:
25 October, 2010
Offline

Hi Ben,

I am using the Sermon Browser admin page.
I do see the options to "Choose an existing file" or "Enter an URL" – and I have used both for uploading sermons audio files (mp3)

25 October, 2010
7:14 pm
Ben Miller
Appleton, WI, USA
Moderator
Forum Posts: 386
Member Since:
18 June, 2009
Offline

Andy,
Here's where I'm going with this: There are two main ways that Sermon Browser links to an audio file:

1. If you go to edit one of your existing sermons and under the "Attachments" area, you see "Choose an existing file" selected, this means that your .mp3 file is located in the default folder for audio files (usually /wp-content/uploads/sermons/).

2. If instead under the "Attachments" area you see "Enter an URL" selected, this means your .mp3 file is somewhere else.

With option #1, Sermon Browser knows exactly where your audio file is, and can examine the file to get the duration. Sermon Browser serves out the file itself when requested.

With option #2, Sermon Browser doesn't make any assumptions about where the file is or whether it has access to the file or not. It simply points to the URL. The audio file doesn't even need to be located on the same server as your WordPress installation.

My theory right now (and this is just a guess) is that Sermon Browser can't count the number of downloads for any sermon that is linked with Option #2. So if your sermons are linked in this way, the Most Popular sermon function won't work.

I always use option #1 for our sermons, and I don't use the Most Popular sermon widget, so this is just a guess. Does anyone else know any more about this?

Ben Miller
Pathways Church, Appleton, WI, USA
25 October, 2010
7:19 pm
reformedstudent
Member
Forum Posts: 6
Member Since:
25 October, 2010
Offline

Ben,

Thanks for the response. Unfortunately, I have uploaded most of my sermons with option#1
??

25 October, 2010
7:23 pm
Ben Miller
Appleton, WI, USA
Moderator
Forum Posts: 386
Member Since:
18 June, 2009
Offline

How many sermons do you currently have on your site?

When you view the list of sermons in the WordPress control panel (Sermons, Sermons) do any of them have any values in the "Stats" column?

Ben Miller
Pathways Church, Appleton, WI, USA
25 October, 2010
7:25 pm
reformedstudent
Member
Forum Posts: 6
Member Since:
25 October, 2010
Offline

Ben,

have 7 sermons currently. I looked at the stats on the admin panel and sure enough its empty

25 October, 2010
7:31 pm
Ben Miller
Appleton, WI, USA
Moderator
Forum Posts: 386
Member Since:
18 June, 2009
Offline

You said that you are currently running WordPress on a local machine. I don't know the details of how these stats are generated, but it's possible that it doesn't count any requests that come from the same machine that WordPress is running on. Is it possible with your setup to use another computer to visit your test site and listen to the sermon?

Ben Miller
Pathways Church, Appleton, WI, USA
25 October, 2010
7:37 pm
reformedstudent
Member
Forum Posts: 6
Member Since:
25 October, 2010
Offline

Ben,

Your brilliant! :) – The issue with the count actually had to do with the fact that I was logged in as administrator. once I logged out the count started to work. – However, the duration is still blank?
That should just be read from the mp3 file itself right??

25 October, 2010
7:50 pm
Ben Miller
Appleton, WI, USA
Moderator
Forum Posts: 386
Member Since:
18 June, 2009
Offline
10

Looking at my database, from what I can tell, any entry in the _sb_stuff table that has "file" in the type field should have a populated duration field (these would represent my Option #1 described above). Any entries that have "url" in the type field should have a blank duration field.

Do you have any "file" type entries in your _sb_stuff table that do not have a duration?

Ben Miller
Pathways Church, Appleton, WI, USA
25 October, 2010
7:57 pm
reformedstudent
Member
Forum Posts: 6
Member Since:
25 October, 2010
Offline
11

yep, all but one of my entries is a "file" type (one is a "url"), and none of them have any value for duration.

I also checked, and all my "files" are stored at wp-content/uploads/sermons/
if I click on any of the mp3 file in my Windows explorer it will tell me the duration – so I know the info is there its just not getting read.

25 October, 2010
8:01 pm
Ben Miller
Appleton, WI, USA
Moderator
Forum Posts: 386
Member Since:
18 June, 2009
Offline
12

As far as I know, the only place that the duration is used is in the podcast feed: The duration is reported in the podcast feed so that you can see the duration in iTunes before you download the .mp3 file. I don't know why your Sermon Browser didn't find those yet.

Ben Miller
Pathways Church, Appleton, WI, USA
Forum Timezone: Europe/London

Most Users Ever Online: 40

Currently Online:
10 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)

Comments are closed.