Payment receipt stays in queue

Bigbug

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

johnny

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?

johnny

see here: https://forum.itflow.org/d/690-timezone-inconsistencey-between-php-and-backend-db-mariadbmysql

Bigbug

That's what mine is set to

and I'm located in NY 🗽

🙏

psiiota

I found this bug aswell, I changed how the queue works slightly in 0.1.8.2 by o-psi · Pull Request #875 · itflow-org/itflow (github.com)

Bigbug

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

🙏

johnny

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.

Bigbug

johnny here is a screenshot to what my server time is set to

I think it looks ok, no @johnny ?

johnny

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?

Bigbug

johnny

johnny Did you restart your server once you set the timezone?

yea.. a few times..

johnny

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

psiiota

I have noticed the same behavior on scheduled ticket notifications.

johnny

psiiota Can you please do the same thing as well.

johnny

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.

Bigbug

johnny could i do that thru just terminal?

johnny

yeah that fine too

johnny

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

Bigbug

@johnny or @wrongecho I think you could mark this solved

https://forum.itflow.org/d/768-time-set-to-utc-on-mail-queue

johnny

Awesome @Bigbug yeah I think we can close this one