[SOLVED] MYSQL Persistence - OpenHAB v2.5.6: Only new items of type "String" cannot be stored

[ohb1138 (Justus Reich)]

Mysql persistence complains it can't find tables

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 her…

Ok, its seems that

# Tweak String VAR size
sqltype.string=VARCHAR(65500)

is too big …

Setting it to

# Tweak String VAR size
sqltype.string=VARCHAR(1024)

solved the issue …

I don’t know how the huge value of 65500 made it into my definition.
Maybe I just activated the line and did not check the value???

Anyway … problem solved