Dashboards - no data visible after upgrading to 9.7.2 (Solved)

Emoncms
1

I am running self hosted 7.7.2 on a Pi3 Jessie. Fresh start from emonSD-03may16 image.

I upgraded from 8.4.

In 8.4 I ran convert data to change from phpfiwa to phpfina. I then used the backup script to create a tar.gz file.

I ran import backup into 9.7.2 and I have all my inputs and feeds updating.

However when I went to the dashboards nothing is showing. I therefore went direct to feeds and clicked the eye icon. The result is an error message:-

Request error {“success”:false,“message”:“Error reading meta data feedid=1”}

What can I do to resolve this?

Regards

Ian

Log File:-

2016-08-10 09:17:28.134|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/56.meta'
2016-08-10 09:17:28.134|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=56
2016-08-10 09:17:28.134|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/56.meta'
2016-08-10 09:17:28.134|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=56
2016-08-10 09:17:28.135|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/56.meta'
2016-08-10 09:17:28.135|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=56
2016-08-10 09:17:28.135|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/56.meta'
2016-08-10 09:17:28.135|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=56
2016-08-10 09:17:28.135|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/56.meta'
2016-08-10 09:17:28.135|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=56
2016-08-10 09:17:28.136|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/56.meta'
2016-08-10 09:17:28.136|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=56
2016-08-10 09:17:57.754|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/10.meta'
2016-08-10 09:17:57.759|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/9.meta'
2016-08-10 09:18:07.157|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/46.meta'
2016-08-10 09:18:07.227|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/39.meta'
2016-08-10 09:18:19.393|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/46.meta'
2016-08-10 09:18:19.494|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/39.meta'
2016-08-10 09:18:28.138|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/1.meta'
2016-08-10 09:18:28.138|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=1
2016-08-10 09:18:28.140|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/2.meta'
2016-08-10 09:18:28.140|WARN|PHPFina.php|post_bulk_prepare() failed to fetch meta feedid=2
2016-08-10 09:18:28.142|WARN|PHPFina.php|get_meta() meta file does not exist '/home/pi/data/phpfina/9.meta'
2

Hi Ian
have you checked the permissions/ownership for the feed folders and files? when converting, restoring back-ups or general housekeeping the owner/group can get altered.

If the feeds page is updating it would look like the SQL part is ok, just the php files are not found/accessible.

With a jump from 9.4 to 9.7+ you may well need to reattach your feeds on your dashboards as the feeds are all ID’d by feedid now not by name as they once were. I can’t remember when exactly but I think it was post 9.4.

3

Hi Paul

The owner of phpfina and phptimeseries directories is www-data. Permissions rwxr-xr-x

I created one new feed and that is working with a dashboard. However your question caused me to look in the in the phpfina directory and the only 2 files there are my new feed. So the problem appears to be either the backup routine from the old setup or the import routine into the new. Some where the phpfina files have gone AWOL. Will investigate.

Checked already. No phpfina files in the exported tar.gz file

Ian

4

OK

Sorted. Directory path issue in the export script. My old setup had 2 mysql data directories. The script pointed to an out of date setup that had all the correct information in the mysql database but no phpfina data. Changed to the correct data directory where there was the correct mysql database AND the phpfina and phptimeseries files.

Ian

1 Like
5

Hi Ian,

It was in settings.php only?
I solved it changing path in settings.php
Thanx!