Enhanced web admin connect problem.

[ggee]

I seen to always run into this problem. Is there some setting I need to do to get this to work reliably? I am still running v30. I can' seem to get to the wiki to download anything newer right now.
Unspecified error

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

Source Error:

Line 72: {
Line 73: zapConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseFileName );
Line 74: zapConnection.Open();
Line 75: }
Line 76:
Source File: C:\Program Files\devnz\gbpvr\web\ZapTools.cs Line: 74

Stack Trace:

[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +51
System.Data.OleDb.OleDbConnection.Open() +203
gbweb.ZapTools.OpenZapDB() in C:\Program Files\devnz\gbpvr\web\ZapTools.cs:74
gbweb.Manage.Page_Load(Object sender, EventArgs e) in C:\Program Files\devnz\gbpvr\web\Manage.aspx.cs:94
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +750

[UncleJohnsBand]

I seen to always run into this problem. Is there some setting I need to do to get this to work reliably? I am still running v30. I can' seem to get to the wiki to download anything newer right now.
Unspecified error

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

Source Error:

Line 72: {
Line 73: zapConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + databaseFileName );
Line 74: zapConnection.Open();
Line 75: }
Line 76:
Source File: C:\Program Files\devnz\gbpvr\web\ZapTools.cs Line: 74

Stack Trace:

[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +51
System.Data.OleDb.OleDbConnection.Open() +203
gbweb.ZapTools.OpenZapDB() in C:\Program Files\devnz\gbpvr\web\ZapTools.cs:74
gbweb.Manage.Page_Load(Object sender, EventArgs e) in C:\Program Files\devnz\gbpvr\web\Manage.aspx.cs:94
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +750

This tells me you have zapdb.mdb file located in your GBPVR directory....is that correct?

[ggee]

Yes, it is. I finally got upgraded to v31 and still same error appears. It's a really strange problem. Even when I click on the stats page, I get the following. But if I hit refresh enough times, it finally comes up.

Line 80: // create the database connection
Line 81: OleDbConnection aConnection = new OleDbConnection(databaseConnectionString);
Line 82: aConnection.Open();
Line 83:
Line 84: try

[UncleJohnsBand]

Just to make sure.....you want to use the extended ZapTools data....that is what is held in the Zapdb.mdb.

[ggee]

Ok, now I'm confused. Are there other tools that I need to install? I'm not sure what these extended zaptools data is. I just unzipped into folder and started using the web interface. Is there something I need to configure?

Thanks,
Greg

[UncleJohnsBand]

Ok, now I'm confused. Are there other tools that I need to install? I'm not sure what these extended zaptools data is. I just unzipped into folder and started using the web interface. Is there something I need to configure?

Thanks,
Greg

Ahhh.......ok....do this...open a command window in at your GBPVR directory and run zapimport userid password....where userid and password are your userid and password for your zap2it account.

After it completes then try the web admin....

Let me know what happens.

[ggee]

Ahhh.......ok....do this...open a command window in at your GBPVR directory and run zapimport userid password....where userid and password are your userid and password for your zap2it account.

After it completes then try the web admin....

Let me know what happens.

Ok. I'll try. What does this tool do? Does it do the same as the builtin zap2it EPG download? If GBPVR is getting my EPG from zap2it, do I need to run this?

Greg

[ggee]

Well, I guess I'll have to wait untit zap2it is running again. I am having problems logging in. Seems t be timing out.

Greg

[UncleJohnsBand]

Ok. I'll try. What does this tool do? Does it do the same as the builtin zap2it EPG download? If GBPVR is getting my EPG from zap2it, do I need to run this?

Greg

It provieds extended data for Zap2it users in the Enhanced Web Admin. This includes Repeat information as well as Cast/Crew information for the show. The cast and crew info provides links to IMDB for everyone that is listed for the show.

It also used to provide the Rating and Genre information but as of the upcomming release of the web admin they both will be pulled from the native GBPVR database since they are now being captured nativley. The version (31) that you are using pulls the rating from there but the Genre is still pulled from the extended data.

If you don't wnat any of this simply delete the zapdb.mdb file....if that isn't found then the web admin won't try to open it.

If you do want this data then you need to keep the database updated on a regular basis...this is done by running the zapimport program out of the postupdate.epg.bat file so it runs automatically after GBPVR updates its data. The instuctions are on the wiki.

[ggee]

So I renamed the file zapdb.mdb to zapdb.mdb.old and restarted gbpvr. I still get the same behaviour. The bigger problem is that it is not predictable. One second, I can get guide data and the next, it is empty.

Even the stats page acts up. One second it works, and the next, I get the following. Am I missing some patches or something?

Line 80: // create the database connection
Line 81: OleDbConnection aConnection = new OleDbConnection(databaseConnectionString);
Line 82: aConnection.Open();
Line 83:
Line 84: try