Topic: phpdvdprofiler

[Jimmy]

Weird that you have trouble with Marie's collection and everything went fine with mine as I am hosted by you too

Did she does something different than me with he xml files? Maybe she have one file by profile and this is the problem

[Dragonfire]

I do have one file for each profile.  I started doing that when I was using a free host that limited the size of a file...one file was too big.  I never thought about changing that. 

For some of the ones that have multiple discs - like the Blu-rays that have DVD copies as well - like Sherlock Holmes -, I only upload the Blu-ray profile.  Do I need to add the DVD profiles for those titles too?

When I update stuff, it does say that a profile can't be empty..I can't remember the number now.  Could that be causing a problem?

[Jimmy]

I'm not the expert on this... But you don't have to worry about the size of the main file Marie. Everytime I upload mine it's just with the ones I have flagged and not my complete collection.

By exemple if I change a profile (watched or do an edit) I flag it, do a flag only export and upload the small xml file on the server. Same thing if I add a new dvd to my collection.

You just have to make sure to uncheck "Update database to remove profiles that are not in xml collection" when you update.

The only time I have to upload the complete xml is when I delete a DVD from my collection.

For some of the ones that have multiple discs - like the Blu-rays that have DVD copies as well - like Sherlock Holmes -, I only upload the Blu-ray profile.  Do I need to add the DVD profiles for those titles too?

Personally I add them, but I don't think it's the cause of the problem as they are child profile.

[DJ Doena]

But Jimmy just as a reminder: When you change cast names you should export all profiles with that cast or else you break your online database.

[Jimmy]

Never tought at that... but when I change a credited name this is to attach the name to the one use by my other movies (I never change the primary name when my choice is done).

[Dragonfire]

Hmmm....ok.
I guess I was thinking that I'd have to upload them all in the one giant file every time or I'd end up replacing everything with just the one profile or something.

I know when I first got it set up, that was one of the problems I had.  The host I was using at that time limited the max file size..probably because it was free.

[FredLooks]

You can, of course, upload one big XML file every time (I do that, but it is my server and on a local lan).

You can also upload the collection as a bunch of one-profile-per-xml-file files (then you only have to upload the changed files, and you have to manually delete any files corresponding to deleted profiles - or profiles whose UPC has been manually changed)

RossRoy is uploading a single XML file containing only the changed files, and telling the update not to delete. I am uncertain if this will always work with the re-starting changes I made in the last couple of releases. Now it recalls how far up the file it has gotten, and if the file changes out from under it there could be fireworks. You can alleviate that by issuing a http: //your.site/phpdvdprofiler/index.php?action=HealthCheck request from your browser - that resets things.

If you set $UpdateDebug = true; in your localsiteconfig.php, it will add an extra button to the update UI (named, appropriately, "Debug"). Pressing this button will open a window with much arcana about the current update session (it's basically a log of what's happened so far, specifically giving times and data of network requests to the server). The output is likely only interesting to me, but it will likely be quite interesting to me, so if you could enable that it would likely prepare for any debugging sessions ...

[Dragonfire]

I've always done one profile per xml file..then just updated the new movies or the ones I've watched.

I'll see if I can find that debug line in the file.  Or do I have to actually add it in there?

[Dragonfire]

I just looked through the file and don't see that line..though I could have missed it. 
I saw one line that had $debug = true and that was it.

I'll wait to change anything until I find out if the line is there somewhere or if I have to add it in somewhere.

[FredLooks]

No, it won't be there - go ahead and just add it...

[Jimmy]

I am uncertain if this will always work with the re-starting changes I made in the last couple of releases.

I use the partial xml file and it always work me without problems.

[FredLooks]

The recovery strategy will fail if an update times out, and you put in a new XML file before it can continue and complete ... I think I can code around that (admittedly rare) case...

[Dragonfire]

I tried adding that...as far as I can tell, there is no new button.

Maybe Sebestian has to do it since he's doing the hosting.

[Dragonfire]

Ok...when I looked closer, it looked like the update hadn't completely finished, so I did it again...and got this error message whatever the heck it means.

Fatal error: SQL ERROR [ mysql ]

MySQL server has gone away

CALLING PAGE

/phpdvdprofiler/index.php&

SQL

UPDATE DVDPROFILER_dvd SET collectiontype=realcollectiontype WHERE realcollectiontype!='Wish List' AND realcollectiontype!='ordered'
in /home/dvdalist/public_html/dragonfire.dvdalistic.com/phpdvdprofiler/mysql.php on line 455

[FredLooks]

That error would happen if there was a connectivity issue between your program and the SQL server.

there is definitely something odd going on ... Some queries (like the regular display-the-ui ones) work just fine. Some of the others (like the debug ones such as action=UpdateStatus) seem to time-out.

I'll try to look again in the (my) morning ... I'm finding debugging to be challenging on the iPad