Folder Name with Accents

Home \ forums/topic \ Folder Name with Accents

This topic contains 6 replies, has 2 voices, and was last updated by  PaulG1 4 years, 5 months ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #815

    PaulG1
    Participant

    Hi

    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.

    #2147

    Michael Gilkes
    Keymaster

    @paulg1. I just tested this on my test server, and it shows it just fine. See the screeshot.

    Did you sync your files? Are you getting errors? Send me an email with more detail. If you want, you can give me a temporary admin login and I will log into your site and investigate what is going on.

    #2148

    PaulG1
    Participant

    Thanks….

    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.

    #2149

    Michael 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.

    #2150

    PaulG1
    Participant

    Hi

    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

    #2151

    Michael 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.

    #2152

    PaulG1
    Participant

    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….

Viewing 7 posts - 1 through 7 (of 7 total)

The topic ‘Folder Name with Accents’ is closed to new replies.