OK… Solved both..
-
The first issue. It’s HABPanel doing lookups for items that were previously configured (But deleted because I needed to cleanup the zWave). The frustrating thing about this is that there’s noway to know that the lookup was being performed for HABPanel, and not for updating it. (Apart from experience. I’m all for learning from experience, but frustrating the users isn’t a good way to build a product).
-
The mySQL table creation problem. A simple fix. There’s a note around here on how to doit it, but sadly only for OH1.x. The way to doit for OH2.x is to add the same entry
mysql:sqltype.string=VARCHAR(1024)
into /etc/openhab2/services/mysql.cfg
An lo! mysql now works again…