Author Topic: phpdvdprofiler  (Read 70534 times)

Offline surfeur51

  • Intermediate Poster
  • ***
  • Posts: 119
  • Country: fr
    • View Profile
Re: phpdvdprofiler
« Reply #345 on: September 25, 2016, 08:02:11 AM »
Made your changes, but now I get
The connection to database phpdvdprofiler on ... failed  — Code 2005 —> Unknown MySQL server host '...' (-2)

Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6719
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: phpdvdprofiler
« Reply #346 on: September 25, 2016, 09:22:58 AM »
You weren't supposed to enter ... ;)

You're supposed to enter the host name of your database (your host provider has given you this information in one way or another) and the user name you need to access your own database.
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline surfeur51

  • Intermediate Poster
  • ***
  • Posts: 119
  • Country: fr
    • View Profile
Re: phpdvdprofiler
« Reply #347 on: September 25, 2016, 10:39:16 AM »
You weren't supposed to enter ... ;)
:-[ :-[ I knew I'm very limited on this...

Well, I can' find the host name of my database. I tried mysql.hostinger.fr , server35.hostinger.fr but it doesn't work. Has this information a specific form ?

Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6719
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: phpdvdprofiler
« Reply #348 on: September 25, 2016, 05:51:02 PM »
When you rent a websapce you usually get a configuration page (online) when you can look up this stuff.

Contact me at karsten [at] yajirobi.de and we'll look over it
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline surfeur51

  • Intermediate Poster
  • ***
  • Posts: 119
  • Country: fr
    • View Profile
Re: phpdvdprofiler
« Reply #349 on: September 25, 2016, 11:09:29 PM »
Contact me at karsten [at] yajirobi.de and we'll look over it
Thank you very much Karsten for your help.  :thanks:

Now my site is online, http://surfeur51.esy.es/phpdvdprofiler/

But I still have problems. I sent a new collection.xml file, and made an update, but this didn't work well. I got only 35 profiles (should be 2130), with this message:

/phpdvdprofiler/index.php&

SQL

SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='Magasin spécialisé'
in /home/u407805850/public_html/phpdvdprofiler/mysql.php on line 455
Turning Faster, more memory-intensive updates: off
Posting an update request
Response received for update request ... Handled by Connection Id 85768975
XML file specified is 'collection.xml'
'collection.xml' appears to be a file of type 'DVD Profiler XML'
Faster, more memory-intensive updates: Off
A previous update failed to complete. Missing profile removal turned off.
To remove profiles from the database which are not in the XML file(s),
run a normal (not Complete) update once any update has completed successfully.
Contents of xml collection will be added to database; profiles will be updated but NOT removed.
Importing into database u407805850_dvdp
Resuming an incomplete update — starting 36 profiles (548,200 bytes) into file collection.xml
Current file being processed: collection.xml

Warning: set_time_limit() has been disabled for security reasons in /home/u407805850/public_html/phpdvdprofiler/incupdate.php on line 1019

Fatal error: SQL ERROR [ mysql ]

CALLING PAGE

/phpdvdprofiler/index.php&

SQL

SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='Magasin spécialisé'
in /home/u407805850/public_html/phpdvdprofiler/mysql.php on line 455


I do not understand why there is a selection about suppliername='Magasin spécialisé'. And I also noticed that accented characters as é or ç are replaced by ? (that is not really a problem for my purpose.

Perhaps FredLooks can help me on this ??

Yves

Offline surfeur51

  • Intermediate Poster
  • ***
  • Posts: 119
  • Country: fr
    • View Profile
Re: phpdvdprofiler
« Reply #350 on: September 26, 2016, 09:22:54 AM »
Well, I removed the accents from supplier Magasin spécialisé> Magasin specialise, and it worked  :clap:

I have now all my titles ;D, but with an incredible number of "?" instead of accented characters everywhere in the profiles. But it's ok from my purpose (consulting my collection on my phone in stores or flea markets)

Thank you for developers and helpers  ;D

Offline FredLooks

  • phpDVDProfiler Moderator
  • Intermediate Poster
  • *
  • Posts: 107
  • Country: ca
    • View Profile
    • Fred's Home Site
Re: phpdvdprofiler
« Reply #351 on: September 26, 2016, 04:53:03 PM »
Hi Yves, welcome to the party  :)

That ls a little ... discomfiting. I'll have to review how the program stores data; for at least some fields it automatically translates "special" characters into their equivalent HTML characters to try to prevent this sort of thing.

Would it be possible for you to make your XML file available to me for testing (un-edited, please) to see if I can reproduce the problem?

Cheers!

-fred

Offline Jimmy

  • Mega Heavy Poster
  • *******
  • Posts: 6756
  • Country: ca
  • Yes this is me...
    • View Profile
Re: phpdvdprofiler
« Reply #352 on: September 26, 2016, 05:25:29 PM »
There is certainly a way to prevent this since the french accents show up perfectly fine in mine.

Profile exemple

Offline FredLooks

  • phpDVDProfiler Moderator
  • Intermediate Poster
  • *
  • Posts: 107
  • Country: ca
    • View Profile
    • Fred's Home Site
Re: phpdvdprofiler
« Reply #353 on: September 26, 2016, 09:24:10 PM »
Hmmm ... The only thing that stands out is that they are running MariaDB rather than MySQL ...  http://surfeur51.esy.es/phpdvdprofiler/index.php?action=info

I haven't any experience with that ... the webpages seem to indicate that it is drop-in compatible ...

I'll explore some more ...

-fred

Offline surfeur51

  • Intermediate Poster
  • ***
  • Posts: 119
  • Country: fr
    • View Profile
Re: phpdvdprofiler
« Reply #354 on: September 29, 2016, 05:22:31 PM »
Clearly the problems came from an inadequacy between phprofiler and the host server. I changed from hostinger to 000webhost, and now everything seems to work without problem.

http://surfeur51.comxa.com/phpdvdprofiler/