Support Area

[CFGuy]

This area is for the following:

HS Links Editor - an editor for the customizable buttons that HS adds to the top of the web pages.

Misc Plugin - 4 plugins in 1. Random phrase, Vehicle Tracker, Movie Manager Addon, and Restart

[beerygaz]

Jeff, I'm using Random Phrase in HS3 - when the plugin starts I get:

Dec-05 08:36:52 AM Random Error Conversion from string "" to type 'Double' is not valid.

Is this an issue?

[CFGuy]

I'll look into the error this weekend. If you could send me the hspi_Random.ini file that would help.

[beerygaz]

Jeff, no internet access over the w/e - but here's the INI file you requested.

[DeviceRef]
PluginVersion=1988
LastSpoken=
[Settings]
debugMode=1
[dbConnect]
sqlserveraddr=
sqlservername=
[Random]
useHSDevice=False
startupSpeak=BBC America
delaySpeak=30
startupHosts=

[CFGuy]

For now set startupSpeak to 0

[Random]
useHSDevice=False
startupSpeak=0
delaySpeak=30


I will add a way to set that without editing the ini file.

[beerygaz]

Jeff, it seems any attempt to access the plugin throws this error. I tried the code:

msg = hs.PluginFunction("Random","","random", new Object(){"GoodNight",False})

And the log threw:

Dec-17 10:02:11 AM Random Error Conversion from string "" to type 'Double' is not valid.

[CFGuy]

Go to the Admin Settings page for Random and set the logging to high. Then try your script again and get me the log entries.

I did just try this in a script and it worked so need to see some debugging to narrow down where to look in the code.
Dim sVar as String
sVar = hs.PluginFunction("Random","","random", new Object(){"BBC America",False})
hs.WriteLog("Random",sVar)

[beerygaz]

Enabled High Level for debug. Same issue.

Dec-17 05:37:43 PM Random
Dec-17 05:37:43 PM Random Error Conversion from string "" to type 'Double' is not valid.
Dec-17 05:37:43 PM Event Running script in background: C:/Program Files (x86)/HomeSeer HS3/scripts/random.vb
Dec-17 05:37:43 PM Event Event Trigger "Testing Test Random"
Dec-17 05:37:43 PM Event Event Testing Test Random triggered by the event page 'Run' button.

Sub Main(parm as object)
Dim sVar as String
sVar = hs.PluginFunction("Random","","random", new Object(){"BBC America",False})
hs.WriteLog("Random",sVar)
End Sub

I'm running v1.0.0.2

[CFGuy]

Do you have a category called BBC America? If not change what I posted to use a category that you have and make sure you have a couple of phrases in the category.

[aperkin2]

Jeff, I'm using Random Phrase in HS3 - when the plugin starts I get:

Dec-05 08:36:52 AM Random Error Conversion from string "" to type 'Double' is not valid.

Is this an issue?

I've been getting the same exact error. No matter what I do, I always get the same.

I just set up a simple event to speak a random phrase. I have also tried setting a random string to a device. I have also tried the suggested script. All the same behavior as beerygaz.

Here is output from the log:


Dec-17 8:42:01 PM Random Array Rows: 14, Cols: 1
Dec-17 8:42:01 PM Random Array Rows: 0, Cols: 1
Dec-17 8:42:00 PM Sonos SpeakIn called for Device = 100, Text = , Wait=False, Host = $SONOS$Default$
Dec-17 8:42:00 PM Random Error Conversion from string "" to type 'Double' is not valid.
Dec-17 8:42:00 PM Random Array Rows: 0, Cols: 1
Dec-17 8:42:00 PM Random Array Rows: 0, Cols: 1
Dec-17 8:42:00 PM Event Event Trigger "Test Random Test"
Dec-17 8:42:00 PM Event Event Test Random Test triggered by the event page 'Run' button.

Please let me know what I can do to help debug.

[CFGuy]

Dec-17 8:42:01 PM Random Array Rows: 0, Cols: 1
This line in your log file tells me that there were 0 phrases found. However in the line right before that it shows 14 rows.

When I run a script I only get one line with the array rows info
Dec-17 9:45:07 PM Event Event Scripts Test Script triggered by the event page 'Run' button.
Dec-17 9:45:07 PM Event Event Trigger "Scripts Test Script"
Dec-17 9:45:07 PM Event Running script in background: C:/Program Files (x86)/HomeSeer HS3/scripts/test.vb
Dec-17 9:45:07 PM Random Array Rows: 2, Cols: 2
Dec-17 9:45:07 PM Random Get phrase between 0 and 2
Dec-17 9:45:07 PM Random BBC America, we put the Who in Doctor.


I put 1.0.0.2 in the updater. I added some more debug info to help figure this out.

[aperkin2]

I installed 1.0.0.2 and tried another test Here is the log:

Dec-17 10:55:09 PM Sonos Error Error in DoCheckAnnouncementQueue. 100 seconds expired since the announcement started and no end was received.
Dec-17 10:54:18 PM Random Array Rows: 14, Cols: 1
Dec-17 10:54:18 PM Random SQL=SELECT categoryID, categoryText FROM category WHERE isActive {0x3C3E} 0 ORDER BY categoryText
Dec-17 10:54:17 PM Random Array Rows: 0, Cols: 1
Dec-17 10:54:17 PM Random SQL=SELECT categoryID, categoryText FROM category WHERE categoryID = 5
Dec-17 10:54:16 PM Sonos SpeakIn called for Device = 100, Text = , Wait=False, Host = $SONOS$Default$
Dec-17 10:54:16 PM Random Error Conversion from string "" to type 'Double' is not valid.
Dec-17 10:54:16 PM Random Array Rows: 0, Cols: 1
Dec-17 10:54:16 PM Random SQL=SELECT categoryID, categoryText FROM category WHERE categoryID = 5
Dec-17 10:54:16 PM Random Array Rows: 0, Cols: 1
Dec-17 10:54:16 PM Random SQL=SELECT categoryID, categoryText FROM category WHERE categoryID = 5
Dec-17 10:54:16 PM Event Event Trigger "Test Random Test"
Dec-17 10:54:16 PM Event Event Test Random Test triggered by the event page 'Run' button.
Dec-17 10:54:09 PM Random Array Rows: 14, Cols: 1
Dec-17 10:54:09 PM Random SQL=SELECT categoryID, categoryText FROM category WHERE isActive {0x3C3E} 0 ORDER BY categoryText
Dec-17 10:54:09 PM Random Array Rows: 0, Cols: 1
Dec-17 10:54:09 PM Random SQL=SELECT categoryID, categoryText FROM category WHERE categoryID = 5
Dec-17 10:53:41 PM Random Array Rows: 14, Cols: 3
Dec-17 10:53:41 PM Random SQL=SELECT c.categoryID, c.categoryText, c.isActive, count(p.phraseID) as phrases FROM category c LEFT JOIN phrases p ON c.categoryID = p.categoryID GROUP BY c.categoryID, c.categoryText, c.isActive ORDER BY c.categoryText
Dec-17 10:53:41 PM Random Array Rows: 14, Cols: 1
Dec-17 10:53:41 PM Random SQL=SELECT categoryText as ID, categoryText FROM category WHERE isActive = 1 AND categoryID IN (SELECT categoryID FROM phrases) ORDER BY categoryText
Dec-17 10:53:34 PM Random Array Rows: 14, Cols: 1
Dec-17 10:53:34 PM Random SQL=SELECT distinct c.categoryText, c.categoryText FROM category c INNER JOIN phrases p ON c.categoryID = p.categoryID WHERE c.isActive = 1 ORDER BY c.categoryText
Dec-17 10:53:19 PM TTS Speak: ():
Dec-17 10:53:19 PM Plug-In Finished initializing plug-in Random
Dec-17 10:53:19 PM Sonos SpeakIn called for Device = 100, Text = , Wait=False, Host =
Dec-17 10:53:19 PM Random Error Conversion from string "" to type 'Double' is not valid.
Dec-17 10:53:18 PM Random InitIO called, plug-in is being initialized...
Dec-17 10:53:18 PM Info Plug-in Random has connected successfully
Dec-17 10:53:18 PM Info Remote application or plugin has connected: 127.0.0.1:62226
Dec-17 10:53:18 PM Info Remote application or plugin has connected: 127.0.0.1:62225
Dec-17 10:52:12 PM Updater Install/Update of package Random Phrase was successful.

[beerygaz]

Jeff I do have the BBC America category with 3 phrases in it.

aperkin2 - I'm so glad I'm not the only one!

Here's the log from the 1.0.0.2 reinstall from the updater:

Dec-18 10:10:14 AM Sonos SpeakIn called for Device = 100, Text = , Wait=False, Host =
Dec-18 10:10:14 AM Random Error Conversion from string "" to type 'Double' is not valid.
Dec-18 10:10:00 AM Random Array Rows: 15, Cols: 3
Dec-18 10:10:00 AM Random SQL=SELECT c.categoryID, c.categoryText, c.isActive, count(p.phraseID) as phrases FROM category c LEFT JOIN phrases p ON c.categoryID = p.categoryID GROUP BY c.categoryID, c.categoryText, c.isActive ORDER BY c.categoryText
Dec-18 10:10:00 AM Random Array Rows: 15, Cols: 1
Dec-18 10:10:00 AM Random SQL=SELECT categoryText as ID, categoryText FROM category WHERE isActive = 1 AND categoryID IN (SELECT categoryID FROM phrases) ORDER BY categoryText
Dec-18 10:09:44 AM Plug-In Finished initializing plug-in Random
Dec-18 10:09:43 AM Random InitIO called, plug-in is being initialized...

[w.vuyk]

I had the random phrase installed for my HS3 system, but never used it because I am using Dutch voices and English does not really sounds good with this voice
I was also seeing the double conversion error.

But what I think is weird, the plugin page for me is reporting I have 1.0.0.2 installed? I never initiated the upgrade?

Regards,

Wim

[CFGuy]

aperkin2 and beerygaz,
Thanks for posting the log entries. I will look through them this evening and try to get this fixed.



w.vuyk
Did you try editing the phrases to be in Dutch? You can add, edit or delete the phrases and categories.