solved Jamroom forum not sending notifications

I moved from Jamroom hosted to self-hosted in January. I just realized today that on that day, all the user notifications of new topics stopped.

There is no error in Mailgun. The DNS remained the same. All the checkmarks are green.
This is the delivery log. Jamroom just stops sending messages?

How can I figure out what happened?

updated by @elise: 09/19/20 06:51:57AM

no error at mailgun.... hmmm.

* anything in DASHBOARD -> ACTIVITY LOG
* or DASHBOARD -> ERROR LOG
* are all the lights green at: ACP -> CORE -> SYSTEM CORE -> TOOLS -> SYSTEM CHECK
* do the settings at ACP -> MODULES -> COMMUNICATION -> EMAIL SUPPORT -> GLOBAL CONFIG line up correctly, eg: is the ACTIVE EMAIL SYSTEM set to "Mailgun Email API"?
* if you go to ACP -> COMMUNICATION -> EMAIL SUPPORT -> TEST EMAIL what happens?
* are the settings at ACP -> COMMUNICATION -> MAILGUN API -> GLOBAL CONFIG correct?

* anything in DASHBOARD -> ACTIVITY LOG
Regular maintenance. No red errors.
6/15/20 12:01:00AM 173.247.240.122 3342627 [system] daily maintenance worker completed
clear 06/15/20 12:01:00AM 173.247.240.122 3342627 [system] deleted 1 system timeline entries older than 60 days
clear 06/15/20 12:01:00AM 173.247.240.122 3342627 [system] pruning timeline entries older than 60 days
clear 06/15/20 12:01:00AM 173.247.240.122 3342627 [system] create XML site map - completed
clear 06/15/20 12:01:00AM 173.247.240.122 3342627 [system] create XML site map - starting
clear 06/15/20 12:01:00AM 173.247.240.122 3342627 [system] SiteBuilder: removed 2 expired backup entries
clear 06/15/20 12:01:00AM 173.247.240.122 3342627 [system] daily maintenance worker started
clear 06/14/20 02:58:07PM 67.177.22.81 1137036 [xxx] successful login by xxx
clear 06/14/20 09:43:13AM 71.238.111.206 3732877 [EliseLebeau] core: integrity check completed
clear 06/14/20 09:42:14AM 71.238.111.206 3732877 [EliseLebeau] core: integrity check started
clear 06/14/20 09:12:41AM 71.238.111.206 3594819 [EliseLebeau] core: integrity check completed
clear 06/14/20 09:11:50AM 173.247.240.122 3595295 [system] corrected 1 forum categories with incorrect topic counts
clear 06/14/20 09:11:40AM 71.238.111.206 3594819 [EliseLebeau] core: integrity check started
clear 06/14/20 12:00:46AM 173.247.240.122 1099492 [system] daily maintenance worker completed
clear 06/14/20 12:00:46AM 173.247.240.122 1099492 [system] create XML site map - completed
clear 06/14/20 12:00:45AM 173.247.240.122 1099492 [system] create XML site map - starting
clear 06/14/20 12:00:45AM 173.247.240.122 1099492 [system] daily maintenance worker started

* or DASHBOARD -> ERROR LOG
No PHP Errors at this time

* are all the lights green at: ACP -> CORE -> SYSTEM CORE -> TOOLS -> SYSTEM CHECK
2 lights are red
- Memory Cache functions are missing Ensure APCu functions have been enabled in your PHP install
- tifig executable modules/jrSystemTools/tools/tifig is not working correctly


* do the settings at ACP -> MODULES -> COMMUNICATION -> EMAIL SUPPORT -> GLOBAL CONFIG line up correctly, eg: is the ACTIVE EMAIL SYSTEM set to "Mailgun Email API"?
- This has the same settings as when I was hosted. Which was system default SMTP with the Delivery Setting having all the details on my local mail server. I changed it to Mailgun API which works too as seen by test email.

* if you go to ACP -> COMMUNICATION -> EMAIL SUPPORT -> TEST EMAIL what happens?
It works, both with the default local SMTP and mailgun.

* are the settings at ACP -> COMMUNICATION -> MAILGUN API -> GLOBAL CONFIG correct?
Yes. they didn't change when I moved.

Sooooo weird! Email works. But forum is not triggering them?
updated by @elise: 06/15/20 08:44:29AM

What are the steps you're taking in forum and expecting that an email will be triggered? I'll setup and debug it.

Feels like the email is not being triggered if the email sending system is working. Need to figure out why.

--edit--
Another idea you can try if you like is to set the email sending system to "Send to activity log", if they do show up in the activity log then the issue points to the email sending system beyond jamroom.
updated by @michael: 06/15/20 07:32:27PM

A new post should trigger an email notification to those subscribed to the category/post. These are the specific emails that stop being sent when I moved my server.

Just setup and ran a couple of tests here, the sending system does seem to be working, so:
* could you check that the yellow follow indicators are on for the categories/threads of a user who is supposed to be getting notified.
WHY: the guess is that maybe the 'following' table did not get imported correctly during the import and now nobody is following anything.
updated by @michael: 06/16/20 10:39:40PM

If I go to a thread I started, I see the follow icon is yellow.
Yeah it's kinda sad. My forum is completely dead quiet, without any activity
updated by @elise: 06/17/20 06:58:04AM

jr_jrforum_follow_topic has over 5000 rows.
jr_jrforum_follow_category has over 600 rows.

o_O

If you like I can try to debug it on your server or download the database and debug it on my server. Send the admin logins to support at jamroom dot net if you'd like to do that.

Otherwise: Lets examine what we have.
* The database should be the same as it was
* the connection between users and the things they are following do exist in the database
* The integrity check would have been run after the transfer so the system should be the same
* all the modules that existed on your previous hosting also exist on your new hosting.
* email does get sent when tested
* no errors are showing in the system check
* Did you try a manual reset of the caches (I don't think this is related, but we're stretching here)?

Docs: "Manually clearing caches"
https://www.jamroom.net/the-jamroom-network/documentation/troubleshooting/114/somethings-wrong-what-do-i-do#manually-clearing-caches

IDEA: Try creating a NEW user and get them to watch a thread/category then make a new thread/category post and see if it notifies new users.

we need to identify where the blockage is.

I used the login details you sent and logged in, then created a new user account 'michael' then wrote a new forum post.

Then logged as the first user you gave me and replied. I did get notified.
updated by @michael: 06/18/20 02:16:17AM

- yes on 1,2,34,5,6.

I did a manual cache reset this morning. I had a lot of folders there that are not installed anymore.

But I logged into mailgun today and I saw hundreds of email being sent about the test post you made. I have no idea why, I haven't touched anything yesterday. Maybe toggling the communication settings cleared something up? Of you fixed something? I'll take that as a win!

There is something wrong with my database though. My forum shows a count of 0 items.
I'll do a different post for this.
updated by @elise: 06/18/20 08:40:11AM

I did not fix anything, Only thing that I did that may have had an effect was to run the integrity check tool.

glad its working.