Notifications stuck on ‘post pending’

Hi stevedpcreative,

Thanks for trying Post Notif; I’m sorry to hear your notifications are getting stuck.

I assume, based on your statement that you’ve already tried manually resetting the status (directly in the database), to no avail, that you’ve seen this other thread: https://www.ads-software.com/support/topic/manually-sending-notifications/ ? I won’t waste your time by repeating what I said in my responses in there.

You might want to look in the mail logs on your server to see if there is anything useful in there that indicates what the root of the problem is.

Also, depending on your level of comfort with PHP, you could take a look at the process_post_notif_send function in ../post-notif/admin/class-post-notif-admin.php. The first few lines of the function result in attempting to send to ALL (valid [i.e., confirmed] and relevant [i.e., subscribed to the category of the post for which notifications are being sent]) subscribers in one go OR breaking up your subscriber set into batches, in order to avoid PHP timeouts; you could change the statement that reads from your php.ini file:

$max_execution_secs = ini_get('max_execution_time');

to:

$max_execution_secs = 30;

or some other appropriate hardcoded value (in seconds) and see if that makes a difference for you.

As I mentioned in the support thread I referenced above, I have been unable to re-create the timeout issue myself so I am admittedly grasping at straws for solutions for you – sorry. ??

Hope this helps,
Devon

Hi Devon,

I have tried the above solution, but it didnt have any effect. The item is still stuck at the process also I noticed that the buttons (to cancel or restart) don’t work aswell. Maybe both cases have the same cause?

Kind regards,
Steven

I think we have the same problem. Over here there were no notifications at the last three posts.

Have you changed anything to the code Devon?

I wanted to use the workaround with the SQL-file you suggested, but I couldn’t find it.

And by the way: Happy 2018!

Regards,
Theo

I have deleted Post Notif and installed it again. Imported all my subscribers. That went fine.

Now waiting for another post at my blog. I hope to write it next week, so then I can try if it works.

Regards,

Theo

Hi Steven,

I’m sorry that the suggestions didn’t help. Thanks for the additional info about the cancel and restart links not working. It may well be related. I wonder if you have a database user permissions error of some sort. I do not know how this would have happened but I wonder if the (MySQL) database account you used, when installing your site, is able to insert rows into the Post Notif custom tables but cannot update them? Or perhaps this issue is only affecting the post_notif_notif table.

I honestly don’t know how the permissions would have gotten mangled in this way, without direct human intervention, but, as I said before, unfortunately, I am really grasping at straws here, and am assuming (although I know that is always dangerous! ?? ) that it is a permissions issue of some sort, specific to your site set up, as opposed to a general code issue with the plugin. I say that only because I have only heard from you and a couple of others about similar issues. (Please don’t take this as me minimizing your issue the frustration it is causing you; I want everyone who wants to use Post Notif to have a good experience and it eats at me when I cannot find solutions for issues people encounter!)

Anyway, would you please let me know what you find if you are able to check the WordPress DB owners’ permissions on the post_notif_notif table?

Thanks,
Devon

Hi Theo,

Happy 2018 to you, as well!

I’m sorry you’re having similar issues to Steven.

Yes, version 1.2.0 introduced a significant amount of code change. I am not sure which SQL file you are referring to?

In any case, I hope things work better when you send your next post; please do let me know.

Thanks,
Devon

I realized that my last two monthly posts have had the same issue. Actually, the one in March sent out 20 of 240 and April 0 of 240. I tried changing the Automatic to Manual and both are still pending. I will try deactivating it like Theo did above. Since he hasn’t posted again, I am thinking that it worked for him. Thought I could attach screen-shots of what it looks like on the page and the lists, but it doesn’t look like I can attach anything.

Hi Barbara,

Thank you for using Post Notif; I’m sorry to hear you’re having notification sending problems, however.

You might want to check out this thread (it has a second page as well): https://www.ads-software.com/support/topic/manually-sending-notifications/

The end result was that Theo (and others) downgraded to Post Notif version 1.1.5 which resolved their send problems. Unfortunately, I believe it is due to something with how particular hosting platforms are configured, so I have not been able to isolate any specific Post Notif code that I could change to address this.

Thanks,
Devon

I have a client who is climbing the walls because PN is no longer working for him, and I want to downgrade to V1.1.5 – but I cann ot find anywhere to download it ?

– Nick

I was having problems with Post Notif too and even this didn’t work. Give it a try because it might work for you. This link was given in another thread:
https://de.www.ads-software.com/plugins/post-notif/advanced/
Scroll to the bottom of the page and you will see “development version” with arrows next to it. Scroll down to the version you are looking for.

Thanks for including that link, Barbara. English download page can be found at: https://www.ads-software.com/plugins/post-notif/advanced/ (though what they point at is the same set of files).

You are welcome. I can’t seem to find another notification program that is as simple as Post Notif. All I want to do is send a notification of when a blog is published, nothing else, doesn’t seem to be anything that simple out there. On top of that, they are complicated and I can’t get them to work. I am not a computer guru, just trying to keep my website working and people notified.

• This reply was modified 6 years, 10 months ago by Barbara418.