Announcement

Collapse
No announcement yet.

New error in log

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

  • New error in log

    I have been seeing this error in the log from time to time. It dose not seem to be causing any problems. It just started in the last couple of months. Any suggestions?

    3/3/2008 5:32:00 AM Info Event Trigger "HSTV Import Data"
    3/3/2008 5:32:00 AM Info Running script statement immediately: &hs.Plugin("HSTV").dataInsert()
    3/3/2008 5:32:00 AM HSTV Starting data cleanup and listings import.
    3/3/2008 5:32:00 AM HSTV Deleting 1622 records.
    3/3/2008 5:32:02 AM HSTV Error Query: SELECT top 1 c.channelID, c.channelNickName, c.channelName, c.channelNumber, s.starttime, l.endtime, l.title, l.episode, l.category, l.description FROM scheduledFavs s, tvListings l, tvChannels c WHERE s.starttime > Now() And s.channelID = l.channelID And s.starttime = l.starttime And l.channelID = c.channelID And s.isActive = 1 ORDER BY s.starttime
    3/3/2008 5:32:02 AM HSTV Error Select Query: Operation is not allowed when the object is open.
    3/3/2008 5:32:02 AM HSTV Error Query: SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID
    3/3/2008 5:32:02 AM HSTV Error Select Query: Operation is not allowed when the object is closed.
    3/3/2008 5:32:02 AM HSTV Error Import Cleanup: Operation is not allowed when the object is closed.

  • #2
    Check out this thread:

    http://forums.homeseer.com/showthread.php?t=124453

    and see if you need to compact 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

    Working...
    X