Re: Migrating Bugzilla between different time zones - problem
glauber ribeiro <[email protected]>
| Newsgroups | gmane.comp.mozilla.devel.webtools |
|---|---|
| Message-ID | <[email protected]> |
Correction (sorry): old system is 4.2.3; new system is 5.0.6 glauber On Wednesday, September 30, 2020 at 1:01:41 PM UTC-5, glauber ribeiro wrote: > Hello, > > I have a time zone problem, which i hope isn't too hard to fix. Here's my situation: > > I am migrating a Bugzilla 4.2.3 setup where the OS and MySQL database is running on the 'America/Chicago' timezone. To simplify, let's say it's GMT minus 5. > > The destination system will be Bugzilla 4.2.3 and there, the OS and MySQL database are running on UTC. > > So here's what happens: i dump the MySQL data on the source system, and load it into the destination system. The time stamps on the database seem to be "naked" (no Time Zone) and they are in Chicago time. I run checksetup,pl to convert the database to the new format. This doesn't seem to affect the dates on the database. > > But then, when i run Bugzilla on this new database, all dates appear 5 hours off. For example, stuff that happened at 8AM Chicago time, displays as 3AM Chicago time. New records have correct times, it's only the pre-existing ones that are wrong. > > Bugzilla seems to be assuming that the times in the database are on UTC, but they are on Chicago Time. So it converts from UTC to Chicago Time, by subtracting the proper offset. > > What am i missing? I don't think there is a way to convert the times to UTC when dumping or load the MySQL data (but if there is and you know it, i would love to know). Is there a Bugzilla parameter that i'm missing, which tells Bugzilla what time zone is used in the database? > > Many thanks, > > glauber _______________________________________________ support-bugzilla mailing list [email protected] https://lists.mozilla.org/listinfo/support-bugzilla PLEASE put [email protected] in the To: field when you reply.