Personal Video Database

 OK Nosidor give me some time, I should be able to have a look and test my version this week.
 I'll also try to have a look at yours and see which one I think is best. Are u French?
 I am by the way.
 
 I'll get back to u soon.

D.

 OMFG I didn't know that!!!!!!
I could have been using it for ages, now I need to go back in time...
Thanks anyway that's great news.

 Hi all, I have many Shorts in my collection and sometimes I want to filter out the shorts of the view, so I use Advanced search for this.
I create a condition like Genre Not Containing Short
And I still see tons of shorts in the list... Am I doing anything wrong?
By the way, I am not using the beta version, but the 9.8.20 one.

Also, a small thing but still a pain, I find names of actors in the "Genre" section. I have cleared and corrected the movies that displayed actors in the Genre field, but I can still see these names in the list of genres available... Is there a trick that can make them disappear?

Another thing while I am at it, when I view a movie that I have searched using keywords, let's say "eyes wide shut", then I click on Kubrick, navigate to People section, see another film like "Full metal jacket" in his list of movies, click on it and instead of giving me the Full Metal Jacket page, it goes back to the Eyes wide shut one because I was on it with my keyword search... was that clear enough? I guess this behaviour can't be corrected?

Thanks for your help, and again, that great software.

D.

  Forgive my ignorance, I'm not sure exactly what a statement is, but here is an example, it looks like [);] is here (see text pasted right at the end of this message).
 
  Remember, PVD gave me an error message after a while, when exporting the database in sql.
  Well it must have cut off the export right after this "trois couleurs" movie, because it is the very bottom of the sql file.
  The error message was something about some range ("range check error"), and I could not find anything in this forum/site about it.
 
   Would you know why the export was cut off? too many movies?

   Also, why would so much info be missing on the actual site (missing imdb ratings, missing directors, etc...)?

   Thanks.
   
   INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('1785', '', 'DVD514', '', '', '07/11/2008', '', '6.8', 'Itinéraire d''''un enfant gâté', 'Itineraire d''''un enfant gate', '', 'Claude Lelouch', 'Jean-Paul Belmondo, Claude Lelouch, Gerhard Schmidt', 'France, West Germany', 'Adventure, Comedy, Drama', '1988', '120', 'Jean-Paul Belmondo, Richard Anconina, Lio, Béatrice Agenin, Marie-Sophie L., Jean-Philippe Chatrier, Gila Von Weitershausen, Michel Beaune, Pierre Vernier, Philippe Lorin, Annie Philippe, Céline Caussimon, Daniel Gélin, Alexis Gruss, Nicolas Mallet, Firmin Gruss, Stephan Gruss, Paul Belmondo, Jacques Bonnot, Max Fournel, Patricia Grillo, Elie Lauer, Jeanne Marine, Pierre Meunier, Joëlle Miquel, Charles-Henry Tissot, Wookie Mayer, Arthur Brauss, Sabi Dorr, Udo Wachtveitl, Gilles Dimicelli, Marcel Guéguan, Nicole Croisille, Eva-Maria Hagen, Salomé Lelouch', 'http://www.imdb.com/title/tt0095386/ http://www.allmovie.com/cg/avg.dll?p=avg&sql=1:119647', 'French director Claude Lelouch, of Man and a Woman fame, called the shots on Itineraire D''''un Enfant Gate. Jean-Paul Belmondo (who co-produced the film) stars as a powerful international businessman who, in his youth, had been a carnival performer. Once more bitten by wanderlust, Sam Lion (Belmondo) tries to escape his responsibilities by staging his own death. Hiding out in Tanzania, Lion meets Abert Duvivier (Richard Anconina), one of his own employees. Duvivier, informing Lion that the business has gone to hell in a handbasket thanks to the mismanagement of Lion''''s daughter Victoria (Marie-Sophie Lelouch), begs the executive to return. The literal translation of the film''''s title is Itinerary of a Spoiled Child.', '', '', '', '', '', '', '', '', '', '0', '0', '', 'images/image144.jpg');

 First of all, thanks to Blue334 for your efforts on this, it's a dream come true for me really I love to see my database online.
I am a complete noob at this stuff so I followed your instructions completely blind and it worked!
I had an error message from PVD when exporting to Sql, (range excess error) but it did not seem to cause a problem...
For info, I am using the http://www.000webhost.com/ web free hosting service which has 1Gb size, and a 20Mb limit on Sql file import.

Funny: The IMDB ratings do not appear on my site...?
I am capturing it on all my movies though.

Also, only 5 directors appear on the side panel. I don't remember changing anything in the way I capture directors for my movies.
Actually (I keep on editing this post!), countries also are wrong, only 1% of them seem to have been properly captured on my page.

Of course I ran into other problems, solved a few, but here is one that I have no clue about, can you help?
I receive this error message after inporting the Sql file into my Database, and I don't know what it means:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 3251
STR: '
SQL:
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('1052', '', 'DVD322', '', '', '18/09/2008', '', '7.8', 'Trois couleurs: Bleu', 'Trois couleurs: Bleu', '', 'Krzysztof Kieslowski', 'Marin Karmitz', 'France', 'Drama', '1993', '100', 'Juliette Binoche, Benoît Régent, Florence Pernel, Charlotte Véry, Hélène Vincent, Philippe Volter, Claude Duneton, Hugues Quester, Emmanuelle Riva, Florence Vignon, Daniel Martin, Jacek Ostaszewski, Catherine Therouenne, Yann Trégouët, Alain Ollivier, Isabelle Sadoyan, Pierre Forget, Philippe Manesse, Arno Chevrier, Idit Cebula, Stanislas Nordey, Jacques Disses, Michel Lisowski, Yves Penay, Philippe Morier-Genoud, Julie Delpy, Zbigniew Zamachowski, Alain Decaux, Julie Gayet, Piotr Jaxa', 'http://akas.imdb.com/title/tt0108394 http://www.allmovie.com/cg/avg.dll?p=avg&sql=1:131104', 'Three Colors: Blue is the first part of Kieslowski''s trilogy on France''s national motto: Liberty, Equality, and Fraternity. Blue is the story of Julie who loses her husband, an acclaimed European composer and her young daughter in a car accident. The film''s theme of liberty is manifested in Julie''s attempt to start life anew free of personal commitments, belongings grief and love. She intends to spiritually commit suicide by withdrawing from the world and live completely independently, anonymously and in solitude in the Parisian metropolis. Despite her intentions, people from her former and present life intrude with their own needs. However, the reality created by the people who need and care about her, a surprising discovery and the music around which the film revolves heals Julie and irresistably draws her back to the land of the living.    ', '   The first of legendary Polish director Krzysztof Kielslowski''s Three Colors trilogy (representing the three colors of the French national flag) is a hypnotic and intriguing journey which follows Juliette Binoche after she tries to gain total liberty (the representation of blue in the flag) after the deaths of her husband (a famous European composer) and young daughter in an automobile accident. Of course isolating oneself from all others is not easy to do as the past keeps on popping up and the future holds many uncertainties. The fact that Binoche''s husband had an affair and the woman is now carrying his child is both ironic and tragic for all involved. In the end will Binoche be able to stop being blue? Blue, like all of Kielslowski''s works, thrives on symbolism (the color popping up all throughout the film) and an unmistakable tone (much the way that Roman Polanski uses that feature in his better productions). The film is not for all tastes because of strong adult content and a distinct female flair (due to the almost total focus on Binoche), but Blue is still a movie which is a testament to its excellent film-maker and its unique theatrical aspects. 4 stars out of 5. ', '', '', '', '', '', '', '', '', '0', '0', '', '


SQL query:

INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('1052', '', 'DVD322', '', '', '18/09/2008', '', '7.8', 'Trois couleurs: Bleu', 'Trois couleurs: Bleu', '', 'Krzysztof Kieslowski', 'Marin Karmitz', 'France', 'Drama', '1993', '100', 'Juliette Binoche, Benoît Régent, Florence Pernel, Charlotte Véry, Hélène Vincent, Philippe Volter, Claude Duneton, Hugues Quester, Emmanuelle Riva, Florence Vignon, Daniel Martin, Jacek Ostaszewski, Catherine Therouenne, Yann Trégouët, Alain Ollivier, Isabelle Sadoyan, Pierre Forget, Philippe Manesse, Arno Chevrier, Idit Cebula, Stanislas Nordey, Jacques Disses, Michel Lisowski, Yves Penay, Philippe Morier-Genoud, Julie Delpy, Zbigniew Zamachowski, Alain Decaux, Julie Gayet, Piotr Jaxa', 'http://akas.imdb.com/title/tt0108394 http://www.allmovie.com/cg/avg.dll?p=avg&sql=1:131104', 'Three Colors: Blue is the first part of Kieslowski''s trilogy on France''s national motto: Liberty, Equality, and Fraternity. Blue is the story of Julie who loses her husband, an acclaimed European composer and her young daughter in a car accident. The film''s theme of liberty is manifested in Julie''s attempt to start life anew free of personal commitments, belongings grief and love. She intends to spiritually commit suicide by withdrawing from the world and live completely independently, anonymously and in solitude in the Parisian metropolis. Despite her intentions, people from her former and present life intrude with their own needs. However, the reality created by the people who need and care about her, a surprising discovery and the music around which the film revolves heals Julie and irresistably draws her back to the land of the living. ', ' The first of legendary Polish director Krzysztof Kielslowski''s Three Colors trilogy (representing the three colors of the French national flag) is a hypnotic and intriguing journey which follows Juliette Binoche after she tries to gain total liberty (the representation of blue in the flag) after the deaths of her husband (a famous European composer) and young daughter in an automobile accident. Of course isolating oneself from all others is not easy to do as the past keeps on popping up and the future holds many uncertainties. The fact that Binoche''s husband had an affair and the woman is now carrying his child is both ironic and tragic for all involved. In the end will Binoche be able to stop being blue? Blue, like all of Kielslowski''s works, thrives on symbolism (the color popping up all throughout the film) and an unmistakable tone (much the way that Roman Polanski uses that feature in his better productions). The film is not for all tastes because of strong adult content and a distinct female flair (due to the almost total focus on Binoche), but Blue is still a movie which is a testament to its excellent film-maker and its unique theatrical aspects. 4 stars out of 5. ', '', '', '', '', '', '', '', '', '0', '0', '', '

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1

Thank you again for this!

D.

 Hi, first of all, I'd like to thank u for this software, it is very powerful. I am using it as well as EMM and can't decide which I prefer.
 The fact that PVD can captures tags/keywords from imdb is fantastic. Also I like the hyperlinkings, this helps me a lot when searching interesting movies in my collection.

 One feature I'd like to see is a cloud of tags, showing (in big letters) the ones that I have the most (recurring theme in my collection). I guess this will be in the stats tool. Of course we could have clouds of actors, directors, years, etc... It's just another way of displaying the results, rather than using columns or bars.
 
Thanks for listening!

D.