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:
What is the best video database software?:

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


Topic Summary

Posted 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]
Posted 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
Posted by: nostra
« on: October 07, 2010, 02:21:18 am »

You just need to add "-debug" (without quotes) to the path you have there...
Posted 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.
Posted 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
Posted 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?????
Posted 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
Posted 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
Posted 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?
Posted 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
Posted 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
Posted by: rick.ca
« on: October 06, 2010, 11:30:08 pm »

Welcome, bamacole.

Does this 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. ;)
Posted 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