Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted 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.
Posted by: nostra
« on: September 02, 2009, 11:33:32 pm »

It should mean that everything is ok with the low level db structure...
Posted 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.
Posted 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 ::)
Posted by: jvic
« on: August 20, 2009, 02:54:44 am »

I'll give it a go. Thanks for the help.
Posted by: rick.ca
« on: August 20, 2009, 02:53:43 am »

For us hopeless unilingual folk, I assume "[копия базы]" means "[copy of database]"? ;D
Posted 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
Posted by: jvic
« on: August 20, 2009, 01:34:30 am »

It's 170 MB. Is there a way to repair it? Thanks.
Posted 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?
Posted 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]
Posted 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\"
Posted 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.
Posted 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?
Posted 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.
Posted by: nostra
« on: August 19, 2009, 01:07:43 am »

Yes, I meant File -> Open
Posted by: rick.ca
« on: August 19, 2009, 01:03:40 am »

Use Open instead of Connect to server.
Posted 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.
Posted by: nostra
« on: August 19, 2009, 12:05:34 am »

Database -> Open
Posted 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.
Posted 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.
anything