English > Development
PK's MovieDB dynamic website template
deazo:
Thanks for your answer.
I am using the script you included in your .zip package.
I am attaching it in this reply (!! I have changed the extension to txt so that I can attach it to this message, so you need to re-change it to .ptm !). I have put it in the "templates" section of my PVD folder.
Is it the wrong one?
[attachment deleted by admin]
blue334:
Hi,
sorry for the late reply, I forgot about the thread.
The template is the correct one, for ver 0.9.8.20 output. Regardless of version, I don't quite understand why the output is being truncated like that. Can you check if the [);] closing of each statement) is also missing in the sql script (the export output file), or just in the mysql error message?
deazo:
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');
deazo:
OK I have re-started everything from scratch.
I used the beta version of pvd this time and did not receive the "range check error" message, the generation of the sql file went all the way.
Now the problem I have, is that actors appear as director on my page...
I know the fix should be simple, but I really don't know what it is. Where should I make a change, directly in myphpadmin, or in the sql itself?
One day I'll succeed...
Thanks
blue334:
Hi,
you'll need an updated export template for the beta version, since there are many changes.
I have one working already for my own site, I'll try to tidy it up and upload it tomorrow.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version