July 13, 2015 at 2:41 am #815
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 #2147July 13, 2015 at 4:49 am #2148
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
Sorry I have it on localhost so can’t share any link to site yet.July 13, 2015 at 12:37 pm #2149
@paulg1. Thanks for sharing that. Just to show you that it works normally:
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 #2150
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 santJuly 15, 2015 at 3:28 pm #2151
@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 #2152
Hi – 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….
The topic ‘Folder Name with Accents’ is closed to new replies.