Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: DVD Profiler Online Page: 1 2  Previous   Next
phpDVDProfiler problem.
Author Message
DVD Profiler Unlimited RegistrantZipcom
Registered: March 23, 2007
Germany Posts: 72
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I've installed phpDVDProfiler and have noticed some (German) issues.

The phpDVDProfiler seem to have some problems with German "Umlaute" (Ä, Ö, Ü, ä, ö, ü, ß).

1. The Database update process fails if an Umlaut occurs within the "purchased from" section (as in: Müller-Markt).

2. All Umlauts are replaced by ? on the SQL Database.

Within the "Collection.xml" file the Umlauts are still present as they should be. But after the update process the SQL Database contains always a "?" for each Umlaut character (independent from the type of Umlaut character). This let me guess that this isn't a Codepage problem.
It seem the updater drops these characters.

Does anyone have similar problems (usually German users)? And a solution.
Or is there an option to get the Umlauts through the updater?
And is there a newer version available then the one i use (v3.8.2.1)?

I ask on this board because i don't get access to the phpDVDProfiler board.
DVD Profiler Unlimited RegistrantStar Contributoremmeli
www.myprofiler.de
Registered: June 26, 2013
Reputation: High Rating
Germany Posts: 694
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
then use phpMyProfiler

it´s the better script (for german profiles). if you have an questions feel free to ask.

cheers emmeli


the real BirthYear OverView
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,216
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Zipcom:
Quote:
1. The Database update process fails if an Umlaut occurs within the "purchased from" section (as in: Müller-Markt).

Works for me, see http://dvdliste.dvd-welt.de/ ... Place of purchase is "Täst"

Quote:
2. All Umlauts are replaced by ? on the SQL Database.

ALL? Or just place of purchase? I usually don't have POP visible, but such a grave error in titles and cast wouldn't have gone unnoticed.

What does index.php?action=info gives you on your system?
Mine: phpDVDProfiler:Version=3.8.2.0|XML:Version=2014-04-01-18:58:15|MySQL:Version=4.1.22-log|PHP:Version=5.2.17

At the moment I suspect your MySQL, although I have no idea how that could not be able to handle simple umlauts. Can you change the copepage for your mysql-db?

Quote:
And is there a newer version available then the one i use (v3.8.2.1)?

Funny I have installed v3.8.2.1, yet "info" gives me v3.8.2.0

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
 Last edited: by Mithi
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,737
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
The new home for phpDVDProfiler is here:

http://www.dvdcollectorsonline.com/index.php?action=forum#14


3.8.2.1 fixed some problems with german Umlauts in relation to a PHP version newer than 5.4.0, maybe something was overlooked for the retailer field
Karsten
DVD Collectors Online

 Last edited: by DJ Doena
DVD Profiler Unlimited RegistrantZipcom
Registered: March 23, 2007
Germany Posts: 72
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Thanks for the replies!

Quoting Mithi:
Quote:
Quoting Zipcom:
Quote:
2. All Umlauts are replaced by ? on the SQL Database.

ALL? Or just place of purchase? I usually don't have POP visible, but such a grave error in titles and cast wouldn't have gone unnoticed.

All are replaced. Not just at "place of purchase".


Quoting Mithi:
Quote:
What does index.php?action=info gives you on your system?
Mine: phpDVDProfiler:Version=3.8.2.0|XML:Version=2014-04-01-18:58:15|MySQL:Version=4.1.22-log|PHP:Version=5.2.17

Mine returns: phpDVDProfiler:Version=3.8.2.1|XML:Version=2014-03-29-06:25:35|MySQL:Version=5.5.34-MariaDB|PHP:Version=5.5.9
So all seems rather current.


Quoting Mithi:
Quote:
At the moment I suspect your MySQL, although I have no idea how that could not be able to handle simple umlauts. Can you change the copepage for your mysql-db?

Yes i've tried to change the codepage. It has no effect. And as all different Umlaut character change to the same ?, i suspect that the original character info is lost during the update process.


Quoting DJ Doena:
Quote:
The new home for phpDVDProfiler is here:

http://www.dvdcollectorsonline.com/index.php?action=forum#14

3.8.2.1 fixed some problems with german Umlauts in relation to a PHP version newer than 5.4.0, maybe something was overlooked for the retailer field

oh it seems i've been gone to the wrong place.  But the problem here concerns all fields. But it's the retailer field who crashes the updater.
Take a look here: Test-Set-up

Quoting emmeli:
Quote:

then use phpMyProfiler.

it´s the better script (for german profiles). if you have an questions feel free to ask.

cheers emmeli

thanks for the hint.
I'll give it a try 
DVD Profiler Desktop and Mobile RegistrantStar ContributorCyrille
User since: 12/15/2003
Registered: March 13, 2007
Reputation: High Rating
Belgium Posts: 467
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I hosted my web site on my Synology NAS et since the latest major update (DSM 5), the import of XML file doesn't work anymore correctly. In the update DSM 5, Synology has replaced MySQL by MariaDB so maybe it's not fully same and compatible with MySQL.

When I import my XML file, I have the following message:

Quote:

Posting an update request

Response received for update request ... Handled by Connection Id 993

XML file specified is 'Collection.xml'
'Collection.xml' appears to be a file of type 'DVD Profiler XML'
Faster, more memory-intensive updates: On
Complete Update:
Mise à jour de la base de données en cours à partir du fichier XML :
File being processed: Collection.xml
Posting an update request

Response received for update request ... Handled by Connection Id 996

XML file specified is 'Collection.xml'
'Collection.xml' appears to be a file of type 'DVD Profiler XML'
Faster, more memory-intensive updates: On
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.
Mise à jour de la base de données en cours à partir du fichier XML :
Resuming an incomplete update — starting 3 profiles (37 948 bytes) into file Collection.xml
File being processed: Collection.xml
Turning Faster, more memory-intensive updates: off

Posting an update request

Response received for update request ... Handled by Connection Id 998

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.
Mise à jour de la base de données en cours à partir du fichier XML :
Resuming an incomplete update — starting 3 profiles (37 948 bytes) into file Collection.xml
File being processed: Collection.xml


In the error log I have:

Quote:
[07-Apr-2014 17:44:40 Europe/Brussels] PHP Notice:  Undefined index: firstname in /volume1/web/invelos/popup.php on line 281
[07-Apr-2014 17:44:40 Europe/Brussels] PHP Notice:  Undefined index: lastname in /volume1/web/invelos/popup.php on line 282
[07-Apr-2014 17:44:40 Europe/Brussels] PHP Notice:  Undefined index: middlename in /volume1/web/invelos/popup.php on line 283
[07-Apr-2014 20:38:05 Europe/Brussels] PHP Fatal error:  <u>SQL ERROR</u> [ mysql ]<br /><br /><br /><br /><u>CALLING PAGE</u><br /><br />/invelos/index.php&<br /><br /><u>SQL</u><br /><br />SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='VidÈo Square'<br /> in /volume1/web/invelos/mysql.php on line 455
[07-Apr-2014 20:38:09 Europe/Brussels] PHP Fatal error:  <u>SQL ERROR</u> [ mysql ]<br /><br /><br /><br /><u>CALLING PAGE</u><br /><br />/invelos/index.php&<br /><br /><u>SQL</u><br /><br />SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='VidÈo Square'<br /> in /volume1/web/invelos/mysql.php on line 455
[07-Apr-2014 20:38:11 Europe/Brussels] PHP Fatal error:  <u>SQL ERROR</u> [ mysql ]<br /><br /><br /><br /><u>CALLING PAGE</u><br /><br />/invelos/index.php&<br /><br /><u>SQL</u><br /><br />SELECT sid FROM DVDPROFILER_dvd_supplier WHERE suppliername='VidÈo Square'<br /> in /volume1/web/invelos/mysql.php on line 455


I don't know if someone use also a Synology and have updated to DSM 5 or if someone knows MariaDB and can help me. I don't have lot of knowledge in PHP.

And in the DB, the few (3 records) imported, special characters are not correctly displayed.

Thanks
Regards
Cyrille
 Last edited: by Cyrille
DVD Profiler Unlimited RegistrantZipcom
Registered: March 23, 2007
Germany Posts: 72
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Maybe the same problem that i had.
Try to rename the retailer Name "'VidÈo Square" to "Video Square". Let the DVD Profiler database repair run and try another XML update.
This has worked for me.
I use a Synology NAS also. Maybe the MariaDB have some issues with international characters.
DVD Profiler Desktop and Mobile RegistrantStar ContributorCyrille
User since: 12/15/2003
Registered: March 13, 2007
Reputation: High Rating
Belgium Posts: 467
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Zipcom:
Quote:
Maybe the same problem that i had.
Try to rename the retailer Name "'VidÈo Square" to "Video Square". Let the DVD Profiler database repair run and try another XML update.
This has worked for me.
I use a Synology NAS also. Maybe the MariaDB have some issues with international characters.

Yes I think the issue is related to MariaDB because I have a dedicated server with CentOS and MySQL/PHP and no issue to import with the same XML file.
It  could also be an issue with the new version of PHP version and packages used by Synology in DSM 5. I have seen on the web many people complying about DSM 5 and web station hosting.
Regards
Cyrille
DVD Profiler Unlimited RegistrantStar Contributoremmeli
www.myprofiler.de
Registered: June 26, 2013
Reputation: High Rating
Germany Posts: 694
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
can you check your server/database settings and change the character_set for your database to latin1 and collation_server to latin1_swedish_ci?


the real BirthYear OverView
DVD Profiler Unlimited RegistrantZipcom
Registered: March 23, 2007
Germany Posts: 72
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
latin1_swedish_ci is already set.

BTW
there are no problems at all with phpMyProfiler.
DVD Profiler Unlimited RegistrantStar Contributoremmeli
www.myprofiler.de
Registered: June 26, 2013
Reputation: High Rating
Germany Posts: 694
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
then the problem is on phpdvdprofiler. 

the better way is to ask on developler forum ... i think.


the real BirthYear OverView
DVD Profiler Unlimited RegistrantZipcom
Registered: March 23, 2007
Germany Posts: 72
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Funny thing.
I've tried to register for the phpDVDProfiler forum and the phpMyProfiler forum as well. In both cases i haven't received a verification mail (No, it's not in the SPAM folder).
That's the reason why I'm here now.
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,737
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Zipcom:
Quote:
Funny thing.
I've tried to register for the phpDVDProfiler forum and the phpMyProfiler forum as well. In both cases i haven't received a verification mail (No, it's not in the SPAM folder).
That's the reason why I'm here now.


Have you tried to register at dvdcollectorsonline.com, the new home of phpDVDProfiler?
Karsten
DVD Collectors Online

DVD Profiler Unlimited RegistrantStar Contributoremmeli
www.myprofiler.de
Registered: June 26, 2013
Reputation: High Rating
Germany Posts: 694
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
i asked in the phpmyprofiler forum why no mails are sent.


the real BirthYear OverView
DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Hi Zipcom,

You are right, there's no verification mail at the moment for the phpMyProfiler forum.
I have send a mail to the admin, to get this problem solved.

If you have any questions about this script, you can contact me via PM.
DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
You should have received a mail by now. Please let me know, if you don't.
    Invelos Forums->DVD Profiler: DVD Profiler Online Page: 1 2  Previous   Next