I happened to look at a credits list this morning and found that the list included many actors with (uncredited) after their name and the order seemed to be random. I deleted all the credits and downloaded them again from ImdB. This time, they are correct. I have many DVDs and do not wish to have to do this on each film separately. Is there a way to fix this all at once?
Here is a sample. This is the list from "Usual Suspects" as it is now:
Christine Estabrook : Dr. Plummer
Peter Rocca : Jaime, Arturro's Bodyguard
Billy Bates : Bodyguard #4 (as Bill Bates)
Smadar Hanson : Keyser's Wife
Bert Williams : Old Cop in Property
Gene Lythgow : Cop on Pier
Stephen Baldwin : Michael McManus
John Gillespie : (uncredited)
Castulo Guerra : Arturro Marquez
Giancarlo Esposito : Jack Baer, FBI
Scott B. Morgan : Keyser Söze (in flashback) (uncredited)
Michael Robert Nyman : N.Y. Uniform Cop (uncredited)
Morgan Hunter : Arkosh Kovash
David Powledge : Bodyguard #2
Kevin Pollak : Todd Hockney
Peter Greene : Redfoot the Fence (uncredited)
Bob Pennetta : Bodyguard #3
Louis Lombardi : Strausz
Ron Gilbert : Daniel Metzheiser, Dept. of Justice
Christopher McQuarrie : Interrogation Cop (uncredited)
Ken Daly : Translator
Carl Bressler : Saul Berg
Frank Medrano : Rizzi
Benicio Del Toro : Fred Fenster
Vito D'Ambrosio : Arresting Officer
Clark Gregg : Dr. Walters
Robert Elmore : Bodyguard #1 (as Bob Elmore)
Gabriel Byrne : Dean Keaton
Suzy Amis : Edie Finneran
Pete Postlethwaite : Kobayashi
Dan Hedaya : Sgt. Jeffrey 'Jeff' Rabin
Jack Shearer : Renault
Michelle Clunie : Sketch Artist
Chazz Palminteri : Dave Kujan, US Customs
Paul Bartel : Smuggler
Kevin Spacey : Roger 'Verbal' Kint
Phillip Simon : Fortier
And here is the list after I delete and re-download:
Stephen Baldwin Michael McManus
Gabriel Byrne Dean Keaton
Benicio Del Toro Fred Fenster
Kevin Pollak Todd Hockney
Kevin Spacey Roger 'Verbal' Kint
Chazz Palminteri Dave Kujan, US Customs
Pete Postlethwaite Kobayashi
Giancarlo Esposito Jack Baer, FBI
Suzy Amis Edie Finneran
Dan Hedaya Sgt. Jeffrey 'Jeff' Rabin
Paul Bartel Smuggler
Carl Bressler Saul Berg
Phillip Simon Fortier
Jack Shearer Renault
Christine Estabrook Dr. Plummer
Credits list too long and unsorted
Re: Credits list too long and unsorted
This was an old bug with importing .dvdpedia files where credits would not keep their order. You cannot delete all the credits directly from the program, but you can use the Terminal program to do so.
1. Quit DVDpedia
2. Go to your home folder ~/Library/Application Support/DVDpedia/Database.dvdpd and create a duplicate of that file as backup.
3. Open Terminal program and type "sqlite3 "
4. Drag Database.dvdpd from step one from the Finder into the Terminal. After that you should see:
5. Hit enter and you will get an sqlite prompt
6. Type "DELETE FROM zcredit;" and press enter
7. Type ".exit" and press enter.
8. Launch DVDpedia and you will no longer have credits for any movie, you can now select them all and choose get more info from under the advance menu to do a clean download.
If the above sounds too complicated, do feel free to send us your Database.dvdpd file and and we can do it for you.
1. Quit DVDpedia
2. Go to your home folder ~/Library/Application Support/DVDpedia/Database.dvdpd and create a duplicate of that file as backup.
3. Open Terminal program and type "sqlite3 "
4. Drag Database.dvdpd from step one from the Finder into the Terminal. After that you should see:
Code: Select all
sqlite3 /Users/username/Library/Application\ Support/DVDpedia/Database.dvdpd6. Type "DELETE FROM zcredit;" and press enter
7. Type ".exit" and press enter.
8. Launch DVDpedia and you will no longer have credits for any movie, you can now select them all and choose get more info from under the advance menu to do a clean download.
If the above sounds too complicated, do feel free to send us your Database.dvdpd file and and we can do it for you.
Re: Credits list too long and unsorted
Thanks for your helpful reply. Unfortunately, everything works until step 7 (type ".exit" and press enter). When I do this, the program does not exit. I have also tried ".quit" and that does not work either. It is sqlite version 3.1.3.
Re: Credits list too long and unsorted - update
I have tried this on my Leopard machine (sqlite version 3.4.0) with the same results (.exit does not work). I have also changed the permissions on the file so that it is universally writeable. The exit command still does not work.
Re: Credits list too long and unsorted
Please email me the file and I will send you back the new version (send a copy of the backup you created). I don't seem to have a problem with sqlite 3.4.0 on Leopard. Strange that the credits still exist after running the DELETE command, even if sqlite won't exit.
Re: Credits list too long and unsorted
Thanks. Where do I find your email address? I think the problem is that since sqlite does not quit, it does not save the changes it made to the file. At least that is what the file shows (not saved).