Canada
TV-Server Version: SVN 16420
MediaPortal Version: RC3 16420
MediaPortal Skin: XFace
Windows Version: XP SP2
CPU Type: Intel Pentium D 3.2GHz
HDD: Seagate 120GB
Memory: 1 GB DDR2
Motherboard: Dell XPS Gen2
Motherboard Chipset: Intel 82801
Motherboard Bios: Dell A12
Video Card: ATI 9800 XT
Video Card Driver: 6.14.10.6618
Sound Card: Create SoundBlaster Audigy 2
Sound Card AC3: coaxial out
Sound Card Driver: 5.12.4..1196
1. TV Card: Twinhan 1020g
1. TV Card Type: DVB-S
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: NVidia PureVideo 2.07
MPEG2 Audio Codec: ffdshow tryouts 20070319
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote: MediaCenter Compat
TV: SamSung 4661F
TV - HTPC Connection: HDMI
Must be getting tired. I put this in wrong forum twice.
Finally it is in the right spot.
kept having a problem downloading the dvb epg if I hadn't updated it in a while. I would turn off MyTV to let it download, and the server would crash. I would do this repeatedly and eventually it would work. I finally got some time to look at it and it turns out the the SQL connection is timing out because of the amount of "dead" entries. In the tv.log there is this:
2007-11-06 19:12:53.250000 [EPG Update thread]: Tvservice stopped due to a app domain exception Error: StatementErrorUnclassified
Gentle.Common.GentleException: delete from Program where endTime < '20071105 19:12:18'; ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
So I started sql server management studio express and manually ran the command (it deleted around 61000 entries). It took about 45 seconds. The next time I tried to update the epg, it worked fine.
MediaPortal Version: RC3 16420
MediaPortal Skin: XFace
Windows Version: XP SP2
CPU Type: Intel Pentium D 3.2GHz
HDD: Seagate 120GB
Memory: 1 GB DDR2
Motherboard: Dell XPS Gen2
Motherboard Chipset: Intel 82801
Motherboard Bios: Dell A12
Video Card: ATI 9800 XT
Video Card Driver: 6.14.10.6618
Sound Card: Create SoundBlaster Audigy 2
Sound Card AC3: coaxial out
Sound Card Driver: 5.12.4..1196
1. TV Card: Twinhan 1020g
1. TV Card Type: DVB-S
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: NVidia PureVideo 2.07
MPEG2 Audio Codec: ffdshow tryouts 20070319
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply:
Remote: MediaCenter Compat
TV: SamSung 4661F
TV - HTPC Connection: HDMI
Must be getting tired. I put this in wrong forum twice.
Finally it is in the right spot.kept having a problem downloading the dvb epg if I hadn't updated it in a while. I would turn off MyTV to let it download, and the server would crash. I would do this repeatedly and eventually it would work. I finally got some time to look at it and it turns out the the SQL connection is timing out because of the amount of "dead" entries. In the tv.log there is this:
2007-11-06 19:12:53.250000 [EPG Update thread]: Tvservice stopped due to a app domain exception Error: StatementErrorUnclassified
Gentle.Common.GentleException: delete from Program where endTime < '20071105 19:12:18'; ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
So I started sql server management studio express and manually ran the command (it deleted around 61000 entries). It took about 45 seconds. The next time I tried to update the epg, it worked fine.