Topic: phpdvdprofiler

[surfeur51]

Made your changes, but now I get
The connection to database phpdvdprofiler on ... failed  — Code 2005 —> Unknown MySQL server host '...' (-2)

[DJ Doena]

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.

[surfeur51]

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 ?

[DJ Doena]

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

[surfeur51]

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

Thank you very much Karsten for your help. 

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

[surfeur51]

Well, I removed the accents from supplier Magasin spécialisé> Magasin specialise, and it worked 

I have now all my titles , 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 

[FredLooks]

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

[Jimmy]

There is certainly a way to prevent this since the french accents show up perfectly fine in mine.

Profile exemple

[FredLooks]

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

[surfeur51]

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/