EPGExtra utility - support

[reets]

I installed Win XP 64 fresh, formatted and new partitions.

I have both of those entries in there now. the Wow6432 was always there and I added the other like you said. I have tried removing the one I created and still get the same err. It makes no sense that it can't find the file. Any chance you could make a build that outputs the full path it is looking for to load the SQLite dll from? Just before it says Updating GBPVR database... ?

[ubu]

I installed Win XP 64 fresh, formatted and new partitions.

I have both of those entries in there now. the Wow6432 was always there and I added the other like you said. I have tried removing the one I created and still get the same err. It makes no sense that it can't find the file. Any chance you could make a build that outputs the full path it is looking for to load the SQLite dll from? Just before it says Updating GBPVR database... ?

Actually, it's not EPGExtra looking for the SQLite dll. It's Windows .Net trying to resolve the dll reference. And it's looking in the same directory that EPGExtra is being executed from (ie. the gbpvr dir).

EPGExtra looks in your config.xml to find out which DB you're using and to find out how to connect to it. Since it's looking for the SQLite dll, it must have found these lines:

Code:

<DatabaseConnectionString>Data  Source=".\gbpvr.db3";Version=3;New=True;</DatabaseConnectionString>  
<DatabaseProviderFactory>System.Data.SQLite.SQLiteFactory</DatabaseProviderFactory>

Maybe double check, but I'm guessing they're correct because EPGExtra then tries to set the provider factory and I'm pretty sure that's where you're encountering the error.

If you are seeing "exactly" the same error message as the one you posted earlier, you'll notice that it doesn't say it can't find System.Data.SQLite.dll but rather that it has an "incorrect format". So that would suggest that your copy of the dll has become corrupted or is invalid in some way.

Presumably, you re-installed GB-PVR after installing Win x64. What version did you install? If you installed a fairly recent version, the SQLite dll that was installed should be version 1.0.30.1 (which is the one EPGExtra is compiled with). Maybe check that it is, indeed, the correct version and also that you don't have any other copies of System.Data.SQLite.dll elsewhere that .Net could be picking up instead.

The wierd part is that, if your SQLite dll is corrupted or invalid, you should be encountering problems running GB-PVR itself, since it's using the same dll to access your gbpvr.db3 database.

[reets]

It is strange indeed, and GBPVR doesn't have any issues with db access. I did a bunch of stuff in GBPVR to make it use the DB and it works fine. The version # is correct and I searched my HD and no extra/strange/diff ver SQLite files. This is extremely wierd.

[ubu]

It is strange indeed, and GBPVR doesn't have any issues with db access. I did a bunch of stuff in GBPVR to make it use the DB and it works fine. The version # is correct and I searched my HD and no extra/strange/diff ver SQLite files. This is extremely wierd.

And you checked config.xml to make sure GB-PVR is really using SQLite and not MS-Access? (Grasping at straws now!). You could try renaming gbpvr.db3 to see if that screws up GB-PVR (that would ensure that it really is using SQLite).

Hmmm. I don't think it's even getting into my db code. There's an outer wrapper (that's the EPGTweakEngine you see in the error message). It's already read the zap2it data and now it calls the constructor of GbpvrDb (that's the only class I have that uses SQLite). If it got into the code at all you'd see "...using System.Data.SQLite.SQLiteFactory DB Provider Factory" in the output. But you don't. So it's throwing an exception immediately that class gets referenced.

The only thing you have to go on is the error message itself. It definitely doesn't like your SQLite dll - that's for sure. You could try using a SQLite viewer (SQLite Spy, SQLite Db Browser) to see if that can read your database. Presumably, they use the same dll so that would give you some kind of triangulation point.

EPGExtra has been downloaded over 1200 times (and I assume at least some of those folks are running XP64) and nobody has reported a similar problem. So I'm kinda stumped. :confused:

[reets]

I don't doubt it something weird or messed up over here. It worked fine on my system a long time ago just fine (2 formats ago).

This is my config.xml info for Db, should be using SQLite.

Code:

<!-- Database settings -->
<DatabaseConnectionString>Data Source=".\gbpvr.db3";Version=3;New=True;</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.SQLite.SQLiteFactory</DatabaseProviderFactory>
<DatabaseIdentityQuery>select last_insert_rowid()</DatabaseIdentityQuery>

I have already tried SQLite Control Center (sqlite-cc) and it loads db's and stuff fine. Loaded the gbpvr db3 file just fine. Are you using #Dev to make your apps? If so I will try to make a quick SQLite app to see if it works (or I'll use VS.net if that's what you are using).

[ubu]

I don't doubt it something weird or messed up over here. It worked fine on my system a long time ago just fine (2 formats ago).

This is my config.xml info for Db, should be using SQLite.

Code:

<!-- Database settings -->
<DatabaseConnectionString>Data Source=".\gbpvr.db3";Version=3;New=True;</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.SQLite.SQLiteFactory</DatabaseProviderFactory>
<DatabaseIdentityQuery>select last_insert_rowid()</DatabaseIdentityQuery>

Looks right.

I have already tried SQLite Control Center (sqlite-cc) and it loads db's and stuff fine. Loaded the gbpvr db3 file just fine. Are you using #Dev to make your apps? If so I will try to make a quick SQLite app to see if it works (or I'll use VS.net if that's what you are using).

I'm using Visual C# 2005 Express Edition. If you want a copy of my source code, you can get it here. I wrote it a while back and I never got a chance to go back and clean it up so it lacks a certain elegance. Nonetheless, you should be able to figure out how it all fits together.

Maybe looking at the source will give you a few clues. I hope so.

Happy trails!

[reets]

First off, I don't know C# so I couldn't really modify the code at all. All I did was remove the SQLite reference, added it again, and in SharpDevelop I specified it to compile for 32-bit processor and it worked. Very strange indeed but once I did all that, BAM!

Checked the TV listings and they are indeed updated with all the new information. Not sure what made it work, either the re-reference of the SQLite DLL or the option in SharpDevelop to compile for 32-bit processor (the default option is ANY processor).

If you want me to upload the file and/or source from what I did just say so and I will. Thanks for all the help getting this working though VERY appreciated!

[bobsmith]

I'm using EPGExtra and I really like it. However, I'm having some difficulties with recording so I checked the CPU and noticed that epgextra.exe was using 95%+ (when gbpvr wasn't running). I wondered why my system was so sluggish, and that appears to be the reason. So I'd like to uninstall EPGExtra completely until I can figure out what is going on.

I used the -undo parameter to rollback, and that did seem to release the CPU for other tasks. EPGExtra.exe is still in the gbpvr directory, however, and I'm reluctant to remove it because I don't know what other entries still remain in other files.

How do I remove EPGExtra completely? Is it just a matter of running the undo parameter and then deleting epgextra.exe from the gbpvr directory? Is there any need to manually edit any files? Thanks.

[ubu]

I'm using EPGExtra and I really like it. However, I'm having some difficulties with recording so I checked the CPU and noticed that epgextra.exe was using 95%+ (when gbpvr wasn't running). I wondered why my system was so sluggish, and that appears to be the reason. So I'd like to uninstall EPGExtra completely until I can figure out what is going on.

I used the -undo parameter to rollback, and that did seem to release the CPU for other tasks. EPGExtra.exe is still in the gbpvr directory, however, and I'm reluctant to remove it because I don't know what other entries still remain in other files.

How do I remove EPGExtra completely? Is it just a matter of running the undo parameter and then deleting epgextra.exe from the gbpvr directory? Is there any need to manually edit any files? Thanks.

EPGExtra is a completely standalone utility so deleting the exe file would uninstall it. However, I'm not sure I understand why you want to uninstall it. If you want to stop it from executing automatically each time your EPG is updated, you can remove the EPGExtra line from your UpdateEPG.bat file (or comment it out). The utility won't affect your system unless you run it, either from the batch file or from the command line.

EPGExtra should only run for a few minutes at most (depending on the size of your EPG database - number of stations, number of days, etc.). During that time it could use 95% of your CPU, especially if nothing else is running, since it will use whatever resources are available to it. If it runs for longer than that, there may be something wrong with the xml file GBPVR has downloaded from Zap2it or your EPG database may be corrupted. What does the EPGExtra.log file contain after it has executed. Also, are there any error messages in the GBPVRRecordingService.exe.log?

The -undo parameter simply causes EPGExtra to remove any additional data it has added to the program description column of the program listings. So it is very unlikely to affect your CPU issue one way or the other.

If your EPG database entries are corrupted, that could explain both your "difficulties" with recording and any issues with EPGExtra. You could try using the Empty EPG and Update EPG buttons on the Recording Source panel in the GBPVR config app in order to start with a fresh EPG. I think you may have to reschedule any pending recordings if you do that.

EDIT: Just noticed this thread. Seems like some people have been having problems with the Zap2it data. Could be related?

[bobsmith]

I did as you suggested. First, I checked the epgextra.log file - I didn't know there was one. Now I think I know what occurred. I suspect that I just happened to check the CPU at precisely the time that EPGExtra was doing its thing, which was pure coincidence. Then I ran the -undo parameter and checked again. By the time I ran -undo and rechecked the CPU, EPGExtra was done doing its thing, and was no longer running. So it appeared to me that the -undo parameter had unloaded EPGExtra and released the CPU, which clearly was not the case. The epgextra.log file included the run time (6:58:10 PM until 7:11:03 PM) and I think that was about when I was checking the CPU.

I went in and emptied the EPG, and updated it. It appeared to go without a hitch. However, the pending recordings were still there after I finished - so I'm not sure. I did delete some channels I never use, and they were gone when I checked the episode guide, so that leads me to believe that the original EPG was actually deleted, but I really don't know for sure due to the pending recordings remaining. Actually, I emptied/updated the guide twice - and both times the pending recordings remained. So maybe pending recordings don't always get blown away with an EPG empty/update???

Anyway, your comments were very helpful. I think I understand how EPGExtra works now, and I'm just going to leave it alone. I like it a lot. My recording problems have to do with video (especially at the start) jumping from one scene to the next, with a few pieces of the show completely clipped out. Here's the error message:

007-03-29 07:58:56.686 ERROR [5] Unabled to save ScheduledRecording: The database file is locked database is locked
2007-03-29 07:58:56.686 ERROR [5] at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)

I set LogSQL to "true" in config.xml, and sub is going to check the logs when/if it occurs again.

Just one more question... if EPGExtra just happened to run when a recording was scheduled to start, do you think that could create a hiccup on a low-end PC like mine (specs in sig below)? I noticed that it ran from 6:58 - 7:11 PM yesterday, and one of the shows that had an error (Ghost Whisperer) started during that time-frame - but another (Grey's Anatomy) started an hour later. Does EPGExtra run at the same time every day? Is there a way to set a specific run time?

Thanks for the help.