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.


Reply via email to