I'm still looking into the other error. Since the fixed one doesn't cause any problems I'm not going to make it available for download until I have fixed both.
Announcement
Collapse
No announcement yet.
HSTV Data Input Errors
Collapse
X
-
--
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
-
Originally posted by CFGuy View PostI'm still looking into the other error. Since the fixed one doesn't cause any problems I'm not going to make it available for download until I have fixed both.
Please also take a look at why my old XMLs keep accumulating in the listings directory without being deleted.
Comment
-
I can not duplicate what you are getting.
Please do this:
Set the debugging to the highest level and then run the event HSTV Import Data. Post the log entries here.
If I still can't figure out where the error is, I will add some more debugging messages and send you an update to run.--
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
-
Here you go Jeff. Let me know what you would like me to try next.
Thanks...
<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Data Import: Starting data insert.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Starting data cleanup and listings import.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT Count(channelID) FROM tvListings WHERE starttime < #2008/07/21#</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>No records to delete.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvlistings WHERE starttime < #7/21/2008 12:00:00 AM#</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM scheduledFavs WHERE starttime < #2008/07/21 0:00:00#</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Deleting channels not selected for download.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE tvImport INNER JOIN tvchannels AS c ON tvImport.channelID = c.channelID SET tvImport.channeldownload = c.channeldownload, tvImport.viewhide = c.viewhide, tvImport.channelNum = c.channelNumber</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:34 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE channelDownload = 0 OR viewHide = 1</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:37 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT importID, channelID, starttime, endtime FROM tvImport ORDER BY channelID, starttime</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE Len(RTrim(LTrim(endtime))) = 0 OR endtime Is NULL</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:37 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT l.channelID, l.starttime, l.endtime FROM tvListings l, tvImport i WHERE l.channelID = i.channelID AND l.starttime = i.starttime AND (l.title <> i.title OR l.endtime <> i.endtime) ORDER BY l.starttime</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT c.channelID, c.channelName, l.starttime, l.endtime FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID ORDER BY l.channelID, l.starttime</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:45 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Finished checking data</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:45 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE importID IN (SELECT tvImport.importID FROM tvImport INNER JOIN tvlistings ON (tvImport.starttime = tvlistings.starttime) AND (tvImport.channelID = tvlistings.channelID))</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:45 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT channelID, starttime, Count(importID) AS CImportID From tvImport GROUP BY channelID, starttime Having Count(importID) > 1</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:45 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT count(importID) as totalRecords, 0 as startFrom FROM tvImport</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:45 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT channelID, starttime, endtime FROM tvImport WHERE starttime < (SELECT max(starttime) FROM tvListings) ORDER BY channelID, starttime</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:45 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=INSERT INTO tvListings (channelID, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear) SELECT channelID, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear From tvImport</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:48 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvImport</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:48 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM userChannels WHERE channelID NOT In (SELECT channelID FROM tvChannels WHERE ChannelDownload = 1 AND viewhide = 0)</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:48 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Finished data cleanup and listings import.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:48 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=INSERT INTO tvCategory (category, hideCategory,channelVR) SELECT DISTINCT l.category, 0, 0 FROM tvlistings l LEFT JOIN tvCategory c ON l.category = c.category WHERE l.category Is Not Null AND c.category Is Null AND l.category Is Not Null</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=INSERT INTO tvratings (rating, hideRating, sortorder) SELECT DISTINCT l.rating, 0, 99 FROM tvlistings l LEFT JOIN tvratings r on l.rating = r.rating WHERE l.rating Is Not Null AND r.rating Is Null</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Listings import took less than one minute.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Starting creation of all events.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT favID, deviceID, repeattype FROM userFavs WHERE isActive = 1 ORDER BY priorityLevel</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Finished creating events.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=UPDATE tvListings SET scheduledEvent = 0</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:50 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE scheduledFavs s, tvListings l, userFavs f, devices d SET l.scheduledEvent = d.deviceType WHERE l.channelID = s.channelID AND l.starttime=s.starttime AND s.favID=f.favID AND f.deviceID=d.deviceID AND s.isActive = 1 </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:50 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=UPDATE scheduledFavs s, tvListings l SET l.scheduledEvent = 4 WHERE l.channelID = s.channelID AND l.starttime=s.starttime AND s.isActive = 0 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:50 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:14:50 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Starting clean up of old xml data files.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:14:50 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Error Import Cleanup: String cannot be of zero length.Parameter name: oldValue</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:00 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Checking for Scheduled Actions</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:15 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT s.scheduledID, s.favID FROM userFavs u, scheduledFavs s WHERE u.favID = s.favID AND u.repeatType = 0 AND s.starttime < Now()</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:15 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:45 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>GenPage: name: pg = value: admin</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:45 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: debug1 = value:0</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: playQuote = value:0</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: showSQLSvr = value:0</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: dbtype1 = value:Access</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: dbname1 = value:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\HomeSeer\data\hstv\hstv.mdb</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: numdayshistory1 = value:1</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: numdaysevents1 = value:3</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: useVR = value:0</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: SaveAdmGeneral = value:Save</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/22/2008 10:15:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: ref_page = value:hstv</TD></TR></TBODY></TABLE>
Comment
-
With what you posted I have narrowed it down to where the error is.
I've sent you a PM with a link to download a new version.
Set the debugging, run the event and post the log entries again.--
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
-
Jeff,
I just unzipped the file into my HS directory. I did not restart HS. Here are the results:
<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:00 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Checking for Scheduled Actions</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:00 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Data Import: Starting data insert.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Starting data cleanup and listings import.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT Count(channelID) FROM tvListings WHERE starttime < #2008/07/22#</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>No records to delete.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvlistings WHERE starttime < #7/22/2008 12:00:00 AM#</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM scheduledFavs WHERE starttime < #2008/07/22 0:00:00#</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Deleting channels not selected for download.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:37 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=UPDATE tvImport INNER JOIN tvchannels AS c ON tvImport.channelID = c.channelID SET tvImport.channeldownload = c.channeldownload, tvImport.viewhide = c.viewhide, tvImport.channelNum = c.channelNumber</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:38 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE channelDownload = 0 OR viewHide = 1</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:41 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT importID, channelID, starttime, endtime FROM tvImport ORDER BY channelID, starttime</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:41 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE Len(RTrim(LTrim(endtime))) = 0 OR endtime Is NULL</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:41 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT l.channelID, l.starttime, l.endtime FROM tvListings l, tvImport i WHERE l.channelID = i.channelID AND l.starttime = i.starttime AND (l.title <> i.title OR l.endtime <> i.endtime) ORDER BY l.starttime</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:41 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT c.channelID, c.channelName, l.starttime, l.endtime FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID ORDER BY l.channelID, l.starttime</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Finished checking data</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE importID IN (SELECT tvImport.importID FROM tvImport INNER JOIN tvlistings ON (tvImport.starttime = tvlistings.starttime) AND (tvImport.channelID = tvlistings.channelID))</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT channelID, starttime, Count(importID) AS CImportID From tvImport GROUP BY channelID, starttime Having Count(importID) > 1</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT count(importID) as totalRecords, 0 as startFrom FROM tvImport</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:49 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT channelID, starttime, endtime FROM tvImport WHERE starttime < (SELECT max(starttime) FROM tvListings) ORDER BY channelID, starttime</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:49 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=INSERT INTO tvListings (channelID, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear) SELECT channelID, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear From tvImport</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:52 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:52 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM userChannels WHERE channelID NOT In (SELECT channelID FROM tvChannels WHERE ChannelDownload = 1 AND viewhide = 0)</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:52 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Finished data cleanup and listings import.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:52 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=INSERT INTO tvCategory (category, hideCategory,channelVR) SELECT DISTINCT l.category, 0, 0 FROM tvlistings l LEFT JOIN tvCategory c ON l.category = c.category WHERE l.category Is Not Null AND c.category Is Null AND l.category Is Not Null</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:52 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=INSERT INTO tvratings (rating, hideRating, sortorder) SELECT DISTINCT l.rating, 0, 99 FROM tvlistings l LEFT JOIN tvratings r on l.rating = r.rating WHERE l.rating Is Not Null AND r.rating Is Null</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:53 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Listings import took less than one minute.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:53 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Starting creation of all events.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:53 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT favID, deviceID, repeattype FROM userFavs WHERE isActive = 1 ORDER BY priorityLevel</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:53 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Finished creating events.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:53 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE tvListings SET scheduledEvent = 0</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:54 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=UPDATE scheduledFavs s, tvListings l, userFavs f, devices d SET l.scheduledEvent = d.deviceType WHERE l.channelID = s.channelID AND l.starttime=s.starttime AND s.favID=f.favID AND f.deviceID=d.deviceID AND s.isActive = 1 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:54 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE scheduledFavs s, tvListings l SET l.scheduledEvent = 4 WHERE l.channelID = s.channelID AND l.starttime=s.starttime AND s.isActive = 0 </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:54 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:32:54 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Starting clean up of old xml data files.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:32:54 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Error Import Cleanup: String cannot be of zero length.Parameter name: oldValue</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:00 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Checking for Scheduled Actions</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:00 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:51 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>GenPage: name: pg = value: admin</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:51 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: debug1 = value:0</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: playQuote = value:0</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: showSQLSvr = value:0</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: dbtype1 = value:Access</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: dbname1 = value:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\HomeSeer\data\hstv\hstv.mdb</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: numdayshistory1 = value:1</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: numdaysevents1 = value:3</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: useVR = value:0</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>PagePut: name: SaveAdmGeneral = value:Save</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/23/2008 7:33:56 PM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>PagePut: name: ref_page = value:hstv</TD></TR></TBODY></TABLE>
Comment
-
You will need to stop HomeSeer, otherwise copying the file into the HS directory will fail. You should have gotten a popup warning you that the file was in use and not able to overwrite it.
You will need to:
Stop HomeSeer
Copy the file to the HomeSeer directory
Restart HomeSeer--
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
-
Jeff,
I stopped HS, copied the file (don't know what I did before), re-started HS and ran the import event. I did not see any errors, but here is the log:
<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Data Import: Starting data insert.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Starting data cleanup and listings import.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT Count(channelID) FROM tvListings WHERE starttime < #2008/07/23#</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>No records to delete.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvlistings WHERE starttime < #7/23/2008 12:00:00 AM#</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM scheduledFavs WHERE starttime < #2008/07/23 0:00:00#</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Deleting channels not selected for download.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE tvImport INNER JOIN tvchannels AS c ON tvImport.channelID = c.channelID SET tvImport.channeldownload = c.channeldownload, tvImport.viewhide = c.viewhide, tvImport.channelNum = c.channelNumber</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:50 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE channelDownload = 0 OR viewHide = 1</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:53 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT importID, channelID, starttime, endtime FROM tvImport ORDER BY channelID, starttime</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:53 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE Len(RTrim(LTrim(endtime))) = 0 OR endtime Is NULL</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 7:59:53 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT l.channelID, l.starttime, l.endtime FROM tvListings l, tvImport i WHERE l.channelID = i.channelID AND l.starttime = i.starttime AND (l.title <> i.title OR l.endtime <> i.endtime) ORDER BY l.starttime</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 7:59:53 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT c.channelID, c.channelName, l.starttime, l.endtime FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID ORDER BY l.channelID, l.starttime</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:00 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Checking for Scheduled Actions</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:02 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Finished checking data</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:02 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM tvImport WHERE importID IN (SELECT tvImport.importID FROM tvImport INNER JOIN tvlistings ON (tvImport.starttime = tvlistings.starttime) AND (tvImport.channelID = tvlistings.channelID))</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:02 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT channelID, starttime, Count(importID) AS CImportID From tvImport GROUP BY channelID, starttime Having Count(importID) > 1</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:02 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT count(importID) as totalRecords, 0 as startFrom FROM tvImport</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:02 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT channelID, starttime, endtime FROM tvImport WHERE starttime < (SELECT max(starttime) FROM tvListings) ORDER BY channelID, starttime</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:02 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=INSERT INTO tvListings (channelID, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear) SELECT channelID, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear From tvImport</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:05 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM tvImport</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM userChannels WHERE channelID NOT In (SELECT channelID FROM tvChannels WHERE ChannelDownload = 1 AND viewhide = 0)</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Finished data cleanup and listings import.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=INSERT INTO tvCategory (category, hideCategory,channelVR) SELECT DISTINCT l.category, 0, 0 FROM tvlistings l LEFT JOIN tvCategory c ON l.category = c.category WHERE l.category Is Not Null AND c.category Is Null AND l.category Is Not Null</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=INSERT INTO tvratings (rating, hideRating, sortorder) SELECT DISTINCT l.rating, 0, 99 FROM tvlistings l LEFT JOIN tvratings r on l.rating = r.rating WHERE l.rating Is Not Null AND r.rating Is Null</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Listings import took less than one minute.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Starting creation of all events.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>SELECT favID, deviceID, repeattype FROM userFavs WHERE isActive = 1 ORDER BY priorityLevel</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Finished creating events.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE tvListings SET scheduledEvent = 0</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=UPDATE scheduledFavs s, tvListings l, userFavs f, devices d SET l.scheduledEvent = d.deviceType WHERE l.channelID = s.channelID AND l.starttime=s.starttime AND s.favID=f.favID AND f.deviceID=d.deviceID AND s.isActive = 1 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=UPDATE scheduledFavs s, tvListings l SET l.scheduledEvent = 4 WHERE l.channelID = s.channelID AND l.starttime=s.starttime AND s.isActive = 0 </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Starting clean up of old xml data files.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Deleting file: tv_grab_na_dd20080718.xml</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Deleting file: tv_grab_na_dd20080719.xml</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Deleting file: tv_grab_na_dd20080720.xml</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Deleting file: tv_grab_na_dd20080721.xml</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Deleting file: tv_grab_na_dd20080722.xml</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:07 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Deleting file: tv_grab_na_dd20080723.xml</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Deleting file: tv_grab_na_dd20080724.xml</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Finished cleaning up old xml files.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Starting clean up of HSTV events.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>sql=DELETE * FROM scheduledFavs WHERE favID NOT IN (SELECT favID FROM userFavs) </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>sql=DELETE * FROM scheduledFavs WHERE scheduledID IN (SELECT s.scheduledID FROM scheduledFavs s LEFT OUTER JOIN tvListings l ON s.starttime = l.starttime AND s.channelID = l.channelID WHERE l.starttime IS NULL)</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Finished cleaning up old HSTV scheduled events.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT Max(starttime), Min(starttime) FROM tvListings</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:08 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Finished import cleanup.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:00:15 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>SELECT s.scheduledID, s.favID FROM userFavs u, scheduledFavs s WHERE u.favID = s.favID AND u.repeatType = 0 AND s.starttime < Now()</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:00:15 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/24/2008 8:01:00 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Checking for Scheduled Actions</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/24/2008 8:01:00 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>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 </TD></TR></TBODY></TABLE>
Comment
-
I see in the log where it said it was deleting the old xml files.
Can you confirm that they are gone?
If so, then the new version seems to have fixed the problem.--
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
-
Originally posted by CFGuy View PostI see in the log where it said it was deleting the old xml files.
Can you confirm that they are gone?
If so, then the new version seems to have fixed the problem.
tv_grab_na_dd20080725.xml
tv_grab_na_dd20080726.xml
tv_grab_na_dd20080727.xml
tv_grab_na_dd20080728.xml
tv_grab_na_dd20080729.xml
tv_grab_na_dd20080730.xml
I also did not see the "Trigger Expire Date: Object reference not set to an instance of an object." Error. Did this version correct that also?
Thanks...John
Comment
-
Yes, the version you have fixed the Object error.
I will update the zip file and post it for others.--
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
-
Uh Oh...
This was from my automated morning run. I don't know if the problem is completely resolved.
<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime1 noWrap align=left>7/25/2008 5:32:24 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Error Query: SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/25/2008 5:32:24 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Error Select Query: Operation is not allowed when the object is open.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/25/2008 5:32:24 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Error Import Cleanup: Operation is not allowed when the object is closed.</TD></TR></TBODY></TABLE>
Comment
-
Jeff,
Very strange... These errors occured during a time other than my 5AM scheduled events:
<TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>/27/2008 12:31:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/27/2008 12:31:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Error Select Query: Operation is not allowed when the object is open.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/27/2008 12:31:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>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 </TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>7/27/2008 12:31:06 AM </TD><TD class=LOGType1 align=left colSpan=3>HSTV </TD><TD class=LOGEntry1 align=left colSpan=8>Error Select Query: Operation is not allowed when the object is closed.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>7/27/2008 12:31:06 AM </TD><TD class=LOGType0 align=left colSpan=3>HSTV </TD><TD class=LOGEntry0 align=left colSpan=8>Error Next Scheduled: Operation is not allowed when the object is closed.</TD></TR></TBODY></TABLE>
Comment
-
Is this error happening every day? At different times?
I really don't think it's a bug fix as that code runs every minute to see if there are any new events to trigger.--
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
-
Jeff, It is not happening every day. Here is a log of the errors since July 27th:
<TABLE id=FilterGridView style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px" cellSpacing=1 cellPadding=0 rules=all border=0><TBODY><TR class=tablerowodd><TD>7/27/2008 12:31:06 AM</TD><TD>HSTV</TD><TD>Error Select Query: Operation is not allowed when the object is open.</TD></TR><TR class=tableroweven><TD>7/27/2008 12:31:06 AM</TD><TD>HSTV</TD><TD>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</TD></TR><TR class=tablerowodd><TD>7/27/2008 12:31:06 AM</TD><TD>HSTV</TD><TD>Error Select Query: Operation is not allowed when the object is closed.</TD></TR><TR class=tableroweven><TD>7/27/2008 12:31:06 AM</TD><TD>HSTV</TD><TD>Error Next Scheduled: Operation is not allowed when the object is closed.</TD></TR><TR class=tablerowodd><TD>7/27/2008 12:31:06 AM</TD><TD>HSTV</TD><TD>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</TD></TR><TR class=tableroweven><TD>7/30/2008 5:33:00 AM</TD><TD>HSTV</TD><TD>Error Select Query: Operation is not allowed when the object is open.</TD></TR><TR class=tablerowodd><TD>7/30/2008 5:33:00 AM</TD><TD>HSTV</TD><TD>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</TD></TR><TR class=tableroweven><TD>7/30/2008 5:33:01 AM</TD><TD>HSTV</TD><TD>Error Next Scheduled: Operation is not allowed when the object is closed.</TD></TR><TR class=tablerowodd><TD>7/31/2008 5:32:51 AM</TD><TD>HSTV</TD><TD>Error Select Query: Operation is not allowed when the object is open.</TD></TR><TR class=tableroweven><TD>7/31/2008 5:32:51 AM</TD><TD>HSTV</TD><TD>Error Query: SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID</TD></TR><TR class=tablerowodd><TD>7/31/2008 5:32:51 AM</TD><TD>HSTV</TD><TD>Error Select Query: Operation is not allowed when the object is closed.</TD></TR><TR class=tableroweven><TD>7/31/2008 5:32:51 AM</TD><TD>HSTV</TD><TD>Error Import Cleanup: Operation is not allowed when the object is closed.</TD></TR><TR class=tablerowodd><TD>7/31/2008 5:32:51 AM</TD><TD>HSTV</TD><TD>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</TD></TR><TR class=tableroweven><TD>8/3/2008 5:32:01 AM</TD><TD>HSTV</TD><TD>Error Import Cleanup: Operation is not allowed when the object is closed.</TD></TR><TR class=tablerowodd><TD>8/3/2008 5:32:01 AM</TD><TD>HSTV</TD><TD>Error Query: SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID</TD></TR><TR class=tableroweven><TD>8/3/2008 5:32:01 AM</TD><TD>HSTV</TD><TD>Error Select Query: Operation is not allowed when the object is open.</TD></TR></TBODY></TABLE>
Comment
Comment