Support Home Page › Forums › Joomla Software › Advanced Folder Listing Component › Folder Name with Accents
- This topic has 6 replies, 2 voices, and was last updated 9 years, 8 months ago by
PaulG1.
-
AuthorPosts
-
July 13, 2015 at 2:41 am #815
PaulG1
ParticipantHi
I have a French language site.
If the folder name has an accent then the files inside do not get found – eg santé
Is there any solution for this please.
July 13, 2015 at 4:18 am #2147Michael Gilkes
KeymasterJuly 13, 2015 at 4:49 am #2148PaulG1
ParticipantThanks….
Yes I sync the files – it does list the files as you will see in this screenshot but the path is getting truncated – eg santé becomes sant – so the file shows as not existing – and does not show on front end either
http://i592.photobucket.com/albums/tt5/Paul_Gutch/advlist_screen1_zpsxisrtoxn.jpg
Sorry I have it on localhost so can’t share any link to site yet.
July 13, 2015 at 12:37 pm #2149Michael Gilkes
Keymaster@PaulG1. Thanks for sharing that. Just to show you that it works normally:
http://i793.photobucket.com/albums/yy219/michaelgilkes/Business%20Screenshots/afl_sync_sante.png
There is really nothing in my code that would truncate it. So, this is quite strange. Hmm… the only thing that comes to mind what how it is stored in the database. Can you tell me what the Collation is for the #_advlisting_files table in your database? Just make a screenshot and show me.
July 14, 2015 at 9:37 pm #2150PaulG1
ParticipantHi
Collation for whole DB is utf8_general_ci
Should I try something else?
I edited the relative_path in the DB to be santé and saved.
Then went into file listing and correct Relative Path is showing – ( but file not exits as not synced)
Did a clean and a sync and relative path get truncated again – back to sant
July 15, 2015 at 3:28 pm #2151Michael Gilkes
Keymaster@PaulG1. Thanks for following up. This is very strange. Testing this on my systems do not produce the same results as you, and there is not code that I have written that truncates words with non-ascii characters. What makes it worse is that you have this set up on a localhost, so I can’t really observe this behavior directly or run any tests. Ok… please answer this questions, and provide screenshots as well:
1. If you add santé to the Listing Path in the Listings and save it, does it get truncated?
2. If santé is in the Listing Path, and you click “Sync” in the Files Manager, will it detect all the files?
3. If santé is NOT in the Listing Path, but rather is the name of one of the subfolders, and you sync the files in the Files Manager, will “santé” or “sant” show in the relative path column?
4. If you edit the database relative_path directly and change “sant” to “santé”, and do NOT click “clean” and “sync” but just refresh the Files Manager, what shows in the relative path column? “sant” or “santé”? and does it show as file exists or not?
I hope you can answer those questions and provide screenshots as well. Sorry for the inconvenienve of having to do all this, but it is the only way I can get a fuller idea of what may be happening.
July 15, 2015 at 11:04 pm #2152PaulG1
ParticipantHi – Good news
Thanks very much for your support.
I moved the site to my cloud server and now everything is working fine. Folder and file names with accents are being read ok.
So must have been an issue related to my localhost environment – I use Uniform Server.
Again thanks for the support – we love your work….
-
AuthorPosts
- The topic ‘Folder Name with Accents’ is closed to new replies.