Personal Video Database

English => Support => Topic started by: bamacole on October 06, 2010, 11:09:38 pm

Title: Need help QUICKLY PLEASE
Post by: bamacole on October 06, 2010, 11:09:38 pm
I have over 2000 movies in my database.  When I open my file and click on any movie there is no info!  No photo, actors or anything.  Not even the places to put info.  In other words the right side of the screen is a total blank.  Any help please?
Regards

Also, to add a note to this.  When I try to add a new movie to my database I get the following error message.

validation error column let, "***null***"
The insert failed because a column definition includes validation constraints.
Error Code: 27


Any help???

Thanks
Title: Re: Need help QUICKLY PLEASE
Post by: rick.ca on October 06, 2010, 11:30:08 pm
Welcome, bamacole.

Does this (http://www.videodb.info/forum_en/index.php?topic=2108.msg10902#post_s3) help? That is, does resetting Filters and clearing Search resolve the problem?

Quote
Need help QUICKLY PLEASE

Note our fees for expedited service are double the normal rates. ;)
Title: Re: Need help QUICKLY PLEASE
Post by: nostra on October 06, 2010, 11:32:05 pm
Try the following:
1. Create a backup copy of the database
2. Start PVd in debug mode using -debug command line parameter
3. Go to Help -> SQL
4. Enter the following SQL:
Code: [Select]
UPDATE movies SET "let" = ''4. Press "Execute" and wait until a Messagebox pops up let you know if the execution was successful
Title: Re: Need help QUICKLY PLEASE
Post by: bamacole on October 06, 2010, 11:47:17 pm
hey guys, thanks so much for your quick replies.  Your support is really appreciated. 

I'm getting all kinds of pluin errors messages as well, lol sounds diasatorous!

You guys are light years ahead of me on computer issues so you may need to explain more in detail on some things...sorry.  I tried resetting my filters and that did not correct the problem.  I am not sure how to start PVD in the mode that was also suggested.  duh, I'm an idiot. lol
Title: Re: Need help QUICKLY PLEASE
Post by: nostra on October 06, 2010, 11:51:10 pm
Right click the shortcut to PVD and select "Properties". In target add -debug, so the whole string looks like this: "C:\Program Files (x86)\Personal Video Database\viddb.exe" -debug

Quote
I'm getting all kinds of pluin errors messages as well, lol sounds diasatorous!

Could you be more specific?
Title: Re: Need help QUICKLY PLEASE
Post by: bamacole on October 07, 2010, 12:22:10 am
nostra,

when starting pvd I get these;

Plugin amm_sht.dll could not be loaded.
This plugin is not compatible with this version of PVD.

Plugin pvdtotray.dll could not be loaded.
This plugin is not compatible with this version of PVD.

Plugin tvdb.dll could not be loaded.
This plugin is cot compatible with this versin of PVD.

Plugin twittpvd.dll could not be loaded
This plugin is cot compatible with this versin of PVD.

Plugin valueconvert.dll could not be loaded.
This plugin is cot compatible with this versin of PVD.

Thanks
Title: Re: Need help QUICKLY PLEASE
Post by: nostra on October 07, 2010, 12:27:59 am
Which PVD version are you using??? Please get the newest version of the application and the plugins and remove amm_sht.dll from the PVD_Install_Dir\Plugins directory
Title: Re: Need help QUICKLY PLEASE
Post by: bamacole on October 07, 2010, 12:44:20 am
I have deleted the file amm_sht.dll and have the latest version of PVD.  Same results.
Any more ideas?????
Title: Re: Need help QUICKLY PLEASE
Post by: nostra on October 07, 2010, 01:36:52 am
Have you done this:
Quote
1. Create a backup copy of the database
2. Start PVd in debug mode using -debug command line parameter
3. Go to Help -> SQL
4. Enter the following SQL:
Code:

UPDATE movies SET "let" = ''

4. Press "Execute" and wait until a Messagebox pops up let you know if the execution was successful
Title: Re: Need help QUICKLY PLEASE
Post by: bamacole on October 07, 2010, 02:02:24 am
yes, I copied and pasted the line in the "target" line and it said invalid name.
Title: Re: Need help QUICKLY PLEASE
Post by: nostra on October 07, 2010, 02:21:18 am
You just need to add "-debug" (without quotes) to the path you have there...
Title: Re: Need help QUICKLY PLEASE
Post by: bamacole on October 07, 2010, 02:44:17 am
Ok, first off, I say thanks for being so helpful and patient with me on this.  As you can tell, I don't know much about this kind of stuff...so thanks a bunch.

Now, when I go to "help", "SQL" a box pops up with a #1 showing.  Do I type "CODE" and the go to line # 2 or just type in UPDATE movies SET "let" = "

thanks
Title: Re: Need help QUICKLY PLEASE
Post by: rick.ca on October 07, 2010, 06:00:19 am
Enter only this:

Code: [Select]
UPDATE movies SET "let" = ''
Note "let" is enclosed by double quotes and on the RHS of the "=" are two single quotes.

See attached.

I have no idea whether this is supposed to fix something, or just provide information nostra needs. Please report back exactly what happens.

[attachment deleted by admin]