Hello

I'm having issues with the Mail Notify plugin and the mail queue.

I have a user who's been getting the same email repeatedly.

I tracked down the issue to sys/CODOF/Forum/Notication/MailQueue.php on line 43:

$qry = 'DELETE FROM ' . PREFIX . 'codo_mail_queue WHERE id IN (' . $_ids . ')';

I believe the PREFIX or the codo_ should be there, but not both.

I also seem to be having an issue where none of my users are getting notified of posts, but I need to look into my mail logs to track that one down.

Unfortunately this didn't fix the problem - my user is still getting the same notification. So it's coming from somewhere deeper.

On a fresh install, this is what the System > Cron shows:

But on my live system, which was upgraded from 4.8 to 4.9, I see this:

That last entry doesn't look right. Though I'm not sure if that's fine because it'll be ignored, or if it's the mail_notify_send I should be investigating.

When I disable the Mail Notify plugin, that mail_notify_send entry remains there.

I'll keep working on this and let you know what I find, if I can figure anything out.

Hi mate,

sometimes it is helpfull to read a little bit at the forums.
The problem with the mail system is already on @admin s to do list - look please:

https://codologic.com/forum/index.php?u=/topic/12701/daily-digest-broken

I think the Codo team will fix the problem in the near future.

I wish You the best with Your project and stay healthy.

Kind regards, Andy

Hi,

Can you try updating the table named codo_crons? There is a column named cron_status, set that to 0 for all rows in that table.

@WebCrew - I did a search, but I didn't think to search for Daily Digest. Reading that it doesn't seem

When I search for "notifications" I see a post that says emails are working fine, but there's an issue with notifications tab under 'edit profile'.

Searching for "email" only gives one result, from the same thread.

I think it's just that I don't know which terms to search for.

Are there any other posts that I could look at? Is @admin's todo list public?

I also realised I was completely off target with the PREFIX - by default it's set to empty so it's not the problem.

@admin - thanks. I had a look and it seems that cron_status is set to 0, both for my production server and the fresh install.

The problem seems to be related to the codo_notify table - it's a whole lot of rows of the same notification, to the same user, at different times:

All the other codo_notify_ tables look correct, they have a variety of entries.

@david_nash

I have to apologize to you. I reread my answer above and it sounded a bit harsh - I didn't want that. I just wanted to point out that the email system is already being processed by the CL team.

To your question: In my experience there is no public "Admin-To-Do-List". As an active community member who hangs around here almost every day, I often know what topics are currently relevant and are already being dealt with and pursued by the CF team. For this reason, I also linked You the other topic to show you that the CF team is already working on the email system. I hope you don't think to bad about me - I didn't want to sound that harsh, sorry again mate.

Kind regards and have a great day,
Andy

@WebCrew no worries Andy! It did feel a bit harsh but I really appreciate your follow-up.

I'm setting up a forum for my local Buddhist group in Australia. We're not permitted to meet as a group at the moment, and I'm really keen to get it up and running smoothly as soon as I can.

I'm a web developer so have enough knowledge with php/mysql to be dangerous. Please excuse me if I'm being annoying!

Would you know how to turn off all cron tasks? There doesn't seem to be an option in the admin (only edit, no disable or delete). I'd like to stop the email notifications all going to the one person - it's happening several times a day.

Hi mate @david_nash

I`, sorry I dont know how to turn off the crons, Youre right there is no option for it. The only option we have is to turn off the Mail Notify Plugin at the "plugins" tab.

I'm sure you can turn off the cron function, but that's beyond my level of knowledge and we should ask @admin or @adesh about it.

Good luck with Your community project, it sounds interesting.

Kind regards, Andy

Update: You can inform Your users about that they have a "notification setting" hidden in their profile settings. If they turn notifications/subscriptions off it should do the trick.
Another very dirty and bad solution would be to setup another value at the MySQL codo_user_preferences table to quasi cut the umbilical cord - but lets wait what admin will tell You - I`m sure he knows a good solution for You. The CF team always finds a way to help.

The problem seems to be related to the codo_notify table - it's a whole lot of rows of the same notification, to the same user, at different times:

Yes, this is the exact problem we have been trying to replicate since it did happen to one other person. You can just delete all those rows if you want. We will try to reproduce this issue again in our local setup and try to fix it.

Would you know how to turn off all cron tasks?

I think you should instead disable the mail notify plugin as suggested by @WebCrew

Thanks @WebCrew and @admin ... turning off the Mail Notify plugin is so obvious I'm embarrassed.

@admin I can send you a dump of my database if you'd like to replicate the problem.

There's not a huge amount of posts or users, and nothing personal apart from the email addresses, which I'll replace with something.. random strings I guess?

Please email me!

@david_nash

Yes, sometimes we overlook the simplest solutions even if we have them right in front of our nose. It has happened to all of us So you don't have to be embarrassed.

Kind regards, Andy

Unfortunately this didn't fix the problem - my user is still getting the same notification. So it's coming from somewhere deeper.

Doesn't it work if the user goes to his profile settings "Preferences & Subscriptions Tab" and set them to level "2" (so no email notifications)?

If you want a quick fix you can just delete all rows in codo_notify_subscribers table

Although note that this will unsubscribe all the users from all topics/categories so they will have to subscribe again.

@IndianoMember Better open a new topic and describe your problem as well as possible, maybe even with some screenshots etc. and if it is a really urgent problem then "mention" (@) "admin".

Older topics are sometimes overlooked.

Good luck mate

Kind regards, Andy

As @WebCrew suggested, please create a new topic next time.

Try checking the codo_mail_queue table and search for the email address of the user getting the email.
Are there duplicate rows getting created there?

@admin & @WebCrew - IndianoMember is a spammer and may have edited their post after your comments. Other posts are also spam.