1. All column names in the sql tables are lowercase
To determine if it's a GhostXML issue, we need to take the SQL Logger out of the equation for the moment.
2. every colum in the tables has an additional column named column_ui (That reduces the number of possible custom staes by half, I think 125)
Yes, the plugin creates two states for each node/attribute. The state value and the state.ui value.
3. With every timeout a GhostXML device encounters, all states in that device are internally duplicated which leads to duplicated columns in the database once you restart the sqllogger plugin.
You're saying that with each GhostXML device timeout, the number of states within the plugin device increases? What would be helpful is data from the GhostXML device itself showing the state names. When the problem occurs, it would be helpful if you would print out a copy of the device dict using this Python code (revised for your device ID):
- Code: Select all
dev=indigo.devices[12345678]
indigo.server.log(unicode(dev.states))