Support Forum

If you want to show a shortcode in forum post - use [ instead of [ as you write it so you can see the shortcode 😉

We use and recommend UK2 for hosting - get a month free

Avatar

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
Sermon "Plays" count all showing 0
20th February 2020
3:49 pm
Avatar
Member
Members
Forum Posts: 97
Member Since:
2nd April 2019
sp_UserOfflineSmall Offline

Hi Andy,

I'm using the shortcode [church_admin type=podcast] to display the recorded sermons and under the tab 'most popular', all the play counts are zero. Is this a known problem please? For the time being I've turned OFF the most popular tab as I know the sermons are being listened to...

Many thanks,
Rich.

20th February 2020
8:42 pm
Avatar
Admin
Forum Posts: 934
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

It works well for us, although the play count on the most popular doesn't refresh straight away if you play one of them in the most popular tab.
I fixed it a couple of updates ago - Do you have any other javascript errors on the page? That will block it working.

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription - free int'l bank transfers with Revolut

25th February 2020
12:46 pm
Avatar
Member
Members
Forum Posts: 97
Member Since:
2nd April 2019
sp_UserOfflineSmall Offline

Hi Andy,

I've had a look into the database and under (wp_church_admin_sermon_files) the table 'plays' is 'NULL' for every sermon.

If I manually enter a number into the plays table it will show up correctly on the website.

I have disabled all other plugins, so just have church admin enabled and still no joy.

Are there any things you might suggest I try please?

Thanks as ever, blessings,
Rich.

25th February 2020
1:02 pm
Avatar
Admin
Forum Posts: 934
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

I think I've worked it out!
Once a file is played, the database query is to add 1 to the number of plays already in the that row. Well if it's NULL not 0 that's kind of hard!

Could you do
UPDATE wp_church_admin_sermon_files SET plays = 0 (replacing wp with your prefix) and see if playing a file updates properly.
If so I'll the plugin to remove the NULLs

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription - free int'l bank transfers with Revolut

25th February 2020
2:49 pm
Avatar
Member
Members
Forum Posts: 97
Member Since:
2nd April 2019
sp_UserOfflineSmall Offline

That worked a treat Andy. Have updated all the entries to 0 and now successfully increments on each play.

Great job!!

That will keep our Pastor happy 😉

25th February 2020
2:56 pm
Avatar
Admin
Forum Posts: 934
Member Since:
4th March 2015
sp_UserOfflineSmall Offline

Cool, will put a fix in the next update for everyone else that might be experiencing the issue. MySQL has been updated on many sites recently and NULL is causing problems with date fields too.

If you are finding the plugin useful, please subscribe to the app - it's free for your congregation to use and only £9.99pm for a church subscription - free int'l bank transfers with Revolut

Forum Timezone: Europe/London

Most Users Ever Online: 101

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Pastor Andres: 141

Rich Cox: 97

David Z.: 84

rrfranks: 69

seanmcint: 52

Allen: 51

Jon: 46

Gavin: 41

Nathan Booth: 36

Janeen: 23

Member Stats:

Guest Posters: 45

Members: 421

Moderators: 0

Admins: 1

Forum Stats:

Groups: 5

Forums: 14

Topics: 611

Posts: 2297

Administrators: andymoyle: 934