-
Notifications
You must be signed in to change notification settings - Fork 24
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Activity Stream times are not adjusted for GMT #147
Comments
Not fixed by Leo - wasn't fixed and reverted. |
Please do some analysis, the calls should all be in UTC, we need more information on time correction for local or profile based time zone that occurs in the templates. |
|
@ll911 any chance we can change that parameter in cad? It seems like it might be actually a better setting anyways. |
@kfishwick Which parm? |
Change the /etc/sysconfig/clock to ZONE="UTC" |
@kfishwick No, this is root manage system value, should not be changed and should match our current timezone |
@kfishwick @jrods does this have correct time shift
|
Is this related to ckan/ckan#2882 |
@kfishwick looks like a problem for a while |
@ll911 are you also doing something like this on the server?
|
Nope, root managed system cannot be changed as they will be overwritten by HPAS patching cycle.
|
@ll911 ok, so just an overview so i can match my env, on the server, Are those the only settings I need for time on the server? Is there any other changes I need to make for my env to match the server? |
@jrods you need to set both system clock and localtime with PST
|
@ll911 ok, but how did you specifically changed |
@jrods link to
|
@ll911 what is the db's set timezone? |
Postgresql calls system time, which should be PST, but it can all set by application during the RUNTIME |
From my analysis, this looks to be a ckan core issue with many ckan/ckan#2970 is pretty much the exact same problem. I'll ask around to see if anybody is working on it for core. |
Recommend deferring to the next release, this could be 2-3 days of work (if it affects more than just activity stream, and to coordinate the strategy for fixing it) and should be integrated into ckan core (and can likely be backported to 1.5 since it is a bug). |
bcgov/ckanext-bcgov#147 ckan#2882 ckan#2970 The Activity model now stores its timestamp in utc In Formatters, localized_nice_date, removed the datetime replace method calls with actually ensuring the comparing timestamps have a timezone specified
I've made PR for activity times above. Note that this does not fix activity times that already have a stored timestamp. I'm not sure on the approach to fixing that. I'm inclined to just leave old timestamps, as they don't seem like they're very crucial (but this isn't my call) |
Getting a server error on delivery when trying to access activity stream. |
Maybe we should push this back to 1.6 since so far it looks like this is the only hold up. Though it's already been merged (after we deployed to cat). Can we roll this change, which isn't working, back? |
whoops, typo, fixed here: bcgov/ckan#7 |
Don't think this deployed to cad, I think only merges to ckanext-bcgov auto deploy. |
bcgov/ckanext-bcgov#147 ckan#2882 ckan#2970 The Activity model now stores its timestamp in utc In Formatters, localized_nice_date, removed the datetime replace method calls with actually ensuring the comparing timestamps have a timezone specified fixing typo
Getting internal server error when viewing Activity Stream in cad. |
@ll911 will you please merge in the above PR and deploy ckan with those changes to delivery? |
done
|
Seems to work in CAD, assigning over to Matt for verification. |
bcgov/ckanext-bcgov#147 #2882 #2970 The Activity model now stores its timestamp in utc In Formatters, localized_nice_date, removed the datetime replace method calls with actually ensuring the comparing timestamps have a timezone specified fixing typo
bcgov/ckanext-bcgov#147 #2882 #2970 The Activity model now stores its timestamp in utc In Formatters, localized_nice_date, removed the datetime replace method calls with actually ensuring the comparing timestamps have a timezone specified fixing typo
In the activity streams edits that have just been made are showing they were edited '7 hours ago'. I believe was due to the time being set to GMT, and Leo had fixed this with a patch in Cad -- but it looks like his changes have been overwritten by the most recent deploy.
Modify a record and view https://catalogue.data.gov.bc.ca/dataset/activity/[datasetname] to see an example.
The text was updated successfully, but these errors were encountered: