Sermon “Plays” count all showing 0

About › Support › Media › Sermon “Plays” count all showing 0

  • This topic is empty.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • 20th February 2020 at 3:49 pm #2998
    Avatar for Rich CoxRich Cox
    Participant

    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 at 8:42 pm #4506
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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.

    25th February 2020 at 12:46 pm #4524
    Avatar for Rich CoxRich Cox
    Participant

    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 at 1:02 pm #4525
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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

    25th February 2020 at 2:49 pm #4526
    Avatar for Rich CoxRich Cox
    Participant

    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 at 2:56 pm #4527
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    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.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.