Hello,
What could be the possible couse of the x-axis not displaying correctly. it ends exactly 2 hours before the last input in the database, however the graph is shown correctly. The time is formatted like this in the database 2011-08-30 20:58:58
Other question is did anybody get the script working when using ie as browser?
greetz
Jasper
Re: x-axis 2 hours off
I think you need timezone shift
Re: x-axis 2 hours off
Ok, i also think this is a timezone issue, but som other scripts on the same server wich also read / write to mysql don't need a timezone shift.
- The database timezone is ok, becouse the entry's in the database are ok.
Only the visualisation axis isn't displayed correctly..
anyone??
Re: x-axis 2 hours off
Ive also got the X-axis timezsone problem : its out by -1 hour from GMT,
Database timezone PHP.INI has been set and records correctly, but the visualisation is out.
Glyn - is there a setting as per your suggestion for timezone shift? Couldnt immediately spot it.
Re: x-axis 2 hours off
There isnt a setting to correct the timezone shift at the moment Im afraid. The issue here is that the graphs are javascript based and get the time from the local machine while the emoncms server side of things gets its time from the server time, both should be GMT +0. Will have to think about how best to fix this.
Re: x-axis 2 hours off
Ok, I found a mod that can be added to the flot library to fix the problem, I found it here: http://code.google.com/p/flot/issues/detail?id=141, It works for me my graph now shows the correct time for the first time since I wrote the application :)
Please download the latest emoncms2 version from github and let me know if it work for you.
Re: x-axis 2 hours off
Trystan - thanks - the graph is now reading my timezone, GMT.
I'll keep an eye on things.