Integration to home assistant input feed breaks after update to alpine3.20_emoncms11.9.10

[TCWORLD]

I've updated to the latest version of the integration, but unfortunately add on no longer works.

In emoncms, all the feeds show as not having updated since the upgrade.

If I go to the Input tab, it just sits there with a spinny loading icon:

Looking in the logs in home assistant, I see the following error each time home assistant tries to update the feed:

[php:error] [pid 136:tid 136] [client 172.30.32.1:51816] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'ip' in 'SELECT' in /var/www/emoncms/Modules/device/device_model.php:273\nStack trace:\n#0 /var/www/emoncms/Modules/device/device_model.php(273): mysqli->query()\n#1 /var/www/emoncms/Modules/device/device_model.php(235): Device->load_list_to_redis()\n#2 /var/www/emoncms/Modules/device/device_model.php(225): Device->get_list_redis()\n#3 /var/www/emoncms/Modules/device/device_controller.php(65): Device->get_list()\n#4 /var/www/emoncms/core.php(81): device_controller()\n#5 /var/www/emoncms/index.php(257): controller()\n#6 {main}\n  thrown in /var/www/emoncms/Modules/device/device_model.php on line 273, referer: ...

[php:error] [pid 138:tid 138] [client 172.30.32.1:33016] PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'ip' in 'SELECT' in /var/www/emoncms/Modules/device/device_model.php:292\nStack trace:\n#0 /var/www/emoncms/Modules/device/device_model.php(292): mysqli->query()\n#1 /var/www/emoncms/Modules/device/device_model.php(97): Device->load_device_to_redis()\n#2 /var/www/emoncms/Modules/device/device_model.php(478): Device->exist()\n#3 /var/www/emoncms/Modules/input/input_methods.php(330): Device->set_fields()\n#4 /var/www/emoncms/Modules/input/input_methods.php(182): InputMethods->process_node()\n#5 /var/www/emoncms/Modules/input/input_controller.php(54): InputMethods->post()\n#6 /var/www/emoncms/core.php(81): input_controller()\n#7 /var/www/emoncms/index.php(257): controller()\n#8 {main}\n  thrown in /var/www/emoncms/Modules/device/device_model.php on line 292

Not sure what's going on. I've restarted the addon, along with rebooting the raspi, but to no avail.

[TCWORLD]

Seems to be related to this commit added by emoncms/device#86. The latest change here bumped the device module to v2.3.3 which first introduced that change.

---

For the time being, I've manually reverted the inclusion of the ip field from the device_model.php file, and it's all back up and running again. I'll post a bug report over on that repo tomorrow, must sleep now!

[tobbensoft]

I have the same error, agree with the above

[alexandrecuer]

If you just update the database in the admin module, doesnt it work ? For me it worked....

[tobbensoft]

That worked, thanks

[alexandrecuer]

Perfect. Most times when you have such error (mysqli does not find a column) it means you have to update the database...sometimes the admin module tells and shows a message, sometimes not....i agree it is tricky

[tobbensoft]

Yes, I remember seeing that message.. But not this time.

[alexandrecuer]

Maybe we could run a systematic database update at addon startup in the mysql_ready file ?

https://github.com/Open-Building-Management/emoncms/blob/main/sql_ready.sh

Here it is only updating for new fresh installs

[TCWORLD]

Ah thanks, I looked for an option like that but missed it, thanks. I agree an auto update of the database would make sense.

[tobbensoft]

I agree on auto update, in this situation there is probably an system backup to fall back on incase of problems.

[cefoster0]

I have the same issue with iotawatt, cannot import with latest build.

Edit: Running the database update solved it, thank you!