Support > cpg1.6 language
Umlauts in Category Names - Pictures are not shown
Fotoflieger:
Thanks ron4mac for advice
I did the export of the table used Format XML.
Then I replaced Umlauts with Notepad ++, stored it in a different directory and did the import.
With phpmyadmin I see: with PID= 24739 "Dorfmärt_2014_Thalheim-AK3A9477-Bild_25.jpg"
In gallery : https://telesys.ch/thumbnails.php?album=784
I see the correct file name Dorfmärt_2014_Thalheim-AK3A9477-Bild_25.jpg
But it still does not display the picture. Other pictures are displayed like before.
What could be wrong?
BTW I still have the old table renamed.
ron4mac:
When browsing files, the attached is what I see. What do you see with your host file manager. The diamond with a ? represents an invalid character.
Fotoflieger:
I use FileZilla. Here Umlauts look good in both cases below. Seems to be an issue of different character sets.
In phpmyadmin shows for filename: latin1_swedish_ci
in phpmyadmin PID =23 shows "Militär_Marthalen_2008-3.jpg" and this is correct displayed in CPG
see attachment
in phpmyadmin PID =24739 shows "Dorfmärt_2014_Thalheim-AK3A9477-Bild_25.jpg" and this is not displayed in CPG
see attachment
What could I do?
Fotoflieger:
--- Quote from: Fotoflieger on October 13, 2022, 10:27:13 am ---I use FileZilla. Here Umlauts look good in both cases below. Seems to be an issue of different character sets.
In phpmyadmin shows for filename: latin1_swedish_ci
in phpmyadmin PID =23 shows "Militär_Marthalen_2008-3.jpg" and this is correct displayed in CPG
see attachment
in phpmyadmin PID =24739 shows "Dorfmärt_2014_Thalheim-AK3A9477-Bild_25.jpg" and this is not displayed in CPG
see attachment
What could I do?
--- End quote ---
ron4mac:
The picture is becoming clear for me. Your site was moved from a non-utf-8 server (windows?) to a utf-8 *nix server (ubuntu). The host may have had a script that would do the conversion for a CPG site ... but it failed in some ways. All of your images in albums/userpics/.. (the normal location for CPG images) had their file names converted and the database entries for them were converted, as well. But all the images in your batched folders were not converted. You may have corrected the database entries but the actual file names do not yet match. There is a utility (convmv) that needs to be run on your batch folders to convert the filename encodings to utf8. In the case of FileZilla, it probably has built-in function to properly show you the names regardless of encoding. Whoever was involved in your site move may have the means to convert those filename encodings.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version