Local time vs Mysql time causing publishDate issue

Mon, 18 Jan 2021 16:16:25 -0800

I just updated 2 sites running V3.54 and their new error log records now display the correct time stamp

Woohoo...

Thank you Dave, as always!

Jerry Kornbluth

Local time vs Mysql time causing publishDate issue

Mon, 18 Jan 2021 15:40:28 -0800

Hi All,

We've fixed this bug for the next release. Here's some instructions if you want to manually patch your current version:

Backup /lib/database_functions.php
Edit /lib/database_functions.php and search for mysqli($mysqli)
Add the code in red:

mysqli($mysqli); // save object on successful connection

// set connected flag
mysql_isConnected(true);

Let me know if that doesn't resolve the issue for you or if you need anything else.

Thanks!

Local time vs Mysql time causing publishDate issue

Fri, 08 Jan 2021 04:26:59 -0800

Same.

Local time vs Mysql time causing publishDate issue

Thu, 07 Jan 2021 08:56:59 -0800

Confirming that my installation, which is having this issues, is 3.54

Local time vs Mysql time causing publishDate issue

Thu, 07 Jan 2021 08:50:44 -0800

Just to clarify, this is only a CMSB 3.5.4 issue, and not a 3.5.0 issue and below.

Local time vs Mysql time causing publishDate issue

Thu, 07 Jan 2021 00:15:58 -0800

I'm seeing the same issue. Luckily nothing we post is strictly time dependent, but obviously it's not ideal if the system can't adjust correctly to a set time or daylight saving times. Changing the server time is not something we have control over, so it needs to be fixable via CMSB.

Local time vs Mysql time causing publishDate issue

Mon, 21 Dec 2020 13:13:43 -0800

Upon further research, it turns out that the above solution does not actually change the current timezone, if your MySQL is using the "SYSTEM" timezone. Unfortunately, this is very likely the case.

The next step in changing this would be to change it via your server's time, but this option varies based on your host's control panel. What control panel do you use for your hosting?

If it is cPanel, you can find instructions on how to change your server time here (https://docs.cpanel.net/whm/server-configuration/server-time/).

Local time vs Mysql time causing publishDate issue

Mon, 21 Dec 2020 12:55:56 -0800

Hello, I'll be looking over this issue.

Feel free to look over at lib/database_functions.php and find the setMySqlTimezone($timeZone) at around line 213, and you can manually set the timezone from there.

The format in coding is +00:00 where +00 equals the number of timezones to the left/right of the GMT. Based on your original post, you would have it as -05:00.

Local time vs Mysql time causing publishDate issue

Thu, 17 Dec 2020 13:35:28 -0800

Any thoughts on this?

Local time vs Mysql time causing publishDate issue

Thu, 10 Dec 2020 11:31:56 -0800

To add onto this, I think a similar issue is causing problems in the Developer Log (3.54). It is saying errors are happening "In the future" instead of "XX seconds ago" or something similar.

Local time vs Mysql time causing publishDate issue

Wed, 09 Dec 2020 11:26:22 -0800

I recently updated a site to v 3.54 and I am experiencing a problem with publishDates which seems to stem the timezone setting in General Settings. I have the timezone set to my local timezone, which then displays local time and mysql time to be 2 hours apart (see attachment). This leads to items using the publishDate field to not appear on the site until 2 hours after intended.