Created loop in Feeds

emonSD
1

Hi. Some time ago I created a virtual feed which I believe may have caused a loop. The general system has kept working but I cannot get the Setup/Feed page to be displayed so I can edit it - all I get is the spinning wheel. I cannot navigate to any other part of the site. I am still running 9.8.28 from emonSD on a RaspberryPi.

Is there a way I can manually edit the Feed configuration from the SSH console?

Many thanks and I promise to upgrade to the latest version when I have got this working again. :slight_smile:

Jonno

2

In an effort to move on, I have upgraded to the latest version (10.2.0) which went very smoothly. Unfortunately, I still have the same problem.

Is there a way to edit the Feed configuration when the user interface doesn’t work? If there isn’t I’d appreciate confirmation of that.

Jonno

3

Sorry, but it appears that the people who can answer you haven’t noticed your question.

@TrystanLea is probable the most knowledgeable on this matter.

4

Bump.

I have tried to use phpmyadmin but have been unable to find all the config details to let me log into the database to manually edit it. If anyone knows how I should configure phpmyadmin and lets me know I would be very grateful.

5

You can delete a Feed via the API IIRC.

However, the processing is done on the Input page is it not (never played with Virtual Feeds) so the Input API may be more relevant.

image
image1071×626 35.2 KB

Or the Feed/Virtual Feed API

image
image1116×387 18.5 KB

No need for an API key if you are doing it from the same browser instance you are actually logged into the UI with.

6

Sorry for appearing rude by not responding. I thought I replied in early March but I must have failed to press the ‘post’.

Finally, all fixed now thanks but I could not fix it from the API. Strangely, there was a virtual feed there that I did enter (just to add all the power used from two other feeds) but the API for Id=11 claimed it did not exist. It was only when I loaded phpmyadin that I could see it and then delete it.

Phpmyadmin was a struggle to use and I had to manually edit /etc/phpmyadmin/config.inc.php Cfg table_uiprefs to be pma__table

Jonno