Enhanced Web Admin

[normanr]

I am fairly new to GB PVR but I am really loving it so far. Yesterday I decided to install the build 24 Enhanced Web Admin plugin/util. Everything looked fine when I went to the Guide page but as soon as I clicked on anything I would receive an Error page. I tried to go to Admin.aspx and I noticed in the trace of the error page that stated that it was attempting to go to c:\program files\devnz\gbpvr\web\admin.aspx.cs. I installed GB PVR under c:\program files\gbpvr\ without "devnz". Is there someplace where I can change where the aspx files are looking for each other? Thanks for any help.

The stack trace paths are compiled in at build time, they're only used for informational purposes when a stack trace is displayed. Of more use is the actual stack trace. Paste yours here and we'll have a look.

[jsteele]

When you loaded zaptools did you make sure to load the latest zapdb.mdb file? When you look in the zapdb.mdb file do you see the following table:

GBPVR_Recordings

Zapimport appears to be failing on the step that deletes all the entries from this table....prior to the 8/2 release this table was not in the zapdb.mdb and you had to replace your existing one with the new zapdb.mdb that has the new table.

Let me know.

I've reinstalled ZAPTOOLS from scratch just in case this has happened. I'll let you know what happens.

[drugstore_cowboy]

Hey UncleJohnsBand and Normanr

I had an issue with the database locking but I also access it across my network. The problem is that when compacting the database there is an issue with Access where it will set the permissions of the temp folder to the database file - a simple workaround for this is to set the permissions for everyone to "full access" (providing that you have changed the security settings to show advanced vs the simple security). This totally resolved all of my issues and I can now open the database across my network without any issues.

NormanR - any word on using the statistics across a network? I ahve set my config.xml file to use UNC's but it doesn't like them and I am not sure I am willing to point everything to a mapped drive (you can do some funky thing with XP where you can mount a folder to a drive letter without the use of third party software).

Hope this helps - I only really glanced at the issue described as I am really short on time - damn it my dog is about to pee in the house ... gotta go

[normanr]

I had an issue with the database locking but I also access it across my network. The problem is that when compacting the database there is an issue with Access where it will set the permissions of the temp folder to the database file - a simple workaround for this is to set the permissions for everyone to "full access" (providing that you have changed the security settings to show advanced vs the simple security). This totally resolved all of my issues and I can now open the database across my network without any issues.

You can probably change the settings for the account that is accessing the files instead of using 'everyone'.

NormanR - any word on using the statistics across a network? I have set my config.xml file to use UNC's but it doesn't like them and I am not sure I am willing to point everything to a mapped drive (you can do some funky thing with XP where you can mount a folder to a drive letter without the use of third party software).

Haven't had time to look. I doubt that mapped drives will work, because you'll map the drives in your user's local login session, which is not the same as the recording service's session running in the background.

[jsteele]

UncleJohnsBand
I'm still getting failures at ZAPTOOLS invocation. This is the log that it created:
---------------

Using Path C:\Program Files\devnz\gbpvr\

Start downloading Zap EPG data...
Completed download of Zap EPG data...

Begining zapdb.mdb update process...

Removing GBPVR Recording Entries...


---------------
It is throwing some kind of exception when it ZAPTOOLS executes. It apparently fails and leaves the ZAPTOOLS.MDB in an indeterminate state.

UncleJohnsBand:

Zapimport ran last night and here is the result (from the Command Window):
-----------------------
sing Path C:\Program Files\devnz\gbpvr\

Start downloading Zap EPG data...
Completed download of Zap EPG data...

Begining zapdb.mdb update process...

Removing GBPVR Recording Entries...
Loading GBPVR Recording Entries...
Removing Program Data without a corresponding GPBR Recording...
Removing Schedule Data without a corresponding GPBR Recording...
Removing Genre Data without a corresponding GPBR Recording...
Removing Crew Data without a corresponding GPBR Recording...

Opening zapdb.mdb for loading of new EPG data...

Loading downloaded Zap EPG XML data...
Total Loaded 15693

Loading zapdb.mdb with new Zap EPG data...

Loading up schedules...
root xtvd
children 6
Loading up channels...
Loading up programs...
Loading up crew...
Loading up generes...
Closing zapdb.mdb...

End zapdb.mdb update process...

Begin cleanup process...

Begin compact of zapdb.mdb...

----------------
At which point it opens the Debugging Services dialog and reports and exception that could not be handled
Process id=0xaa0 (2720), Thread id=0xbb8 (3000)

Any help?

John

[martinatime]

The stack trace paths are compiled in at build time, they're only used for informational purposes when a stack trace is displayed. Of more use is the actual stack trace. Paste yours here and we'll have a look.

Here is the Error page text I get when I go to the guide (which displays fine) then click on a show. I'm not seeing the Error that I saw before with the "devnz" in the path but I am still getting errors. The pop-up, that should display show details, displays with the following as contents:

Server Error in '/gbpvr' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
gbweb.Details.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +750




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

****************************************************8
And if I hit the Config Tab this is what I get:
Server Error in '/gbpvr' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
gbweb.Admin.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +750




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

[martinatime]

At which point it opens the Debugging Services dialog and reports and exception that could not be handled
Process id=0xaa0 (2720), Thread id=0xbb8 (3000)

Any help?

John

I too am getting this error.

[UncleJohnsBand]

UncleJohnsBand:

Zapimport ran last night and here is the result (from the Command Window):
-----------------------
----------------
At which point it opens the Debugging Services dialog and reports and exception that could not be handled
Process id=0xaa0 (2720), Thread id=0xbb8 (3000)

Any help?

John

This is actually good news....everything with the zapimport process is working correctly....the compact is the culprit. This is the same problem that someone else had that revolved around the invalid msjro.dll registration.

Since you re-registered the dll it must be something elese in the process.

When you right click on C:\Program Files\Common Files\System\ADO\msjro.dll what version is it showing?

Also....replace your zapinterface.dll file in your gbpvr directory with the zapinterface.dll file located in the attached zip file. It contains debug displays in the compact process and I also moved the creation of the temp .mdb file from the users temp directory to the all users temp directory so it should be created with open access for all users.

Run zapimport from a command line after replacing the dll and post the log information. You can run zapimport as many times as you want in a day you won't loose any data.

[jsteele]

When you right click on C:\Program Files\Common Files\System\ADO\msjro.dll what version is it showing?

ver 2.81.1117.0

I also found that for whatever reason msjro.dll was not in system32, it was in system32/dllcache. I copied it and reregistered it in system32

Run zapimport from a command line after replacing the dll and post the log information. You can run zapimport as many times as you want in a day you won't loose any data.

Guess what. Now it ran fine! Maybe the DLL being in the wrong place :-)

[normanr]

Here is the Error page text I get when I go to the guide (which displays fine) then click on a show. I'm not seeing the Error that I saw before with the "devnz" in the path but I am still getting errors. The pop-up, that should display show details

I noticed that there are no paths or line numbers, this information is in the pdb file. Has the pdf been moved or delete by mistake? Can you check that the pdb is around and then paste the stack traces with paths and (more importantly) line numbers.