| Author |
Message |
| Registered: March 23, 2007 |  Posts: 72 |
| | Posted: | | | | 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. |
|
| Registered: June 26, 2013 | Reputation:  | | Posts: 694 |
| |
| Registered: March 13, 2007 | Reputation:  | | Posts: 2,217 |
| | Posted: | | | | 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 |
|
| Registered: March 14, 2007 | Reputation:  | | Posts: 6,744 |
| |
| Registered: March 23, 2007 | | Posts: 72 |
| | Posted: | | | | 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-upQuoting 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  |
|
| Registered: March 13, 2007 | | Reputation: |  Posts: 467 |
| | Posted: | | | | 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 |
|
| Registered: March 23, 2007 | | Posts: 72 |
| | Posted: | | | | 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. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 467 |
| | Posted: | | | | 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 |
|
| Registered: June 26, 2013 | | Reputation: | | Posts: 694 |
| | Posted: | | | | 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 |
|
| Registered: March 23, 2007 | | Posts: 72 |
| | Posted: | | | | latin1_swedish_ci is already set.
BTW
there are no problems at all with phpMyProfiler. |
|
| Registered: June 26, 2013 | | Reputation: | | Posts: 694 |
| |
| Registered: March 23, 2007 | | Posts: 72 |
| | Posted: | | | | 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. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,744 |
| | Posted: | | | | 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
 |
|
| Registered: June 26, 2013 | | Reputation: | | Posts: 694 |
| |
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | 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. | | |  |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | You should have received a mail by now. Please let me know, if you don't. | | | |
|