Announcement

Collapse
No announcement yet.

Corrupted HSTV database?

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

  • Corrupted HSTV database?

    Happy New Year Jeff,

    Yesterday I decided to re-enable HSTV. I had turned it off (disabled in interfaces) for a bit to elminate it from some other issues I was having. As part of the fix I upgraded HS to .75. When I went to re-enable I get the following messages in the log file. Can you point me in a direction?

    <TABLE border=0 cellSpacing=2 cellPadding=0 width="100%"><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>runSelectQueryAccess: SELECT optionName, optionValue FROM userOptions WHERE userID = 'chris' AND optionName IN ('pgprivtvadmin','pgprivcategorylist','pgprivchselector','pg privevents','pgprivscheduled','pgprivsearch','pgprivtvdispla y','pgprivtvlistings','pgprivuseroptions','pgprivwapppc','in tAllowRecord','intAllowRemind','intAllowWatch') </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType1 colSpan=3 align=left>Debug </TD><TD class=LOGEntry1 colSpan=8 align=left>Unrecognized database format 'C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb'.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>runSelectQueryAccess: SELECT optionName, optionValue FROM userOptions WHERE userID = 'homeseer!@' AND optionName IN ('pgprivtvadmin','pgprivcategorylist','pgprivchselector','pg privevents','pgprivscheduled','pgprivsearch','pgprivtvdispla y','pgprivtvlistings','pgprivuseroptions','pgprivwapppc','in tAllowRecord','intAllowRemind','intAllowWatch') </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType1 colSpan=3 align=left>Debug </TD><TD class=LOGEntry1 colSpan=8 align=left>Unrecognized database format 'C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb'.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>runSelectQueryAccess: SELECT COUNT(favID) FROM userFavs</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType1 colSpan=3 align=left>Debug </TD><TD class=LOGEntry1 colSpan=8 align=left>Unrecognized database format 'C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb'.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>Error Page Access: Object variable or With block variable not set.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType1 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry1 colSpan=8 align=left>HSTV has finished setting up user access.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>runSelectQueryAccess: SELECT optionName, optionValue FROM userOptions WHERE userID = 'chris' AND optionName IN ('intUsePopup','intShowRecord','intShowRemind','intShowWatch ','intShowRepeats','showMenuTop','showMenuBottom') </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType1 colSpan=3 align=left>Debug </TD><TD class=LOGEntry1 colSpan=8 align=left>Unrecognized database format 'C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb'.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>runSelectQueryAccess: SELECT optionName, optionValue FROM userOptions WHERE userID = 'homeseer!@' AND optionName IN ('intUsePopup','intShowRecord','intShowRemind','intShowWatch ','intShowRepeats','showMenuTop','showMenuBottom') </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType1 colSpan=3 align=left>Debug </TD><TD class=LOGEntry1 colSpan=8 align=left>Unrecognized database format 'C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb'.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:00 PM </TD><TD class=LOGType0 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry0 colSpan=8 align=left>HSTV has finished setting up user settings.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>1/7/2013 2:03:01 PM </TD><TD class=LOGType1 colSpan=3 align=left>HSTV </TD><TD class=LOGEntry1 colSpan=8 align=left>runSelectQueryAccess: SELECT d.appID as ID, 'app' as runTable, d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceApp d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '1/7/2013 2:03:00 PM' UNION SELECT d.emailID, 'email', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceEmail d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.emailEarly),s.starttime) = '1/7/2013 2:03:00 PM' UNION SELECT d.irID, 'ir', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceIR d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '1/7/2013 2:03:00 PM' UNION SELECT d.scriptID, 'script', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceScript d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '1/7/2013 2:03:00 PM' UNION SELECT d.speakID, 'speak', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceSpeak d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.speakEarly),s.starttime) = '1/7/2013 2:03:00 PM' UNION SELECT d.pluginID, 'plugin', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, devicePlugin d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '1/7/2013 2:03:00 PM' UNION SELECT d.irID, 'irstop', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM tvListings l, scheduledFavs s, userFavs u, deviceIR d WHERE l.starttime = s.starttime And l.channelID = s.channelID And s.favID = u.favID And u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',d.padTime,l.endtime) = '1/7/2013 2:03:00 PM' ORDER BY s.scheduledID, s.FavID, d.runOrder</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>1/7/2013 2:03:01 PM </TD><TD class=LOGType0 colSpan=3 align=left>Debug </TD><TD class=LOGEntry0 colSpan=8 align=left>Unrecognized database format 'C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb'.









    </TD></TR></TBODY></TABLE>
    Thank you,

    Chris

  • #2
    First make sure the database is in the location that HSTV thinks it is.
    C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb

    Next thing to try is open Access and do a compact and repair on the database.
    --
    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
      Thank you Jeff,

      Not sure what happened, but the compact and repair fixed it up.

      Chris

      Comment


      • #4
        Originally posted by dcdelong View Post
        Thank you Jeff,

        Not sure what happened, but the compact and repair fixed it up.

        Chris
        It probably got too big. Access gets unstable when it reaches 2 Gb in size.
        The daily import of the data causes the database to grow, but when the old data is deleted, access doesn't shrink. You have to compact it to get that space back.
        Depending on which version of HSTV you are using, one of the HS event actions for HSTV is "Compact Access Database". You can schedule that to run every so often.
        --
        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

        Working...
        X