Error: sqlite3_column_database_name assembly

[widert]

08.34.30.9707:[JowiHue]->Importing lampTypes
08.34.30.9802:[JowiHue]->Error: sqlite3_column_database_name assembly:<unknown assembly> type:<unknown type> membernull)

I keep on getting the error above.

Running on MacOS

[w.vuyk]

Which version of the plugin are you running? Can you also check the files in the /bin/JowiHue directory?

[widert]

Using version 2.1.0.4

In the bin/JowiHue directory I have:
-rw-r--r-- 1 root staff 542208 Feb 18 2018 Newtonsoft.Json.dll
-rw-r--r-- 1 root staff 90624 Oct 9 2015 WebSocket4Net.dll

[w.vuyk]

Do you have System.Data.SQLite.dll and/or SQLite.Interop.dll in the HS3 root directory maybe?

[widert]

No, they are both missing...

[widert]

Found them in the HomeSeer/bin folder:

/usr/local/HomeSeer/bin/System.Data.SQLite.dll

[w.vuyk]

That should be the place where they belong, so that is good.

[w.vuyk]

Maybe the database got corrupted? Can you send me the JowiHue.db file by mail? You find the file in the /Data/JowiHue folder.

Send it to jowihue at ziggo dot nl?

Thanks,

Wim

[widert]

Ok, will do.

[w.vuyk]

Tom,

Updated database send.

Thanks,

Wim

[widert]

Did get some error messages when shutting down the plugin as well:

01.03.22.9507:[Error]->Displaying remotely connected interfaces: Object reference not set to an instance of an object
Error in IsEXERunning: Could not find a part of the path '/proc'.
Verifying plugin links...
Done removing plugin.

Messages when starting up again:

01.06.00.2188:[Energy DB Info]->Energy database compaction initiated.
01.06.00.2199:[Energy DB Info]->No Records. Vacuuming database to condense.
01.06.00.2324:[Energy DB Info]->All energy database compacting routines completed.
Connecting to server at 127.0.0.1...
01.06.49.9220:[Info]->Plugin JowiHue has connected. IP:127.0.0.1:65040
Connected, waiting to be initialized...
01.06.50.0558:[Starting Plug-In]->Initializing plugin JowiHue ...
01.06.50.1872:[JowiHue]->Starting plugin JowiHue 2.1.0.4 on Linux
01.06.50.2537:[JowiHue]->InitIO:Plugin basic initialisation done
01.06.50.2560:[Starting Plug-In]->Plugin JowiHue started successfully in 200 milliseconds
01.06.50.2985:[JowiHue]->Importing lampTypes
01.06.50.3482:[JowiHue]->Error: sqlite3_column_database_name assembly:<unknown assembly> type:<unknown type> member:(null)
01.06.50.4430:[Starting Plug-In]->JowiHue loaded in 745 milliseconds
01.06.50.4432:[Plug-In]->Finished initializing plug-in JowiHue
01.06.50.6209:[JowiHue]->* Connected to bridge WideHue at 192.168.50.231:80
01.06.51.8363:[JowiHue]->==============================================================================================
01.06.51.8370:[JowiHue]->-------------------------------------Bridge info ---------------------------------------------
01.06.51.8376:[JowiHue]->7 lights and/or plugs connected to bridge 'WideHue'
01.06.51.8383:[JowiHue]->3 Groups available on bridge 'WideHue'
01.06.51.8391:[JowiHue]->Bridge WideHue is at version 1934129020 of type BSB002
01.06.51.8410:[JowiHue]->1 Presence sensor found on bridge 'WideHue'
01.06.51.8417:[JowiHue]->1 Daylight sensor found on bridge 'WideHue'
01.06.51.8423:[JowiHue]->1 Generic status sensor found on bridge 'WideHue'
01.06.51.8431:[JowiHue]->-------------------------------------Plugin info ---------------------------------------------
01.06.51.8436:[JowiHue]->30 Presets available for use in the JowiHue plugin
01.06.51.8442:[JowiHue]->0 Local scenes available for use in the JowiHue plugin
01.06.51.8447:[JowiHue]->0 Animations available for use in this plugin
01.06.51.8452:[JowiHue]->==============================================================================================
01.06.51.8467:[JowiHue]->Importing lampTypes
01.06.51.8567:[JowiHue]->Error: sqlite3_column_database_name assembly:<unknown assembly> type:<unknown type> member:(null)
01.07.01.0871:[JowiHue]->New lamptype found: Modelid=RM01 Type=
01.07.01.0893:[JowiHue]->Error: (InitialLights)::sqlite3_column_database_name assembly:<unknown assembly> type:<unknown type> member:(null)