SearchWiz - New Plugin

[JavaWiz]

My wife just selected Search Wizard, then Keyboard, and a dialog box popped up that said Divide by Zero error with an OK button. Logs are attached.

Your logs indicate you are running version 0.4.15.

Code:

06/03/07 12:27:39:009 PM[1]        VERBOSE SearchWizTask: Constructor - ENTER
06/03/07 12:27:39:009 PM[1]        INFO    Versions:
06/03/07 12:27:39:009 PM[1]        INFO       SearchWizTask: Version: 0.4.15.0

Does this error occur in the most current version released (v0.5.1)?

[carpeVideo]

I installed GBPVR 1.08 and SearchWiz has disappeared. I reinstalled search wiz and its still gone from plugins... has anyone else had this happen. I'll go back to 99.12 since this is the best search tool out there but I'd rather stick with 1.08. (1.08 has also killed the "TV listings" plugin as well),

CV

[nightwalker]

I think i read somewhere on here that sub said that older plugins, pre-1.08,need to be in the

devnz\gbpvr\Plugins\legacy

directory in order to work.

[JavaWiz]

That's correct for version 1.0.8, all plugins must be in a sub-directory. Move all the old plugins to a sub-directory under gbpvr/plugins (can be any name, but legacy works fine). SearchWiz should then appear again.

If you are going to use the old UI (gbpvr.exe), you must have a 2nd copy in the plugins directory.

[jh61408]

Hi, I Installed the Search Wiz, But it seems not to find anything i try and search for.
I searched for South Park, Football, Home. All with no results only the Box that says Sorry, No listings found. Is their a trick to using this?.

I checked the tv Guide and founds listings and also used the Find all and many were listed.

Thanks

[JavaWiz]

Hi, I Installed the Search Wiz, But it seems not to find anything i try and search for.
I searched for South Park, Football, Home. All with no results only the Box that says Sorry, No listings found. Is their a trick to using this?.

I checked the tv Guide and founds listings and also used the Find all and many were listed.

Thanks

Zip up your logs and post them. I'll take a look.

[jh61408]

Logs included

[JavaWiz]

Hi, I Installed the Search Wiz, But it seems not to find anything i try and search for.
I searched for South Park, Football, Home. All with no results only the Box that says Sorry, No listings found. Is their a trick to using this?.

I checked the tv Guide and founds listings and also used the Find all and many were listed.

Thanks

SearchWiz only works with SQLite database. Looks like you are using an Access MDB.

2007-10-06 18:18:10.687 VERBOSE [1] databaseConnectionString is Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Program Files\devnz\gbpvr\gbpvr.mdb";User Id=admin;Password=

[jh61408]

SearchWiz only works with SQLite database. Looks like you are using an Access MDB.

I guess i am not sure where you would change that, In the Configuration or somewhere else?.

[JavaWiz]

I guess i am not sure where you would change that, In the Configuration or somewhere else?.

It cannot be changed thru the config.exe program. You'll need to edit the config.xml file directly (make sure you back it up prior to making any changes).

There is a section that should look something like this:

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>

In your config, the section that is active looks like this:

Code:

<DatabaseConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".\gbpvr.mdb";User Id=admin;Password=</DatabaseConnectionString>
  <DatabaseProviderFactory>System.Data.OleDb.OleDbFactory</DatabaseProviderFactory>
  <DatabaseIdentityQuery>select @@identity</DatabaseIdentityQuery>

Set the active section to SQLite (1st code snippet). You will have to reconfigure your card, reload epg, and channels.

There may be a cleaner way to do this. I have always used SQLite, so you may want to query other users to see if there is a better way to swtich between Access and SQLite.