Topic: phpdvdprofiler

[FredLooks]

It's looking good, Marie.

I use the statistics page to help locate profiles with "problems". For example, I see that you have 1 title with an aspect ration of 2.4:1 and 72 with an aspect ratio of 2.40:1. My OCD would make me change that lone title

-fred

I do? 

I really don't know much about aspect ratios.  Are those legitimate ratios, or is something really messed up in some profiles?

Those are identical aspect ratios. They're just being written differently, which is what makes my OCD twitch

[Dragonfire]

Ahh. Ok.  I've learned something else.

I'll try to fix that...if I can find the one in question.

[Achim]

Honestly Kathy, if I could figure this out, you could too.  It did take me a little while, but I got it.  And I have no clue about coding or anything....as it probably very clear from all my posts trying to get it all working.   

I never would have guessed. I thought you handled it impressively well (unless there was communication going on beyond this thread).

Well, some people just have bad luck sometimes and then sometimes (like for you here) things just fall into place.

[Dragonfire]

Really?  I sort of thought I was looking like an idiot about some of that.

I do feel a bit more comfortable with it now.  But if I hadn't found step by step directions for setting stuff up to begin with, I would still be trying to get it to work..or I would have just given up in frustration.

It took me..hmm..well not sure how long now, but hours to get the page working..then I got all confused with the banner for a while....even before the font goof up.  

I'm glad I got it working though.  I like how the DVDs are listed there better..like the box set stuff shows like a box set.  And I like my banner...even if Jimmy doesn't like the purple.

[KinkyCyborg]

Ok so I decided to take the plunge and install the update as was suggested by just copying over the contents from the two install folders to my existing phpdvdprofiler folder on my host. After I was done and attempted to connect to my list I get this message...

The database schema is out-of-date and is incompatible with this code.
The database needs to be updated using the schema that came with this code.

The database schema will be automatically updated the next time an update is performed.

Database schema version = 2.4
Code schema version = 2.5


I expected something like that so I enter my login/password info and click the Complete Update will be performed box, click the Login button and... nothing. The screen goes blank white and firefox says the page is done... HELP!    My list is gone!

KC

[Dragonfire]

Oh no...

I got the message about the schemia being out of date...but it did the updating and list was back.  I had to run the update several times to get the whole list.

is your xml file still there?

[KinkyCyborg]

Yep, all files that were there in my original folder but not in the new install folders are still there like collection.xml, localsiteconfig.php, all my images. Panicking here! 

[Dragonfire]

Eek.  I would panic too. 

I'm sorry this happened...I don't know what else to suggest...  I wish I had another idea..
I clicked on your link and it loads up the page asking for you to log in.  Did you try doing that again?  Maybe see if the updating starts then?

[KinkyCyborg]

I've tried to login in repeatedly and I get nothing. If it told me my login info was incorrect or something I wouldn't be so concerned but just a plain white blank screen....  ?  gulp!

[Dragonfire]

Just had another thought.

Maybe upload another copy of your localconfig file...in case it got replaced when you uploaded the new version.

[RossRoy]

Since you mention that you localsiteconfig.php file is still intact, I'm guessing the username for the database doesn't have all the necessary access rights to drop the tables and load the new schema.

Looks like you might have to update the database schema manually...

Can't help you much there, maybe Fred will be around soon to give you better indications.

[KinkyCyborg]

Did that already. Downloaded the localsiteconfig.php file to my computer from my host, renamed it to siteconfig.php and re-upped it back to the site. So the siteconfig and localsiteconfig are both the same now with all the correct host/login info and still nothing... both before and after I tried that the result is the same... a blank screen.

[KinkyCyborg]

Since you mention that you localsiteconfig.php file is still intact, I'm guessing the username for the database doesn't have all the necessary access rights to drop the tables and load the new schema.

Looks like you might have to update the database schema manually...

Can't help you much there, maybe Fred will be around soon to give you better indications.

I've pretty much resigned myself to the fact that I will likely have to wait for Fred. No worries... I'm sure it will get straightened out. Thanks for the help guys!   

[Dragonfire]

I can't think of anything else to suggest either.  And after my own issues, I'm not the best person to try to help.

Maybe send Fred a PM here to let him know you need some help.  I get an email when I get a PM.

[RossRoy]

that's what I mean by the db user possibly not having the required access rights. That would be changed at the hosting account level - not in the phpdvdprofiler config files.

The fact it knows your schema is out of date means your site is configured correctly - it did access the database. It just can't update it.

I have no idea how it'd work for you - but on my end, I have access to something called "phpMyAdmin" which allows me to directly control the installed databases on my site.

If you read here: http://www.johnd.com.au/installingphpdvdprofilerV3/index.htm
Supposing that's the tutorial you followed to install phpdvdprofiler, when you look in the section "Creating the MySQL User" - it tells you to create the user with somewhat limited rights. Thing is, for the database schema update to work, you'd definitely need at least the CREATE and DROP rights as a minimum on top of those it already has.

You could set it to have all priviledges, run the update, then if successful restore the original rights as they were.

-------

Alternatively, you could manually update the database schema.

Theoretically, you could follow the steps "Creating the MySQL Database" and "Creating the MySQL User" as explained on this site: http://www.johnd.com.au/installingphpdvdprofilerV3/index.htm
Just make sure to use the same names as they are currently set in your localsiteconfig.php ($dbuser - $dbpasswd - $dbname - etc.)

But be careful - you might end up causing more damage than it is actually.. You might be better off waiting for Fred - hoping he's back soon..

Sorry about your troubles - that's the best advice i can give for now (and I have to go to bed)..

Hope you find a solution!