Archived Forum

Same issue here, installation went ok, log in ok.

Testing a dashboard only works on the tab "Dashboards", After saving, i can see my working result below the editor window, but after leaving the page, it's gone.

Also the "-" button to (i presume) remove the dashboard, does not work. Creating new (empty) ones works however.

When previewing the empty dashboard, i see that it opens a new window, and the following URL is generated:

http://myhost/Vis/Dashboard/embed.php?apikey=&id=

I don't think this is right, somehow the api key and id are not used.

EDIT:

Resetting my local master branch to the 3rd of May fixed the problem for me, ofcourse this also removed the option to edit multiple dashboards.  Can anyone confirm this?

I've had my first play with emoncms today, and I'm seeing pretty much the same behavior. Saving doesn't save and preview opens an empty window.

is it only the 3. of us having this problem ?

Hi, Your not alone I have same issue and had to make changes directly in database. 

http://openenergymonitor.org/emon/node/638

Cheers

I'm also having problems with the new dashboard.  It striped out my display of values, and I don't seem to be able to create new dashboards. (Download from github master last night).

 Lloyd

Hello, sorry about this, I think it was a missing couple of lines in setup.php. I've updated it, it should work now.

Trystan

Just got this when running the new setup.php:

ALTER TABLE `dashboard` ADD `id` int NOT NULL AUTO_INCREMENT, PRIMARY KEY(id,userid)You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIMARY KEY(id,userid)' at line 1ALTER TABLE `dashboard` ADD `name` VARCHAR(30) DEFAULT 'no name'ALTER TABLE `dashboard` ADD `description` VARCHAR(255) DEFAULT 'no description'

Does userid exist when you try and create a primary key of it?

Lloyd

I'm getting the same error as Lloyd. Still unable to save/preview/delete dashboards.

Ok, i will try a fresh install, to see if its working.

I think setup.php should look like this:

Just tried it out, with no luck.

I can add a new dashboard, go to edit - everything looks OK, but then when i add or change anything i cant save, if i only add txt then i can save, when ever i try to add dials or container i cant. ... ? strange

When ever it goes wrong, i have to delete the dashboard and start over.

Working better for me now that I have succeeded in running setup with no errors, but have no more time to experiment tonight.  Do seem to be able to create new dashboard with a dial on it, save it and then return to it.  Are you sure you have all the latest updates from github? 

Lloyd

Just tested it again here to be sure and setup ran with no problems and I can create, save and preview multiple dashboards.

What fixed it for you Lloyd, I think PRIMARY KEY() without the add is ok: http://dev.mysql.com/doc/refman/5.1/en/create-table.html. It has also succeeded in creating a primary key for both id and userid

I pasted the failed sql into phpadmin, and it failed unless I added the ADD. Is the add required because it is doing an ALTER rather than CREATE?

Lloyd

Hi

if you had a created database the better way to upgrade is call

your_url/Includes/upgrade.php

so the alter table is executed and all is ok. Then you should not go to Dashboard menu directly, you have to go Dashboards menu and add new dashboard and edit it from there. The Dashboard button is there due compatibility.

I will do a fresh install and test setup instead.

Best regads

ilde

Dear Larsjo

Did you try to add widget container and insert into a dial?... i detected that dial without/outside container doesnt work

Could you send us the html code generated?

Best regards

ilde

did that, and you are right dial outside container dont work. But thats ok because it looks better with container.

I am building the code 1 step at a time, to see where it goes wrong. And it looks like it maybe is when i add multi or kwhzoom part.

______________________________________________________________

Dear Larsjo

i follow these steps

• create a new database
• http://localhost/emoncms3/setup.php
• http://localhost/emoncms3/Include/upgrade.php (blank screen shown with no error)
• register a new user on emoncms3
• a dashboard editor is shown but is a fake... no dashboard created yet
• go to dashboards menu
• create a new dashboard from Dashboards menu
• edit Dashboard
• paste your code in html format
• save

it worked fine for me....

Let me know news about this :-)

We should think about hide the Dashboard menu so not go directly without pass go through Dasboards menu.

Best regards

ilde

did just that. so that should be ok

Did you add the multi or kwhdzoom ? And got it to work.

this is what happen.

if i make a dial, its works

if i make some kind of error (feed, path... anything), and save. After that i cant save anymore, and i have to delete the dashboard, make a new, past back the code (with changes) it can save again until i make a new error in the code.

The only way to see that the SAVE don't work is bye shifting between pages, and when you return back to the editor the last changes are lost. It did not save it.

Hope this helps to solve the problem.

Try going to dashboards and choose dashboard you want to edit, then edit and save. Worked for me.

Seems to be working better for me, but I did delete my original database and start from scratch. I can now save and preview editing dashboards, still can't delete dashboards.

I don't seems to have any trouble getting dials working, but I can't get the default  energy explorer to work at all

http://openenergymonitor.org/emon/applications/homeenergy

If you enter the full url with your apikey in a browser, what error message do you get back?  Beware that the capitalisation in the url can catch you out.

Lloyd

Notice: Undefined index: power in C:\xampp\htdocs\emoncms3\Vis\kWhdZoomer\kwhdzoomer.php on line 16

Notice: Undefined index: kwhd in C:\xampp\htdocs\emoncms3\Vis\kWhdZoomer\kwhdzoomer.php on line 17

Notice: Undefined index: currency in C:\xampp\htdocs\emoncms3\Vis\kWhdZoomer\kwhdzoomer.php on line 19

Notice: Undefined index: pricekwh in C:\xampp\htdocs\emoncms3\Vis\kWhdZoomer\kwhdzoomer.php on line 20

That looks strange. For completeness can you post here the url you are using (blank out the apikey).

Lloyd

second attempt, spam filter didn't like it first time

http://192.168.1.70/emoncms     3/Vis/kWhdZoomer/kwhdzoomer.php?%0Aapikey=*********&kwhd=powerKwhd&power=power&currency=%C2%A3&pricekwh=0.18

You need to specify the feed by number.  And do you really have &amp, or is this just the way it has pasted.  Here's mine

..........co.uk/emoncms3/Vis/kWhdZoomer/kwhdzoomer.php?power=3&kwhd=8&price=0.14&apikey=xxxxxxxxxxx

Lloyd

Look like it was just the feed numbers throwing things out. Thanks for that.

Just updated the vis.openenergymonitor server with the latest version and got the mysql error to do with the missing ADD, had to add it in to make it work. Maybe its to do with updating an existing field and so the error does not appear when creating a new database from scratch..