I want to upgrade from ver 1.13.0 to the current 2.2.2.
What are the exact steps ?

I want to upgrade from ver 1.13.0 to the current 2.2.2.
What are the exact steps ?

@phildunlap said:

On my instance of Mango that chart is still rendered in server time as the default (i.e. my user preference is "use server time").

This can be manually set on a user by user basis to a specific timezone on the user details page, if you're certain the problem isn't the configuration of the timezone on the linux box.

where do you set the user preference "use server time" - i cant find this on my instance of mango (1.13.0)

@phildunlap said:

You are referring to which: charts in DGLux, reports, graphics views, mouse overs, data point page, etc?

the one on data_point_details.shtm

The timezone applied on the chart object is correct (uses local time), however watchlist or history seem to be GMT. How do i sort this ?

Note : my linux server timezone is correctly set to IST (local timezone)

The timezone applied on the chart object is correct (uses local time), however watchlist or history seem to be GMT. How do i sort this ?

Note : my linux server timezone is correctly set to IST (local timezone)

The pointValues table has grown huge on mysql. How can i partition it to improve overall performance ?

The pointValues table has grown huge on mysql. How can i partition it to improve overall performance ?

@phildunlap said:

values.push(sens.prev(MINUTE, 1).firstValue)

...
values.push(sens.prev(MINUTE, n).firstValue)

thanks, this seems exactly what i need.

one other request, where do i find documentation on what you have described above e.g. prev(MINUTE,1).firstvalue - what other functions etc are there which could be used ?

@phildunlap said:

The best way to do this is with a meta point. Write the code necessary to get all your points into an array, here's some code I stole:

values.push(sens1.value)
...
values.push(sensN.value)

Hope that helps.

Thanks for the quick response, a clarification please :-

sens1.value 
.... 
sensN.value 

wont this be value of n different points, i need to get the last n values of the same point into the array, how can i do that ?