Continuing the discussion from Can't login on localhost after updating emonpi to v9.8.27 : Just pulled the master off emoncms GitHub and now I am getting the “Database error, you may need to run database update” message. The solution on the linked page does not work for me as this is a self hosted …

The solution was to copy the ‘emoncmsdbupdate.php’ text into a file (in the home directory), make it executeable and run it. [image] Updating the database Emoncms If you are running an emonpi you could try php /home/pi/emonpi/emoncmsdbupdate.php This how the emonpi upda…

This just gets better… [loginerror] I haven’t got time to try the fix yet @borpin but users shouldn’t really have to mess about like this following an update to 9.8.29. Paul

Hello @Paul , Have you tried updating the database following either @borpin ’s approach or the one I documented?

There’s not really an easy way around requiring a database update after certain emoncms updates unfortunately, especially after we moved to prepared mysql queries to improve security which require explicit statement of the query fields…

Just got home, downloaded and ran emoncmsdbupdate.php which updated the database, and got me access OK. If all users of self-builds are expected to have to run this script to update their database, wouldn’t it make sense to include the script (as an executable file) in the emoncms repo, probably wi…

[image] TrystanLea: There’s not really an easy way around requiring a database update after certain emoncms updates Is there anyway to detect that an update has been done and if it has, emoncms can decide to run a dbupdate? Actually, thinking about it, if the system knows it needs to run a d…

Hi, ran into the same error (after illegal shutdown) . Copied emoncmsdbupdate.php to a file in home/pi$ made it executable : sudo chmod +x emoncmsdbupdate.php run with: ./emoncmsdbupdate.php and getting al kinds off errors: ./emoncmsdbupdate.php ./emoncmsdbupdate.php: line 1: ?php: No such …

Ah, emoncmsdbupdate.php is not a shell script. If you try running with php it should work, e.g: php emoncmsdbupdate.php

Thanks !!! that did it. Stupid me. i already did read that somewhere but forgot.

Community

OpenEnergyMonitor

OpenEnergyMonitor Community

Cannot login after updating to 9.8.29 (master branch)

Emoncms