Personal Video Database

English => Support => Topic started by: jvic on August 18, 2009, 10:24:01 pm

Title: Optimize Problem
Post by: jvic on August 18, 2009, 10:24:01 pm

I'm using 0.9.9.11 and when I try to Optimize the DB, I get the error 'Failed' by Create Backup and Garbage Collection. It then says 'Movies Deleted:0' and 'People Deleted:0'. It used to work. The DB doesn't appear to have any problems. Does anybody know what's wrong?

Title: Re: Optimize Problem
Post by: rick.ca on August 18, 2009, 11:38:13 pm

That's the behaviour I observe if I attempt to optimize when connect via server.

Title: Re: Optimize Problem
Post by: jvic on August 18, 2009, 11:58:05 pm

How do I change it to connect differently. I don't see a Preference setting. Thanks.

Title: Re: Optimize Problem
Post by: nostra on August 19, 2009, 12:05:34 am

Database -> Open

Title: Re: Optimize Problem
Post by: jvic on August 19, 2009, 12:45:24 am

Do you mean File -> Open? I don't see a Database menu. File -> Open doesn't have any options. Thanks.

Title: Re: Optimize Problem
Post by: rick.ca on August 19, 2009, 01:03:40 am

Use Open instead of Connect to server.

Title: Re: Optimize Problem
Post by: nostra on August 19, 2009, 01:07:43 am

Yes, I meant File -> Open

Title: Re: Optimize Problem
Post by: jvic on August 19, 2009, 01:17:25 am

I wasn't using Connect to Server. I use File -> Open. Is there something else? Thanks.

Title: Re: Optimize Problem
Post by: nostra on August 19, 2009, 01:38:33 am

What is the path for the backups and does pvd have access to this folder?

Title: Re: Optimize Problem
Post by: jvic on August 19, 2009, 10:51:50 pm

I'm using My Documents\Personal Video Database as the folder for the main DB file and the backup.

I installed Firebird Maestro. Could that be messing it up? Thanks.

Title: Re: Optimize Problem
Post by: nostra on August 19, 2009, 11:53:48 pm

Quote

I installed Firebird Maestro. Could that be messing it up? Thanks.

It could, theoretically, but should not...

What is the exact path (with filename) for the backup in "Optimize database" dialog?
Could you post your pvdconf.ini from "C:\Documents and Settings\%USERNAME%\Application Data\Personal Video Database\"

Title: Re: Optimize Problem
Post by: jvic on August 20, 2009, 12:40:09 am

Here is the path:
C:\Users\James\Documents\MOVIES.pvd.bak



[attachment deleted by admin]

Title: Re: Optimize Problem
Post by: nostra on August 20, 2009, 01:27:40 am

Strange, everything seems to be OK. I have only one explanation left: your database is corrupt :(
Is it possible for you to upload it to my FTP?

Title: Re: Optimize Problem
Post by: jvic on August 20, 2009, 01:34:30 am

It's 170 MB. Is there a way to repair it? Thanks.

Title: Re: Optimize Problem
Post by: nostra on August 20, 2009, 02:05:55 am

I can handle 170 MB.

Quote

Is there a way to repair it?

1. Download http://www.videodb.info/bin/fbtools.rar
2. Extract the package to the PVD directory
3. Create a backup copy of your database file
4. Execute in command line: gfix -v -f [database copy].pvd
5. If gfix reports that the file is corrupt, then execute: gfix -m -i [database copy].pvd
6. Do the 4. one more time to check if the database is fixed

Title: Re: Optimize Problem
Post by: rick.ca on August 20, 2009, 02:53:43 am

For us hopeless unilingual folk, I assume "[копия базы]" means "[copy of database]"? ;D

Title: Re: Optimize Problem
Post by: jvic on August 20, 2009, 02:54:44 am

I'll give it a go. Thanks for the help.

Title: Re: Optimize Problem
Post by: nostra on August 20, 2009, 03:43:34 pm

Quote from: rick.ca on August 20, 2009, 02:53:43 am

For us hopeless unilingual folk, I assume "[копия базы]" means "[copy of database]"? ;D

Ups, I have copied my answer from the Russian forum translating it in English, but forgot these two words ::)

Title: Re: Optimize Problem
Post by: jvic on August 20, 2009, 11:03:16 pm

When I try 'gfix -v -f movies.pvd' at the command prompt nothing seems to happen. Just a new line appears

c:\Users\James\Documents\Personal Video Database\fbtools>gfix -v -f movies.pvd (I hit Enter here)

c:\Users\James\Documents\Personal Video Database\fbtools>

Any ideas? Thanks.

Title: Re: Optimize Problem
Post by: nostra on September 02, 2009, 11:33:32 pm

It should mean that everything is ok with the low level db structure...

Title: Re: Optimize Problem
Post by: jvic1 on September 07, 2009, 01:38:33 pm

FYI I never could get it repaired enough to optimize. I exported all the records and imported them into a new DB. It went well except for the TV episodes :(

Everything is working great now.