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.