Subscriptions disappearing

  • Resolved Rufus McDufus

    (@rufus-mcdufus)


    2 years, 7 months ago

    Hi – I upgrade my WordPress site to PHP 8.1 a few days ago and I’ve just realised that new StCR subscriptions seem to be disappearing by themselves. I can reproduce this in one way by subscribing to a post, comment, and then delete the comment. The subscription then goes.

    I notice there appear to be no other user subscriptions since I upgraded, so perhaps there are other triggers for deleting the subscription?

    I’ve tried downgrading PHP to 8.0 and then 7.4 – same issue. System is WHM – Apache, MySQL, with PHP-FPM and opcache (the only site caching). I’ve tried flushing opcache, no joy.

    I’ve tried rolling back to the previous version of StCR (220608) with no luck. DB tables are all clean, no PHP errors or warnings at all.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Rufus McDufus

    (@rufus-mcdufus)

    I don’t think it’s comments being deleted which is the major issue here. I’ve monitored it over a day or so and. no comments were deleted in that time.

    Subscriptions seem to stick around for a few hours then just get disappear.
    Subscriptions from Aug 15 and before are still listed though.

    Plugin Author WPKube

    (@wpkube)

    I can reproduce this in one way by subscribing to a post, comment, and then delete the comment.

    That’s normal behavior, if a subscription is made with a comment (and not the “subscribe without commenting”) the subscription also gets deleted if the comments is deleted.

    Subscriptions seem to stick around for a few hours then just get disappear. Subscriptions from Aug 15 and before are still listed though.

    Are you experiencing any other missing content issue except the subscriptions.

    Haven’t had that problem reported before so can’t say for sure what might be the cause of it.

    It sounds like the database rolling back to a backup but that would cause all new content in that period to also be missing.

    Are you able to check the database (generally done through phpMyAdmin)?

    There is a wp_subscribe_reloaded_subscribers table in there which lists all the subscribers (not their subscriptions, just the subscribers). One of the columns is add_date, are there any subscribers in there that are made after Aug 15th?

    And if there are can you then check a few of those subscribers to see if they show up in the subscriptions in WP admin > StCR > Manage Subscriptions.

    Thread Starter Rufus McDufus

    (@rufus-mcdufus)

    Hi – thanks for the reply. Definitely no DB rollback and I ran a mysqlcheck on the DB just to make sure there were no corrupted tables.

    There are new subscribers and the subscriptions appear to be persisting now.
    What was happening was that some regular post subscribers were subscribing to new posts but the subscriptions just seem to disappear after a short period of time – maybe a few minutes, maybe hours, I’m not sure. No other issues with the site.

    I can’t think what else it could have been – perhaps something to do with stale object cache, no idea. So far so good though and it appears to be OK. I’ll keep any eye on it.

    • This reply was modified 2 years, 7 months ago by Rufus McDufus.
    Plugin Author WPKube

    (@wpkube)

    Hi @rufus-mcdufus

    Happy to hear it’s working now.

    I’m not sure what might have caused it.

    If you notice the issue again please let us know and we’ll figure out how to troubleshoot the issue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Subscriptions disappearing’ is closed to new replies.