V9.2: Datatype Daily and Histogram are not working

Submitted by emon24 on Mon, 07/12/2015 - 10:39

Hi all, I'm using OpenEnergyMonitor for logging a ferraris electricity meter. Therefore I build a small IR Sensor. This is alright so far. I used it on emoncms V8.5 already some time. Now I updated to V9.2. During installation I had some problems, so I deleted everything except the database and installed new.

I was able to get V9.2 to run, and it logs normal "Realtime" values. This is ok. But I also want to log Histogram and Daily kWh numbers. I'm able to create the feeds, but they are not filled. It tells me Updated: "n/a". I tried all the different database types like phpfina, phpfiwa, phptimestamp and mysqltimestamp.

My system is a local ubuntu server.

Do you know what I'm doing wrong?

thank you very much!

Chris

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by Paul Reed on Mon, 07/12/2015 - 11:04.

If you run 'Developer Tools' in your browser(F12) are there any errors

Paul

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by emon24 on Mon, 07/12/2015 - 12:16.

Hi Paul,

thanks for your reply. I tryed Developer Tools on different pages, but it seems like there are only thousand warnings but no errors.

Chris

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by emon24 on Tue, 08/12/2015 - 09:13.

Hi,

I continued to try around. The strange thing is, the Daly and Histogram feeds can be feeded by API:

http://server/emoncms/feed/update.json?id=23&time=UNIXTIME&value=100.0

But they don't do automatic like I want them with "Input".

Does nobody know what's wrong there?

I attached two pictures of my setting.

Chris

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by chaveiro on Tue, 08/12/2015 - 23:16.

Hi, post the log just after an input post to that input.

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by emon24 on Wed, 09/12/2015 - 11:58.

Hi chaveiro,

the log looks like:

2015-12-09 11:44:27.721:INFO:feed_model.php:insert_data() feedid=23 updatetime=1449661467 feedtime=UNIXTIME value=100.0 arg=

2015-12-09 11:44:27.721:INFO:feed_model.php:EngineClass() Autoloaded new instance of 'MysqlTimeseries'.

This data is written in the database, only the "automatic" values from the input are not saved. Those "not working" Feeds are not in the log file, except I'm feeding it with the api.

Chris

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by chaveiro on Wed, 09/12/2015 - 12:01.

This bold part seems wrong, it should be a value, are you defining a time like that on the input post?

2015-12-09 11:44:27.721:INFO:feed_model.php:insert_data() feedid=23 updatetime=1449661467 feedtime=UNIXTIME value=100.0 arg=

Re: V9.2: Datatype Daily and Histogram are not working

Submitted by emon24 on Wed, 09/12/2015 - 12:05.

this was my mistake, I called this url:

http://server1/emoncms/feed/insert.json?id=23&time=UNIXTIME&value=100.0

I told him "UNIXTIME" instead of the real unixtime, but it seems the api takes the actual time if time is not correct.

Chris

Archived Forum