Confusing timestamp issues

[mariposa]

I'm not sure how long this has been going on. It may be a problem that recently surfaced or it might be something that's always happened and I never noticed. Anyway! In both the web interface and Android client, when I send a message to a channel/query, the timestamp is always UTC. When I receive a message, it's the timezone the system running Tiny Tiny IRC is configured to use. I looked through the code and only found one reference to timezones, in include/db-prefs.php, where it's talking about a USER_TIMEZONE preference, but that doesn't seem to actually do anything. Is there something that I'm missing where the timezone for the user is determined?

Thanks!

[fox]

I don't remember how this works exactly but I don't think tt-irc does any timezone conversion. It should use whatever you have configured in php.ini / database.

The code mentions might be because I pulled some stuff from tt-rss when I started working on tt-irc which actually supports timezones properly.

e: insert into ttirc_messages uses NOW() as timestamp so client/android time shouldn't factor into it I think. I didn't notice anything like that either.

[mariposa]

Any idea why the timestamp for me sending a message would be a different timezone than the one when I receive a message? I have the timezone set in php.ini, but maybe something is wrong there. I guess all messages received are received through the Java backend, not touching PHP at all, right? So maybe it is a PHP misconfiguration issue... weird.

ETA: I've checked and double-checked the date.timezone setting in php.ini. It's set to America/Chicago and that's also what's reflected in phpinfo(), so I really have no idea where the different timezone is coming from.

[mariposa]

I FIXED IT! It wasn't PHP or Tiny Tiny IRC at all. Somehow the timezone was set to UTC with PostgreSQL. I've never noticed that before, especially since it's different than the system timezone.

[fox]

Yeah I guess this is entirely dependent on the database configuration. Sorry if my post was misleading.

[mariposa]

It wasn't misleading at all. When you pointed out that the inserts use NOW(), it made me think about the database configuration. So that actually led me right where I needed to go.