Problems configuring v0.98.8b

[5%NationofCasiotone]

Zip and attach your config.xml and I'll take a look. It reads like something is wrong the database connection string.

Thanks.

[sub]

You've strangely managed to end up with it half configured for SQLite, half for Access. Make sure the following are set in your config.xml and it should correct the problem:

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

[5%NationofCasiotone]

You've strangely managed to end up with it half configured for SQLite, half for Access. Make sure the following are set in your config.xml and it should correct the problem:

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

Right now, I have this:

PHP Code:

Typical strings:

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

  Access
  <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> 


So your saying I should just get rid of that second Access part? Secondly - what program can I use to edit it (no luck in Firefox).

[sub]

right now you have:

Code:

<DatabaseConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".\gbpvr.mdb";User Id=admin;Password=</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.SQLite.SQLiteFactory</DatabaseProviderFactory>
<DatabaseIdentityQuery>select last_insert_rowid()</DatabaseIdentityQuery>

The bit you quoted above are just comments in the xml, not the actual settings. The settings were just before this in the config.xml file. Just use notepad to edit it to what I said in my previous post.

[5%NationofCasiotone]

The bit you quoted above are just comments in the xml, not the actual settings. The settings were just before this in the config.xml file. Just use notepad to edit it to what I said in my previous post.

Ok, I changed that in Notepad. While the original error message is gone, I now have a new one. Also, just wanted to take the chance to thank you for the help so far.

[sub]

Zip and attach your logs and I'll take a look. I cant tell from that error message.

[5%NationofCasiotone]

Zip and attach your logs and I'll take a look. I cant tell from that error message.

Well, all of my logs ended up being quite large - but here they are.

[sub]

It still looks like you havnt corrected those settings I pointed out above. Zip and attach your config.xml now that you've tried to make those changes.

[5%NationofCasiotone]

It still looks like you havnt corrected those settings I pointed out above. Zip and attach your config.xml now that you've tried to make those changes.

See Attached. Thanks.

[sub]

I dont really know. Its still complain about something related to the database connect.

At this point I'm going have to recommend going with a clean install (sorry): uninstall GB-PVR, delete the gbpvr directory, reinstall GB-PVR, and setup again from scratch.