Author Topic: Need help QUICKLY PLEASE  (Read 13341 times)

0 Members and 1 Guest are viewing this topic.

Offline bamacole

  • Member
  • *
  • Posts: 6
    • View Profile
Need help QUICKLY PLEASE
« 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
« Last Edit: October 06, 2010, 11:25:55 pm by bamacole »

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #1 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. ;)

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Need help QUICKLY PLEASE
« Reply #2 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
Gentlemen, you can’t fight in here! This is the War Room!

Offline bamacole

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #3 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

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Need help QUICKLY PLEASE
« Reply #4 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?
Gentlemen, you can’t fight in here! This is the War Room!

Offline bamacole

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #5 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

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Need help QUICKLY PLEASE
« Reply #6 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
Gentlemen, you can’t fight in here! This is the War Room!

Offline bamacole

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #7 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?????

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Need help QUICKLY PLEASE
« Reply #8 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
Gentlemen, you can’t fight in here! This is the War Room!

Offline bamacole

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #9 on: October 07, 2010, 02:02:24 am »
yes, I copied and pasted the line in the "target" line and it said invalid name.

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Need help QUICKLY PLEASE
« Reply #10 on: October 07, 2010, 02:21:18 am »
You just need to add "-debug" (without quotes) to the path you have there...
Gentlemen, you can’t fight in here! This is the War Room!

Offline bamacole

  • Member
  • *
  • Posts: 6
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #11 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
« Last Edit: October 07, 2010, 02:48:06 am by bamacole »

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Need help QUICKLY PLEASE
« Reply #12 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]