Errors with SQL Logger in Indigo 5.1.2
Hi guys.
I installed the Indigo Pro 5.1.2 update last night and enabled the SQL Logger plug-in. It began creating tables for all the Indigo devices and variables. While it did this, I saw the below error.
- Code: Select all
2012-05-17 11:16:48 SQL Logger creating table variable_history_1837504140 for "RecentActivity6"
2012-05-17 11:16:48 SQL Logger Error exception trying to insert row into table variable_history_1837504140 ("RecentActivity6")
2012-05-17 11:16:48 SQL Logger Error 'ascii' codec can't encode character u'\u2019' in position 43: ordinal not in range(128)
2012-05-17 11:16:48 SQL Logger Error INSERT INTO variable_history_1837504140 (value) VALUES (%s);
The content of "RecentActivity6" variable is
- Code: Select all
2012-05-02 08:18:48 Error script error: Can’t make text item 1 of "" into type number. (-1700)
Looks like it's complaining about the single-quote in the variable value. Perhaps it needs escaping?
I also see a similar error with another variable I use to display my home theater receiver's volume in Indigo Touch. That variable is set to "-∞" when the receiver is off. The infinity symbol there also causes SQL Logger to throw the same kind of error, shown below.
- Code: Select all
2012-05-17 16:34:55 SQL Logger Error exception trying to insert row into table variable_history_1404010322 ("ReceiverVolumeDB")
2012-05-17 16:34:55 SQL Logger Error 'ascii' codec can't encode character u'\u221e' in position 1: ordinal not in range(128)
2012-05-17 16:34:55 SQL Logger Error INSERT INTO variable_history_1404010322 (value) VALUES (%s);
Perhaps that special infinity character can't be inserted?
Obviously, these errors don't impact performance or usability of Indigo (other than one or two variable change rows not being inserted now and again), but I thought you guys might want to be aware of it.
