2006-06-07, 06:58 AM
madcat Wrote:Well, sorry all for dragging you through this goose chase for nothing.Not to worry. Nobody else has had too many issues with getting EPGExtra working, so I guess I've got off lightly.
Quote: changed in Config to Zap2It, let it update, finished successfully. Got C:\Zap2It.xml !!Not entirely. But let's look on the bright side. You are running an apparently successful EPG update using the Zap2it plugin. The c:\zap2it file must be good because, as you can see, EPGExtra read data for 6817 programs from it. Then, for each program it read, it built a template to update the description and then tried to update the program data in the gbpvr database. The sad part is that it didn't find any of those programs in the gbpvr database. Which is pretty strange. :confused:
Ran the EPGExtra.exe manually from CMD:
Code:Start time: 01:19:00
Reading program data from Zap2it.xml.....
Programs read: 6817
Updating GBPVR database program descriptions.....
...using System.Data.SQLite.SQLiteFactory DB Provider Factory
Rows updated: 0.....
Rows updated: 0.....
Rows updated: 0.....
Rows updated: 0.....
Rows updated: 0.....
Rows updated: 0.....
A total of 0 GBPVR program descriptions successfully updated.
Stop time: 01:21:05
Elapsed time: 2.090 minutes.
Is this normal? "total of 0 "??
So, what could cause this? If the update put the programs in the zap2it.xml file it implies that it put them in the gbpvr SQLite database also. If it's not finding them that must mean either the database didn't get updated or that, somehow, you are pointing at a different SQLite .db3 file.
Do you have more than one copy of GB-PVR installed (or even vestiges of an older installation)? EPGExtra locates the gbpvr database by reading the Windows registry to find where you have GB-PVR installed and then reads the config.xml file to see if you are using MS Access or SQLite. You could also try a Windows Find on "*.db3" to double check. From your output, it certainly seems to have found a SQLite database file somewhere.
If you don't already have a copy, download SQLite Spy (actually I prefer SQLite Db Browser - either will do) and open the gbpvr.db3 file in your gbpvr directory. Look at the "Programme" table and see if it has data. Now open the c:\zap2it.xml file in Wordpad (not Notepad, you won't be able to read it) and do a Find on "<program id". Write down a couple of these ids. Now go back to SQLite and look for these ids in the "unique_identifier" column of the Programme table (in Db Browser you select the Programme table on the Browse Data tab, click on the search button next to the table name, select the unique_identifier colum from the pull-down and enter the id value below it) and see if they exist in that database. All this will give us some clues (whether we can interpret them is another matter ).
If the last bit is making you totally glaze over, just zip up the .db3 file and the zap2it.xml file and I'll take a look.
[SIZE=1]GBPVR v1.3.11 [/SIZE][SIZE=1]HVR-1250, [/SIZE][SIZE=1]ES7300[/SIZE][SIZE=1], 4GB, GeForce 9300, LianLi, Vista.[/SIZE]
[SIZE=1]GBPVR v1.0.08 [/SIZE][SIZE=1]PVR-150, [/SIZE][SIZE=1]P4 2.26GHz, [/SIZE][SIZE=1]1GB,[/SIZE][SIZE=1] GeForce 6200, [/SIZE]Coupden, XP[SIZE=1]
[/SIZE]
Author: UbuStream plugin, UbuRadio plugin, EPGExtra utility.
[SIZE=1]GBPVR v1.0.08 [/SIZE][SIZE=1]PVR-150, [/SIZE][SIZE=1]P4 2.26GHz, [/SIZE][SIZE=1]1GB,[/SIZE][SIZE=1] GeForce 6200, [/SIZE]Coupden, XP[SIZE=1]
[/SIZE]
Author: UbuStream plugin, UbuRadio plugin, EPGExtra utility.