I've been away for a few months still running HS2, but it looked like build HS3 177 was stable so I jumped back in to HS3. Bang, bang I'm at 180 and 181. OK, and it looks like all the ZWave issues I'd experienced for the last year and a half are ironed out.
It's the plug-ins that are killing me. HS2 to HS Touch to iPhone has been stable for years, but I couldn't get HS3 to work to save my life. Everything from HS2 I paralleled to HS3 but no joy. Uninstall, debug messages, damn - I spent hours on it. FWIW it turned out that for HS2 I opened the firewall for HomeSeer.exe, but for HS3 it had to be HSPI_HSTOUCH.exe. Maybe that will save someone a few hours headache.
So then I've been beating my head against the wall over the Current Cost plugin. Installed, uninstalled, damn - many more hours thrown away. And then I came across the recommendations for MrHappy's "Current Cost 3P" - a bit gnarly to figure out that message 1 from more than a year ago contains a .zip that has been updated. And the install took some...ok, I had to read the documentation and follow the steps in detail.
But it worked a peach. I cannot for the life of me understand why HS would keep their Current Cost plug-in ("free!", "included!", "jump down this rabbit hole and throw your valuable time away") when it clearly doesn't work.
So now my previously unexciting Log is filling up with these errors:
I disabled ALL plug-ins (starting with CC3P). Keeps happening.
I went back and deleted all Current Cost files and settings. Keeps happening.
Of course I've killed and restarted HS3 numerous times. Keeps happening.
So...any idea what's going on here? Something is trying to log some Energy data and it's failing. The Energy tab in HS3 shows nada (and since I never got Current Cost to actually work, I kind of expected that). But is there some other setting I need to turn off? Or some other configuration setting I'm missing? Any help appreciated...
It's the plug-ins that are killing me. HS2 to HS Touch to iPhone has been stable for years, but I couldn't get HS3 to work to save my life. Everything from HS2 I paralleled to HS3 but no joy. Uninstall, debug messages, damn - I spent hours on it. FWIW it turned out that for HS2 I opened the firewall for HomeSeer.exe, but for HS3 it had to be HSPI_HSTOUCH.exe. Maybe that will save someone a few hours headache.
So then I've been beating my head against the wall over the Current Cost plugin. Installed, uninstalled, damn - many more hours thrown away. And then I came across the recommendations for MrHappy's "Current Cost 3P" - a bit gnarly to figure out that message 1 from more than a year ago contains a .zip that has been updated. And the install took some...ok, I had to read the documentation and follow the steps in detail.
But it worked a peach. I cannot for the life of me understand why HS would keep their Current Cost plug-in ("free!", "included!", "jump down this rabbit hole and throw your valuable time away") when it clearly doesn't work.
So now my previously unexciting Log is filling up with these errors:
May-31 6:57:05 PM Error Energy data failed to be added to the energy database - see the log for possible reasons.
May-31 6:57:05 PM Error SQL Exception adding record(s) to the ENERGY database(0): SQL logic error or missing database table EnergyData has no column named Duration, Code=1 SQL=INSERT INTO [EnergyData] ([dvRef],[Direction],[Amount],[Amount_Start],[Amount_End],[Duration],[Rate],[UserCode]) VALUES (285,1,0,'2015-05-31 18:55:05','2015-05-31 18:56:05',60,0.13,0);
May-31 6:57:05 PM Error SQL Exception adding record(s) to the ENERGY database(0): SQL logic error or missing database table EnergyData has no column named Duration, Code=1 SQL=INSERT INTO [EnergyData] ([dvRef],[Direction],[Amount],[Amount_Start],[Amount_End],[Duration],[Rate],[UserCode]) VALUES (285,1,0,'2015-05-31 18:55:05','2015-05-31 18:56:05',60,0.13,0);
I disabled ALL plug-ins (starting with CC3P). Keeps happening.
I went back and deleted all Current Cost files and settings. Keeps happening.
Of course I've killed and restarted HS3 numerous times. Keeps happening.
So...any idea what's going on here? Something is trying to log some Energy data and it's failing. The Energy tab in HS3 shows nada (and since I never got Current Cost to actually work, I kind of expected that). But is there some other setting I need to turn off? Or some other configuration setting I'm missing? Any help appreciated...
Comment