Need help QUICKLY PLEASE

[bamacole]

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

[rick.ca]

Welcome, bamacole.

Does this help? That is, does resetting Filters and clearing Search resolve the problem?

Need help QUICKLY PLEASE

Note our fees for expedited service are double the normal rates.

[nostra]

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

[bamacole]

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

[nostra]

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

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

Could you be more specific?

[bamacole]

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

[nostra]

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

[bamacole]

I have deleted the file amm_sht.dll and have the latest version of PVD.  Same results.
Any more ideas??

[nostra]

Have you done this:

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

[bamacole]

yes, I copied and pasted the line in the "target" line and it said invalid name.

[nostra]

You just need to add "-debug" (without quotes) to the path you have there...

[bamacole]

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

[rick.ca]

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]