Hi,

My client paid thru online payment but the receipt email got is still sitting in the queue

I don't think that anything is messed up with my email settings nor cron, because everything else is working fine.

see attached

It seems odd, but when I check the queue date and time, it appears to be later than the most recently queued emails.

Is that time set in the future?

The queue system is designed to send emails only after reaching the scheduled time or exactly at that time.

I'm confident it should have been sent by now.

Could you tell me what the system's timezone is set to, and also what timezone is configured in your ITFlow settings?

That's what mine is set to

and I'm located in NY 🗽

🙏

4 days later

That seems to be a system wide issue

here's what happened when tried to send emails thru bulk mail
Mail queue:

Audit logs:

these are from the same email, for some reason they're apart with 5 hours

Thanks @johnny and @wrongecho

🙏

Hello @Bigbug, you're correct. The audit log is utilizing MySQL Time to insert a timestamp, which is configured to UTC 0. However, the email you sent via PHP is configured to Eastern Timezone, which is precisely 5 hours apart.

To resolve this, you'll need to adjust your Linux timezone to Eastern. This can be done via the command line, followed by a system restart, and everything should function properly thereafter.

Additionally, we'll be updating the installer to prompt for timezone selection before installation to prevent such issues in the future new installs.

    yeah your right, MySQL MariaDB must not be getting the timezone from the system then.

    Did you restart your server once you set the timezone?

      okay its back to the drawing board here. 🙄 Thanks for the the report @Bigbug

      I have noticed the same behavior on scheduled ticket notifications.

        Hey @Bigbug Im curious on your server could you access your PHPMyadmin click accounts table create an account

        then edit the account, tell me what the account created at and updated at match the times you created and updated

        then delete the account.

          so here's what I observed on my install and on a brand new Debian 12 install using the script method

          Adding Records in MariaDB or ITFlow time is synchronized to whatever timezone I set to

          I'm curious

          • What OS and Version are using
          • What DB are you using and Version
          • Are you on a stand alone platform (Bare Metal or VM) or a shared web host
          • What Version of PHP is being utilized
          a month later