Announcement

Collapse
No announcement yet.

Install of Misc Plugin

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

  • 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

    No, Im from Iowa. I only work in outer space. Captain Kirk

  • #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

      No, Im from Iowa. I only work in outer space. Captain Kirk

      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","",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","",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","",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","",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","",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

          No, Im from Iowa. I only work in outer space. Captain Kirk

          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

              No, Im from Iowa. I only work in outer space. Captain Kirk

              Comment

              Working...
              X