Announcement

Collapse
No announcement yet.

Install of Misc Plugin

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Install of Misc Plugin

    Don't know if it is me or my HS 2.3.0.19
    But it looks like I am missing something.
    ie-

    Code:
    12/10/2012 12:19:40 PM ~!~Misc Plug-In~!~Add Table maintType
12/10/2012 12:19:40 PM ~!~Misc Plug-In~!~Invalid Connect String
12/10/2012 12:19:40 PM ~!~Misc Plug-In~!~Create Table maintenance
12/10/2012 12:19:40 PM ~!~Misc Plug-In~!~Invalid Connect String
12/10/2012 12:19:40 PM ~!~Info~!~Finished initializing plug-in Misc Plug-In
12/10/2012 12:19:45 PM ~!~Database Item~!~Saving Device Misc Plug-In Misc Plug-in Version
12/10/2012 12:19:45 PM ~!~Database Item~!~Saving Device Misc Plug-In Misc Plug-in Active Modules
12/10/2012 12:19:50 PM ~!~Misc Plug-In~!~Misc Plug-In Found Plugin: HSTouch Server
12/10/2012 12:19:50 PM ~!~Misc Plug-In~!~Misc Plug-In Found Plugin: weatherXML



12/10/2012 11:58:34 AM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\config\hspi_misc.ini
12/10/2012 11:58:34 AM ~!~Updater~!~Making dir: C:\Program Files\HomeSeer HS2\docs\miscPlugin\
12/10/2012 11:58:34 AM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\docs\miscPlugin\miscPlugin.doc
12/10/2012 11:58:34 AM ~!~Updater~!~Making dir: C:\Program Files\HomeSeer HS2\html\help\miscPlugin\
12/10/2012 11:58:34 AM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\html\help\miscPlugin\miscPlugin.pdf
12/10/2012 11:58:34 AM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\scripts\miscPlugin_install.vb
12/10/2012 11:58:34 AM ~!~Updater~!~Running script install, please wait...
12/10/2012 11:58:44 AM ~!~miscPlug-In Install~!~Misc Plug-In documentation exists in the \Docs\miscPlugin directory as miscPlugin.doc(MS Word)
12/10/2012 11:58:44 AM ~!~Warning~!~VB.Net script exception, re-starting: Object reference not set to an instance of an object.
12/10/2012 12:00:44 PM ~!~Updater~!~Making dir: C:\Program Files\HomeSeer HS2\data\miscPlugin\
12/10/2012 12:00:44 PM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\data\miscPlugin\random.mdb
12/10/2012 12:00:44 PM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\bin\miscPlugin\restartHomeSeer.exe
12/10/2012 12:00:44 PM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\data\vehicles\vehicles.mdb to C:\Program Files\HomeSeer HS2\data\miscplugin\vehicles.mdb
12/10/2012 12:00:44 PM ~!~Updater Warning~!~Unable to install files, is HomeSeer running? Please exit it now if so. (Retry in 5 sec.)
12/10/2012 12:00:49 PM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\data\vehicles\vehicles.mdb to C:\Program Files\HomeSeer HS2\data\miscplugin\vehicles.mdb
12/10/2012 12:00:49 PM ~!~Updater Warning~!~Unable to install files, is HomeSeer running? Please exit it now if so. (Retry in 5 sec.)
12/10/2012 12:00:49 PM ~!~Updater Warning~!~Error installing file: vehicles.mdb , is file open?
12/10/2012 12:00:49 PM ~!~Updater Warning~!~Detailed error:  0 
12/10/2012 12:00:49 PM ~!~Updater~!~Copying file: C:\Program Files\HomeSeer HS2\data\miscPlugin\vehicles.mdb



12/10/2012 12:21:29 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 12:21:29 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 12:21:29 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
    I can't add any vehicles and get the errors above.
    I have attatched pics of the setup also.
    I have restarted now 3 times.

    Thanks,
    Tim
    Attached Files
    FB Page - https://www.facebook.com/pages/Capt-Tim/209398425902188

    HSTouch Layouts - https://www.facebook.com/media/set/?...5902188&type=3
    Tags: None
    #2
    Go to the page where Access is showing for the database. Click Save to make sure it got set.
    In the error logs I'm seeing one that says "invalid connect string" so I think it didn't save.
    --
    Jeff Farmer
    HS 3, HSPhone
    My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
    Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

    Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

    Comment

      #3
      I tried that, set debug to high, then navigated around the plugin's pages from the buttons provided and have this log section for you.

      Thanks,
      Tim

      Code:
      12/10/2012 3:22:31 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:22:31 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 3:22:31 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
12/10/2012 3:22:47 PM ~!~Info~!~Event Trigger "BarmForGrafs"
12/10/2012 3:22:47 PM ~!~Info~!~Running script in background: BDbarmValu4Grafs.txt
12/10/2012 3:22:55 PM ~!~Info~!~Event Trigger "PostBarmGrafPic"
12/10/2012 3:22:55 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r3","<img src='/images/BDGraphs/BarometerLevel1174522036.png'>",true
12/10/2012 3:23:06 PM ~!~Info~!~Event Trigger "TempGraf"
12/10/2012 3:23:06 PM ~!~Info~!~Running script in background: BDGraphs.vben("Add","u60;1;u64;1;u65;1")
12/10/2012 3:23:06 PM ~!~BDGraphs~!~The value(s), '18','16','6' in table 'TemperatureLevel2067389377' was/were added.
12/10/2012 3:23:24 PM ~!~Info~!~Event Trigger "PostVisbGrafPic"
12/10/2012 3:23:24 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r5","<img src='/images/BDGraphs/VisibilityLevel1789874848.png'>",true
12/10/2012 3:23:44 PM ~!~Info~!~Event Trigger "NetwrkMon"
12/10/2012 3:23:44 PM ~!~Info~!~Running script in background: Jon00RCCNM_A.vben("network","")
12/10/2012 3:23:53 PM ~!~Error~!~Calling GenPage for plugin, link: /misc?pg=trackerForm Error: Object reference not set to an instance of an object.
12/10/2012 3:24:00 PM ~!~Info~!~Event Trigger "NoSewerWarning"
12/10/2012 3:24:00 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "\9","<img src='/Wthrgrafs/leakseweroff.jpg'>",true
12/10/2012 3:24:00 PM ~!~EventDelay~!~Current delay: 0.088 seconds [Delta: 0.032 Min: 0 Max: 7.148 @ 12/10/2012 12:32 PM] Last Event: NoSewerWarning.  Scripts running: Event Delay Measurement.vb
12/10/2012 3:24:01 PM ~!~Info~!~Event Trigger "bbReminders"
12/10/2012 3:24:01 PM ~!~Info~!~Running script in background: bbMyDay.txt
12/10/2012 3:24:06 PM ~!~Info~!~Event Trigger "TempGrafMake"
12/10/2012 3:24:06 PM ~!~Info~!~Running script in background: BDGraphs.vben("Make","u60;u64;u65;24;0;1")
12/10/2012 3:24:15 PM ~!~Info~!~Remote client connected from: 127.0.0.1
12/10/2012 3:24:19 PM ~!~BDGraphs~!~A graph for table 'TemperatureLevel2067389377' was created and placed in /html/images/BDGraphs.
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: module_Tracker=1
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnMileageForm=1
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnVehicleList=1
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnRestartHS=0
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnRandom=0
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnLinkEdit=0
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: saveSettings=Save
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: ref_page=misc_config
12/10/2012 3:24:26 PM ~!~Info~!~Event Trigger "PrecipGraf"
12/10/2012 3:24:26 PM ~!~Info~!~Running script in background: mlPrecip.txt
12/10/2012 3:24:26 PM ~!~Info~!~Event Trigger "MonitorNetwork"
12/10/2012 3:24:26 PM ~!~Info~!~Running script in background: Jon00RCCNM_Monitor.vben
12/10/2012 3:24:26 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: Tracker
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: pg=Tracker
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: dbType=1
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: sqlserveraddr=
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: sqlservername=
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: trackertoaddr=fungun@yahoo.com
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: trackerfromaddr=fungun@yahoo.com
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: saveTrackerMod=Save
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: ref_page=misc_config
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: Tracker
12/10/2012 3:24:32 PM ~!~Info~!~Remote client disconnected
12/10/2012 3:24:34 PM ~!~Info~!~Event Trigger "PostRainGrafPic"
12/10/2012 3:24:34 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r6","<img src='/images/BDGraphs/TodaysPrecipLevel286493268.png'>",true
12/10/2012 3:24:34 PM ~!~Info~!~Event Trigger "PostLakeTmpGrafPic"
12/10/2012 3:24:34 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r8","<img src='/images/BDGraphs/LakeTempF1747335183.png'>",true
12/10/2012 3:25:05 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: trackerVehicles
12/10/2012 3:25:05 PM ~!~Misc Plug-In~!~SQL: SELECT min(ID), max(ID) FROM vehicles WHERE isActive = 1
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~Array Rows: 0, Cols: 1
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~SQL: SELECT ID, vehicleModel, HSuserNames FROM vehicles ORDER BY vehicleModel
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~Array Rows: -1, Cols: 2
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~SQL: SELECT ID, Type FROM vehicleType WHERE isActive = TRUE ORDER BY SortOrder
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~Array Rows: 2, Cols: 1
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~SQL: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:07 PM ~!~Info~!~Event Trigger "WndspdGraf"
12/10/2012 3:25:07 PM ~!~Info~!~Running script in background: mlWndSpd.txt
12/10/2012 3:25:07 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:07 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 3:25:07 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: trackerVehicles
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT min(ID), max(ID) FROM vehicles WHERE isActive = 1
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Array Rows: 0, Cols: 1
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT ID, vehicleModel, HSuserNames FROM vehicles ORDER BY vehicleModel
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Array Rows: -1, Cols: 2
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT ID, Type FROM vehicleType WHERE isActive = TRUE ORDER BY SortOrder
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Array Rows: 2, Cols: 1
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
12/10/2012 3:25:36 PM ~!~Info~!~Event Trigger "MaxSystemUptime"
12/10/2012 3:25:36 PM ~!~Info~!~Running script in background: Maximum Uptime.vb
12/10/2012 3:25:41 PM ~!~Info~!~Event Trigger "CurntCondPicDays"
12/10/2012 3:25:41 PM ~!~Info~!~Running script in background: CurCond4hst.txt
12/10/2012 3:25:41 PM ~!~Info~!~Running script in background: CurCondText.txt
      FB Page - https://www.facebook.com/pages/Capt-Tim/209398425902188

      HSTouch Layouts - https://www.facebook.com/media/set/?...5902188&type=3

      Comment

        #4
        Originally posted by fungun View Post
        I tried that, set debug to high, then navigated around the plugin's pages from the buttons provided and have this log section for you.

        Thanks,
        Tim

        Code:
        12/10/2012 3:22:31 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:22:31 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 3:22:31 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
12/10/2012 3:22:47 PM ~!~Info~!~Event Trigger "BarmForGrafs"
12/10/2012 3:22:47 PM ~!~Info~!~Running script in background: BDbarmValu4Grafs.txt
12/10/2012 3:22:55 PM ~!~Info~!~Event Trigger "PostBarmGrafPic"
12/10/2012 3:22:55 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r3","[IMG]http://forums.homeseer.com/images/BDGraphs/BarometerLevel1174522036.png[/IMG]",true
12/10/2012 3:23:06 PM ~!~Info~!~Event Trigger "TempGraf"
12/10/2012 3:23:06 PM ~!~Info~!~Running script in background: BDGraphs.vben("Add","u60;1;u64;1;u65;1")
12/10/2012 3:23:06 PM ~!~BDGraphs~!~The value(s), '18','16','6' in table 'TemperatureLevel2067389377' was/were added.
12/10/2012 3:23:24 PM ~!~Info~!~Event Trigger "PostVisbGrafPic"
12/10/2012 3:23:24 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r5","[IMG]http://forums.homeseer.com/images/BDGraphs/VisibilityLevel1789874848.png[/IMG]",true
12/10/2012 3:23:44 PM ~!~Info~!~Event Trigger "NetwrkMon"
12/10/2012 3:23:44 PM ~!~Info~!~Running script in background: Jon00RCCNM_A.vben("network","")
12/10/2012 3:23:53 PM ~!~Error~!~Calling GenPage for plugin, link: /misc?pg=trackerForm Error: Object reference not set to an instance of an object.
12/10/2012 3:24:00 PM ~!~Info~!~Event Trigger "NoSewerWarning"
12/10/2012 3:24:00 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "\9","[IMG]http://forums.homeseer.com/Wthrgrafs/leakseweroff.jpg[/IMG]",true
12/10/2012 3:24:00 PM ~!~EventDelay~!~Current delay: 0.088 seconds [Delta: 0.032 Min: 0 Max: 7.148 @ 12/10/2012 12:32 PM] Last Event: NoSewerWarning.  Scripts running: Event Delay Measurement.vb
12/10/2012 3:24:01 PM ~!~Info~!~Event Trigger "bbReminders"
12/10/2012 3:24:01 PM ~!~Info~!~Running script in background: bbMyDay.txt
12/10/2012 3:24:06 PM ~!~Info~!~Event Trigger "TempGrafMake"
12/10/2012 3:24:06 PM ~!~Info~!~Running script in background: BDGraphs.vben("Make","u60;u64;u65;24;0;1")
12/10/2012 3:24:15 PM ~!~Info~!~Remote client connected from: 127.0.0.1
12/10/2012 3:24:19 PM ~!~BDGraphs~!~A graph for table 'TemperatureLevel2067389377' was created and placed in /html/images/BDGraphs.
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: module_Tracker=1
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnMileageForm=1
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnVehicleList=1
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnRestartHS=0
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnRandom=0
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: showBtnLinkEdit=0
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: saveSettings=Save
12/10/2012 3:24:22 PM ~!~Misc Plug-In~!~Field: ref_page=misc_config
12/10/2012 3:24:26 PM ~!~Info~!~Event Trigger "PrecipGraf"
12/10/2012 3:24:26 PM ~!~Info~!~Running script in background: mlPrecip.txt
12/10/2012 3:24:26 PM ~!~Info~!~Event Trigger "MonitorNetwork"
12/10/2012 3:24:26 PM ~!~Info~!~Running script in background: Jon00RCCNM_Monitor.vben
12/10/2012 3:24:26 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: Tracker
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: pg=Tracker
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: dbType=1
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: sqlserveraddr=
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: sqlservername=
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: trackertoaddr=fungun@yahoo.com
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: trackerfromaddr=fungun@yahoo.com
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: saveTrackerMod=Save
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~Field: ref_page=misc_config
12/10/2012 3:24:28 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: Tracker
12/10/2012 3:24:32 PM ~!~Info~!~Remote client disconnected
12/10/2012 3:24:34 PM ~!~Info~!~Event Trigger "PostRainGrafPic"
12/10/2012 3:24:34 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r6","[IMG]http://forums.homeseer.com/images/BDGraphs/TodaysPrecipLevel286493268.png[/IMG]",true
12/10/2012 3:24:34 PM ~!~Info~!~Event Trigger "PostLakeTmpGrafPic"
12/10/2012 3:24:34 PM ~!~Info~!~Running script statement immediately: &hs.SetDeviceString "r8","[IMG]http://forums.homeseer.com/images/BDGraphs/LakeTempF1747335183.png[/IMG]",true
12/10/2012 3:25:05 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: trackerVehicles
12/10/2012 3:25:05 PM ~!~Misc Plug-In~!~SQL: SELECT min(ID), max(ID) FROM vehicles WHERE isActive = 1
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~Array Rows: 0, Cols: 1
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~SQL: SELECT ID, vehicleModel, HSuserNames FROM vehicles ORDER BY vehicleModel
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~Array Rows: -1, Cols: 2
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~SQL: SELECT ID, Type FROM vehicleType WHERE isActive = TRUE ORDER BY SortOrder
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~Array Rows: 2, Cols: 1
12/10/2012 3:25:06 PM ~!~Misc Plug-In~!~SQL: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:07 PM ~!~Info~!~Event Trigger "WndspdGraf"
12/10/2012 3:25:07 PM ~!~Info~!~Running script in background: mlWndSpd.txt
12/10/2012 3:25:07 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:07 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 3:25:07 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~GenPage: name: pg = value: trackerVehicles
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT min(ID), max(ID) FROM vehicles WHERE isActive = 1
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Array Rows: 0, Cols: 1
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT ID, vehicleModel, HSuserNames FROM vehicles ORDER BY vehicleModel
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Array Rows: -1, Cols: 2
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT ID, Type FROM vehicleType WHERE isActive = TRUE ORDER BY SortOrder
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Array Rows: 2, Cols: 1
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~SQL: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~runSelectAccess: SELECT ID, HSuserNames, vehicleYear, vehicleMake, vehicleModel, vehicleExtra, vehicleType, purchaseDate, purchaseMileage, currentMileage, licensePlate, VIN, insuranceCompany, insurancePolicy, notes, isActive, HSDeviceCode FROM vehicles WHERE ID = 
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~Syntax error (missing operator) in query expression 'ID ='.
12/10/2012 3:25:10 PM ~!~Misc Plug-In~!~trackerVehicles: Conversion from string "" to type 'Integer' is not valid.
12/10/2012 3:25:36 PM ~!~Info~!~Event Trigger "MaxSystemUptime"
12/10/2012 3:25:36 PM ~!~Info~!~Running script in background: Maximum Uptime.vb
12/10/2012 3:25:41 PM ~!~Info~!~Event Trigger "CurntCondPicDays"
12/10/2012 3:25:41 PM ~!~Info~!~Running script in background: CurCond4hst.txt
12/10/2012 3:25:41 PM ~!~Info~!~Running script in background: CurCondText.txt
        I figured out the problem. I will work on a fix but I have a couple of school concerts to go to this week. It will probably be this friday before I can work on this.
        --
        Jeff Farmer
        HS 3, HSPhone
        My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
        Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

        Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

        Comment

          #5
          Cool, thank you much.
          Have fun at the concerts, I always did.

          Tim
          FB Page - https://www.facebook.com/pages/Capt-Tim/209398425902188

          HSTouch Layouts - https://www.facebook.com/media/set/?...5902188&type=3

          Comment

            #6
            Posted 1.0.4 to the updater.
            I deleted all of the vehicles I was tracking in my development server and went through the pages to make sure they didn't error.
            You should be able to get it running now.

            I also removed the code that was registering for the log callback.
            I wasn't doing anything with it anyway.
            --
            Jeff Farmer
            HS 3, HSPhone
            My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
            Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

            Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

            Comment

              #7
              Runs as expected.

              Thank you,
              Tim
              FB Page - https://www.facebook.com/pages/Capt-Tim/209398425902188

              HSTouch Layouts - https://www.facebook.com/media/set/?...5902188&type=3

              Comment

              Previous template Next
              Working...
              X