Re: Timestamps are off after 1.6.3 to 1.7.6 upgrade
We upgraded from 1.5.5 to 1.7.6 and I'm also seeing incorrect timestamps, even with new reviews. I verified that our timezone is set to US/Pacific in Review Board general settings. I just created a review at: Tue Mar 26 11:47:57 PDT 2013 and it shows up in Review Board as Tue Mar 26 18:47:57 2013 which looks like UTC. --steve On Wednesday, March 20, 2013 10:15:23 AM UTC-7, David Lee wrote: This morning, I upgraded our ReviewBoard installation from 1.6.3 to 1.7.6, and almost everything went smoothly. The only problem we've had with the upgrade is that the timestamps for pre-upgrade reviews, comments, etc. are wrong. Timestamps for new content are correct. I've set the Time Zone setting in Admin/General Settings, and I've set the timezone for My Account as well. Prior to the upgrade, we also had TIME_ZONE set in settings_local.py. We're using a MySQL database, with a Memcached cache backend, in case that makes a difference. I've poked around on the database, and it looks as though with 1.6, timestamps were being stored in local time, but now in 1.7 timestamps are being stored in UTC. Are there any tools or scripts that someone can point me to for fixing the timestamps in the database? Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- You received this message because you are subscribed to the Google Groups reviewboard group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: Timestamps are off after 1.6.3 to 1.7.6 upgrade
Hey, Was US/Pacific what you had before the upgrade? They should have been stored as PST in that case, and any new times should also then be stored as PST, and shown based on the timezone you have set for yourself in your account settings. Christian On Mar 26, 2013, at 12:03, Steve seide.al...@gmail.com wrote: We upgraded from 1.5.5 to 1.7.6 and I'm also seeing incorrect timestamps, even with new reviews. I verified that our timezone is set to US/Pacific in Review Board general settings. I just created a review at: Tue Mar 26 11:47:57 PDT 2013 and it shows up in Review Board as Tue Mar 26 18:47:57 2013 which looks like UTC. --steve On Wednesday, March 20, 2013 10:15:23 AM UTC-7, David Lee wrote: This morning, I upgraded our ReviewBoard installation from 1.6.3 to 1.7.6, and almost everything went smoothly. The only problem we've had with the upgrade is that the timestamps for pre-upgrade reviews, comments, etc. are wrong. Timestamps for new content are correct. I've set the Time Zone setting in Admin/General Settings, and I've set the timezone for My Account as well. Prior to the upgrade, we also had TIME_ZONE set in settings_local.py. We're using a MySQL database, with a Memcached cache backend, in case that makes a difference. I've poked around on the database, and it looks as though with 1.6, timestamps were being stored in local time, but now in 1.7 timestamps are being stored in UTC. Are there any tools or scripts that someone can point me to for fixing the timestamps in the database? Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- You received this message because you are subscribed to the Google Groups reviewboard group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- You received this message because you are subscribed to the Google Groups reviewboard group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: Timestamps are off after 1.6.3 to 1.7.6 upgrade
On Tuesday, March 26, 2013 12:56:55 PM UTC-7, Christian Hammond wrote: Hey, Was US/Pacific what you had before the upgrade? They should have been stored as PST in that case, and any new times should also then be stored as PST, and shown based on the timezone you have set for yourself in your account settings. That's what I was missing. Our old version 1.5.5 didn't have timezone settings for individual users, so I never set that. I just checked my account in 1.7 and while the server was US/Pacific, my account was UTC. I changed it Pacific and now the timestamps look correct. --Steve Christian On Mar 26, 2013, at 12:03, Steve seide...@gmail.com javascript: wrote: We upgraded from 1.5.5 to 1.7.6 and I'm also seeing incorrect timestamps, even with new reviews. I verified that our timezone is set to US/Pacific in Review Board general settings. I just created a review at: Tue Mar 26 11:47:57 PDT 2013 and it shows up in Review Board as Tue Mar 26 18:47:57 2013 which looks like UTC. --steve On Wednesday, March 20, 2013 10:15:23 AM UTC-7, David Lee wrote: This morning, I upgraded our ReviewBoard installation from 1.6.3 to 1.7.6, and almost everything went smoothly. The only problem we've had with the upgrade is that the timestamps for pre-upgrade reviews, comments, etc. are wrong. Timestamps for new content are correct. I've set the Time Zone setting in Admin/General Settings, and I've set the timezone for My Account as well. Prior to the upgrade, we also had TIME_ZONE set in settings_local.py. We're using a MySQL database, with a Memcached cache backend, in case that makes a difference. I've poked around on the database, and it looks as though with 1.6, timestamps were being stored in local time, but now in 1.7 timestamps are being stored in UTC. Are there any tools or scripts that someone can point me to for fixing the timestamps in the database? Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard...@googlegroups.com javascript: For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- You received this message because you are subscribed to the Google Groups reviewboard group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com javascript:. For more options, visit https://groups.google.com/groups/opt_out. -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- You received this message because you are subscribed to the Google Groups reviewboard group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Timestamps are off after 1.6.3 to 1.7.6 upgrade
This morning, I upgraded our ReviewBoard installation from 1.6.3 to 1.7.6, and almost everything went smoothly. The only problem we've had with the upgrade is that the timestamps for pre-upgrade reviews, comments, etc. are wrong. Timestamps for new content are correct. I've set the Time Zone setting in Admin/General Settings, and I've set the timezone for My Account as well. Prior to the upgrade, we also had TIME_ZONE set in settings_local.py. We're using a MySQL database, with a Memcached cache backend, in case that makes a difference. I've poked around on the database, and it looks as though with 1.6, timestamps were being stored in local time, but now in 1.7 timestamps are being stored in UTC. Are there any tools or scripts that someone can point me to for fixing the timestamps in the database? Thanks! -- David M. Lee Digium, Inc. | Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: www.digium.com www.asterisk.org -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en --- You received this message because you are subscribed to the Google Groups reviewboard group. To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.