General discussion
Bug with notification emails / mail queue (v4.9)
bug

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.

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:

5e8bc93331af7

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

5e8bc95054a32

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.

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: ![5e8bc93331af7](serve/attachment&path=5e8bc93331af7) But on my live system, which was upgraded from 4.8 to 4.9, I see this: ![5e8bc95054a32](serve/attachment&path=5e8bc95054a32) 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 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

45 years old and still not smarter lol

Check my GitHub Repos: https://github.com/WebCrew

My CrazyMates Account: https://crazymates.de/Crazymate

Cute but Evil Community: https://cute-but-evil.de

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.

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.
Necessity is the mother of all inventions!

@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:

5e8d0d5bcaf78

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

@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: ![5e8d0d5bcaf78](serve/attachment&path=5e8d0d5bcaf78) 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. smile

Kind regards and have a great day,
Andy

@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

45 years old and still not smarter lol

Check my GitHub Repos: https://github.com/WebCrew

My CrazyMates Account: https://crazymates.de/Crazymate

Cute but Evil Community: https://cute-but-evil.de

@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.

@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 smile - 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.

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.

45 years old and still not smarter lol

Check my GitHub Repos: https://github.com/WebCrew

My CrazyMates Account: https://crazymates.de/Crazymate

Cute but Evil Community: https://cute-but-evil.de

edited Apr 8 at 9:04 am

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

>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
Necessity is the mother of all inventions!

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!

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 smile So you don't have to be embarrassed. smile

Kind regards, Andy

@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

45 years old and still not smarter lol

Check my GitHub Repos: https://github.com/WebCrew

My CrazyMates Account: https://crazymates.de/Crazymate

Cute but Evil Community: https://cute-but-evil.de

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

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)?

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)?

45 years old and still not smarter lol

Check my GitHub Repos: https://github.com/WebCrew

My CrazyMates Account: https://crazymates.de/Crazymate

Cute but Evil Community: https://cute-but-evil.de

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.

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.
Necessity is the mother of all inventions!
87
13
4
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft