Archived Forum

I have the same problem, the bar indicates the kWh/d value of today with the previous day. But when I clik on the bar, I see the rawdata power of the correct day, and in this visualition the day begins/ends at 02:00AM, but the feedvalue kWh/day resets at 24:00. Here can your see the graph

http://rjcasa.dyndns-home.com:81/emoncms/rjcms/grafici

any help  

thanks

Older daily feeds which are processed by the SQL engine are fine it is any new daily feeds which are processed by PHPFINA which are wrong. can't change back to SQL I don't think

Can't see the graphs. You need to make your feeds public by cliking the padlock icon on the feeds page.

Hi webby, the feed are pubblic, but I have a very slow adsl (max 240kbit upload) and the graph don't display.

sounds like it could be a timezone issue.  Can you both list the operating system your Emoncms is running on, what version of emoncms you are running and the timezones you have setup  (both in the OS and in php.ini).

Hi ukmoose, I have emoncms 8.1.1, raspeberry+HDD installed with this guide from paul (ph66) http://openenergymonitor.org/emon/node/4908, my timezone is  set CEST (comand date = Sun Apr 20 22:46:55 CEST 2014) changed with raspi-config.  In which directory find php.ini and what I change.

ok i change php.ini file timezone "Europe/Rome" ( http://emoncms.org/site/docs/installlinux), but the issue remains.

At 24:00 CEST all kWh/day feeds are reset to 0, and the graph shows a new day 20 april, but now is 21 april (see print screen)  

thanks ukmoose, regards leonardo

OK I know nothing about changing time zone in php.ini Everything worked fine with SQL and still does its is just new feeds that use PHP. Is their some instruction for doing this somewhere on the site?

I am using Emoncms.org. Is it necessary to update my RPi to work with 8.0.9?

Hi, I have the same problem with PHPFina feeds (MySQL feeds are ok). I verified it's not a visualisation bug (data stored is already one day off). I'm using 8.0.9 as well in the "Europe/Brussels" timezone. The timezone in php.ini is commented out.

OK so therefore the problem is within Emons.cms not in the RPi?

I have found an issue with the update operator in phpfina.php that explains why daily phpfina feeds are off 1 day. I have opened an issue on github (see https://github.com/emoncms/emoncms/issues/199).

I cannot believe that nobody else is getting this problem? Can it really be specific to you and I?

Webby,

I noticed somethig similar on my emoncms.org account. (v8.0.9) The only difference is that I see the same issue with kWh to kWh/Day. Power to kWh/Day works OK for me.

My local emoncms (v8.1.2, from git) works fine with either one.

Regards,

Bill

Both are logging one day in arrears for me in Emoncms. I don't have a local system as yet

Most of my feeds emoncms.org where set up sometime ago and are DAILY SQL and performing correctly. However I have now created a couple of DAILY PHPINA feeds and can confirm "min daily" "max daily" and "power to kwh/d" are all logging one day behind .

On local emoncms running v8.1.2 (from apt) everything appears ok with the same DAILY PHPINA type feeds.

So for me the issue only exists with DAILY PHPINA on emoncms.org  v8.0.9.

Bill, is  your Power to kWh/Day a DAILY PHPINA or DAILY SQL ?

Paul

Paul,

My power to kWh/Day feed is PHPINA.

Yes My SQL feeds working fine only prob is with PHPINA

I talked to Trystan about this today and it's seems to be a timezone related problem. My daily feeds (sql/phpfina) are logged each day @ 10pm (eg timestamp 1398204000). According to Trystan, this should be midnight.

When looking at the update operator in PHPFina.php, I noticed on line 135 that the timestamp is updated using floor(timestamp/interval)*interval but the interval value for daily feeds corresponds to 86400s or 24h which makes that the timestamp is always 1 day in the past. The sql engine does not do this.

I added a ceil operator in case the interval was 86400 (ie daily feed), and that solved the issue, but it's not the correct solution.

I have written to Trystan and Glyn about this but no answer. Is he going to look at it?

I am getting this also.  Was there ever a good solution for this?

[Duplicate post deleted by Moderator (RW)]

Is this not part of the general timezone problem that was reported here ?

I think this issue is independent of the recent "DST" issue although possibly still a timezone based issue this issue involves some visualizations being out by one day for phpfina feeds, there is a github issue open on this.

This issue is there permanently rolling over for each day, where as the "DST" issue was localized to the clocks going back on the 26th of Oct causing an 1 hour overlap.

Paul

Edit : And the issue with this comment is the word issue being issued too many times within 1 post :-)

I don't think its timezone related.  Its the middle of the day, so all timezones are in the 29th but its still adding data for the 28th.