Announcement

Collapse
No announcement yet.

Beta 2.0.4.3: SQL errors on fresh installation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Beta 2.0.4.3: SQL errors on fresh installation

    Just installed the Beta 2.0.4.3 plugin on a fresh HS3Pi installation and got a few errors that might be important to look into.


    First Enable:
    Jul-28 4:02:43 PM JowiHue Error: (UpdateSensorModels)::SQL logic error or missing database no such table: SensorModels
    Jul-28 4:02:43 PM JowiHue Importing SensorModels
    Jul-28 4:02:43 PM JowiHue Error: (UpdateSensorTypes)::constraint failed UNIQUE constraint failed: SensorTypes.Type
    Jul-28 4:02:43 PM JowiHue Importing SensorTypes
    Jul-28 4:02:41 PM Plug-In Finished initializing plug-in JowiHue
    Jul-28 4:02:41 PM Starting Plug-In JowiHue loaded in 2404 milliseconds
    Jul-28 4:02:41 PM JowiHue Importing lampTypes
    Jul-28 4:02:41 PM Starting Plug-In Plugin JowiHue started successfully in 1268 milliseconds
    Jul-28 4:02:41 PM JowiHue InitIO:Plugin basic initialisation done
    Jul-28 4:02:41 PM JowiHue Error: (InitDatabase)::Object reference not set to an instance of an object
    Jul-28 4:02:41 PM JowiHue Error: (InitDatabase)::Error occured at table SensorTypes with statement PRAGMA table_info(SensorTypes)
    Jul-28 4:02:40 PM JowiHue Table SensorType has been altered
    Jul-28 4:02:40 PM JowiHue Changed Bridges table
    Jul-28 4:02:40 PM JowiHue Changed Usage table
    Jul-28 4:02:40 PM JowiHue Starting plugin JowiHue 2.0.4.3 on Linux
    Jul-28 4:02:40 PM JowiHue Recreated table lamptypes: 0
    Jul-28 4:02:40 PM JowiHue dropped table lamptypes: 0
    Jul-28 4:02:40 PM JowiHue Upgrading database to version 5
    Jul-28 4:02:39 PM Starting Plug-In Initializing plugin JowiHue ...
    Jul-28 4:02:39 PM Info Plugin JowiHue has connected. IP:127.0.0.1:41866
    Disabled and Re-Enabled the plugin and got some different errors, but again, related to SensorTypes:
    Jul-28 4:09:15 PM Plug-In Finished initializing plug-in JowiHue
    Jul-28 4:09:15 PM Starting Plug-In JowiHue loaded in 2205 milliseconds
    Jul-28 4:09:15 PM Starting Plug-In Plugin JowiHue started successfully in 1089 milliseconds
    Jul-28 4:09:15 PM JowiHue InitIO:Plugin basic initialisation done
    Jul-28 4:09:15 PM JowiHue Error: (InitDatabase)::Object reference not set to an instance of an object
    Jul-28 4:09:15 PM JowiHue Error: (InitDatabase)::Error occured at table SensorTypes with statement PRAGMA table_info(SensorTypes)
    Jul-28 4:09:15 PM JowiHue Table SensorType has been altered
    Jul-28 4:09:14 PM JowiHue Starting plugin JowiHue 2.0.4.3 on Linux
    Jul-28 4:09:14 PM Starting Plug-In Initializing plugin JowiHue ...
    Jul-28 4:09:14 PM Info Plugin JowiHue has connected. IP:127.0.0.1:41886
    Let me know you need any additional information.


    EDIT: Go some more SQL errors when I went to Configuration and checked Ignore next to my Hue bridge.

    Jul-28 4:17:42 PM JowiHue bridge command will be ignored
    Jul-28 4:17:42 PM JowiHue Error: (AddOrUpdatebridgeuser)::SQL logic error or missing database no such column: True

    Thanks,
    Ken

  • #2
    Ken,

    This issue on an initial installation will be resolved in the next beta. Point is that to many conflicting changes are done on the initial database with the first start. So the new version will have a already converted database so these errors are not needed.

    But I do like the way you are testing, keep up the good work!

    Thanks,

    Wim
    -- Wim

    Plugins:RFXCOM, HSTouch Server, Squeezebox, BLGData, Restart, Jon00's Perfmon and Network monitor, WeatherXML, BLBackup, TenScripting, BC4, Pushover, PHLocation, JowiHue, Zwave, Sonos
    650 devices ---- 336 events ----- 40 scripts

    Comment

    Working...
    X