PHP Session Timezone Not in Sync with SQL Timezone

matth

I swore I saw this somewhere… I know there's a page where I can manage all the shared files, however I cannot for the life of me find it again. I did some searching here on the forum, but only saw discussions about it being a feature. Any pointers greatly appreciated…

I'm not trippin' out, am I?

Bigbug

matth from what I remember it used to be at the bottom of the client side nav

Now I don't see it 🤷‍♂️

(Maybe I'm hallucinating? 🤣)

johnny

Hey @matth we moved shared links in the client overview section, to reduce some of the side menu barf.

@Bigbug You are not hallucinating we just pulled a fast one hahha

matth

johnny I thought this is where I saw them, but now I don't see them anymore. I created a share link without a contact just to use the link and haven't seen it anywhere.

Just to test my theory, I also created one and sent it to myself, but still didn't see it show up in the client overview.

Bigbug

matth

johnny

Ill take a further look

johnny

Hey @matth I cant seem to replicate the issue. I tried without a contact and with a contact for File, credential and document.

Just to be sure are you on the latest update including database?

matth

johnny Yup, I believe so. Here's my details:

Server Info

PHP version: 8.3.6
Database Version: 10.11.8-MariaDB-0ubuntu0.24.04.1 / 101108
Operating System: Linux itflow 6.8.12-2-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-2 (2024-09-05T10:03Z) x86_64
Web Server: Apache/2.4.58 (Ubuntu)
Apache/PHP Error Log: Debian/Ubuntu default is usually /var/log/apache2/error.log

File System

Total number of files in uploads and its subdirectories: 19
Total size of files in uploads and its subdirectories: 27.93 MB

ITFlow app

App Version: a3a0a3e8c67f0bd33d4c1eb3202d8f5af48af8f7
Cron enabled: 1
App Timezone: America/Chicago

Database Structure Check

Database stats

Number of tables: 99
Total number of fields: 957
Total number of rows: 8670
Current Database Version: 1.6.5

Bigbug

matth this is demo stats. Yours look good to me

Server Info

PHP version: 8.2.25

Database Version: 10.11.6-MariaDB-0+deb12u1 / 101106

Operating System: Linux web.itflow.org 6.1.0-26-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.112-1 (2024-09-30) x86_64

Web Server: Apache/2.4.62 (Debian) mod_fcgid/2.3.9 OpenSSL/3.0.14

Apache/PHP Error Log: Debian/Ubuntu default is usually /var/log/apache2/error.log

File System

Total number of files in uploads and its subdirectories: 423

Total size of files in uploads and its subdirectories: 55.97 MB

ITFlow app

App Version: a3a0a3e8c67f0bd33d4c1eb3202d8f5af48af8f7

Cron enabled: 1

App Timezone: Europe/Rome

Database Structure Check

Database stats

Number of tables: 99

Total number of fields: 957

Total number of rows: 113664

Current Database Version: 1.6.5

matth

As a sanity check, I took this screen recording of creating the share and navigating to the overview: https://data.hodgesvcs.com/recording.mp4

matth

This morning I created some more shares and oddly enough, I now see one of the two shares I created this morning.

However, I can confirm that all of the links I have generated so far work, only one appears to show up here. For further clarity, the files I'm sharing are in nested folders in the Files section.

johnny

I think this my be a timezone thing, where it might not be set on the system but is set in ITFlow

Create a share link then go to the table shared items in phpmyadmin check the fields item created at and item expire at on the newly created share. see if these time match

matth

johnny Is phpmyadmin included with the install of ITFlow or is this something I'd install elsewhere? I tend to not touch SQL tables very often, ha

johnny

its not included in the script, my guess is the created date in set in UTC time, what is your system timezone set to?

matth

johnny

root@itflow:~# timedatectl status | grep "Time zone"

Time zone: America/Chicago (CST, -0600)

ITFlow also has the time zone set to America/Chicago as well via Localization settings.

Bigbug

matth have you restarted your server since it was set?

matth

Bigbug Yup, it's been restarted a handful of times since it was deployed.

Some additional info about my setup:

My ITFlow instance is an Ubuntu 24.04 LXC container running on Proxmox. Used the install script to get it set up, but I think it was before the most recent re-write. Nothing fancy other than that. Timezone on server and ITFlow were both set during setup.

johnny

Just released a significant, long-awaited fix:

itflow-org/itflowc41b391

Issue Summary: While the PHP timezone was correctly set as configured, the MySQL timezone wasn’t synchronized, so fields like created_at, updated_at, and archived_at were defaulting to UTC (UTC-0) instead of the specified timezone (e.g., America/New_York UTC-5). This led to issues in ITFlow where data wouldn’t display correctly until it matched your timezone.

By default, MySQL doesn’t automatically adopt the system timezone, and it defaults to UTC unless explicitly configured.

Resolution: Setting the MySQL and system timezone is now optional. We now rely entirely on the PHP session timezone as configured within the app.

This went unnoticed on our end since our instances on HestiaCP set the SQL timezone to match the selected system timezone by default.

matth

johnny Thanks for this!

Some questions I have:

Does this mean that future shares should work correctly?
What about existing ones?
Is there anything I need to do on my end?