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 <[email protected]> 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 > [email protected] > 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 [email protected]. > 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 [email protected] 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
