Folders starting with UPPERCASE Umlaut (e.g. Ä, Ö, Ü) are not sorted correctly #3804

DjZU · 2013-06-20T16:46:20Z

Expected behaviour

Folders starting with UPPERCASE amlaut (e.g. Ä, Ö, Ü) should be correctly sorted, like it does for lowercase folders and both upper/lowercase files.

Actual behaviour

Folders starting with UPPERCASE amlaut (e.g. Ä, Ö, Ü) are not sorted correctly. They show up after folders starting with Z for instance.

Steps to reproduce

Create a folder called A
Create a folder called Z
Create a folder called Ä
Reload the page (indeed it shows up correctly before refresh...)

Server configuration

Operating system:
Debian 6.0.7 Squeeze
Web server:
Apache
Database:
MySQL
PHP version:
5.4
ownCloud version:
5.0.7

Client configuration

Browser:
Firefox 21.0
Operating system:
Windows 7 Edition Familiale Premium SP1

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

{"app":"PHP","message":"mysql_close(): 46 is not a valid MySQL-Link resource at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/setup.php#277","level":2,"time":1370972282}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/\" (does not exist, or is not a file)","level":2,"time":1371043221}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/\" (does not exist, or is not a file)","level":2,"time":1371043222}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/\" (does not exist, or is not a file)","level":2,"time":1371043222}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/test: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/test\" (does not exist, or is not a file)","level":2,"time":1371048629}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371134957}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371134989}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371281926}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/_SYNCAPP: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/_SYNCAPP\" (does not exist, or is not a file)","level":2,"time":1371281981}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/webdav-windows-seven-registry-hack.txt: unable to determine file format","level":2,"time":1371308527}
{"app":"PHP","message":"iconv(): Detected an illegal character in input string at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/search_lucene\/3rdparty\/Zend\/Search\/Lucene\/Analysis\/Analyzer\/Common\/TextNum.php#58","level":2,"time":1371308529}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/poil: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/poil\" (does not exist, or is not a file)","level":2,"time":1371309106}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/webdav-windows-seven-registry-hack.txt: unable to determine file format","level":2,"time":1371595579}
{"app":"PHP","message":"iconv(): Detected an illegal character in input string at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/search_lucene\/3rdparty\/Zend\/Search\/Lucene\/Analysis\/Analyzer\/Common\/TextNum.php#58","level":2,"time":1371595580}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/webdav-windows-seven-registry-hack.txt: unable to determine file format","level":2,"time":1371595705}
{"app":"PHP","message":"iconv(): Detected an illegal character in input string at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/search_lucene\/3rdparty\/Zend\/Search\/Lucene\/Analysis\/Analyzer\/Common\/TextNum.php#58","level":2,"time":1371595705}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/webdav-windows-seven-registry-hack.txt: unable to determine file format","level":2,"time":1371596853}
{"app":"PHP","message":"iconv(): Detected an illegal character in input string at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/search_lucene\/3rdparty\/Zend\/Search\/Lucene\/Analysis\/Analyzer\/Common\/TextNum.php#58","level":2,"time":1371596853}
{"app":"PHP","message":"opendir(\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/dudu\/cache\/): failed to open dir: No such file or directory at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/files\/storage\/local.php#40","level":2,"time":1371628629}
{"app":"PHP","message":"readdir() expects parameter 1 to be resource, boolean given at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/cache\/file.php#89","level":2,"time":1371628629}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371662974}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371662974}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371663159}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371663159}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664292}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664292}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664364}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664364}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664482}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664482}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664568}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664568}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664631}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664631}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664832}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664832}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664920}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664920}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664991}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371664991}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371665108}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371665108}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371665752}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371665752}
{"app":"PHP","message":"PDOStatement::execute(): MySQL server has gone away at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371666445}
{"app":"PHP","message":"PDOStatement::execute(): Error reading result set's header at \/homepages\/36\/d297499038\/htdocs\/owncloud\/lib\/db.php#966","level":2,"time":1371666445}
{"app":"hook","message":"error while running hook (OCA\\Files_Trashbin\\Hooks::remove_hook): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","level":3,"time":1371666445}
{"app":"hook","message":"error while running hook (\\OC\\Files\\Cache\\Shared_Updater::deleteHook): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","level":3,"time":1371666445}
{"app":"hook","message":"error while running hook (OCA\\Search_Lucene\\Hooks::deleteFile): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","level":3,"time":1371666445}
{"app":"hook","message":"error while running hook (\\OC\\Files\\Cache\\Updater::deleteHook): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","level":3,"time":1371666445}
{"app":"hook","message":"error while running hook (OCA\\Gallery\\Thumbnail::removeHook): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","level":3,"time":1371666445}
{"app":"hook","message":"error while running hook (OCA\\Files_Versions\\Hooks::remove_hook): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","level":3,"time":1371666445}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\" (does not exist, or is not a file)","level":2,"time":1371716629}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\" (does not exist, or is not a file)","level":2,"time":1371732791}
{"app":"PHP","message":"Undefined offset: 1 at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/gallery\/ajax\/gallery.php#12","level":2,"time":1371732794}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/_SYNCAPP: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/_SYNCAPP\" (does not exist, or is not a file)","level":2,"time":1371740901}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Roots, The [1996] Illadelph Halflife \u00b0: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Roots, The [1996] Illadelph Halflife \u00b0\" (does not exist, or is not a file)","level":2,"time":1371742060}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/NTM [2001] Le Clash BOSS vs. IV My People (CD1): Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/NTM [2001] Le Clash BOSS vs. IV My People (CD1)\" (does not exist, or is not a file)","level":2,"time":1371742527}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Dionysos [1998] The sun is blue like the eggs in winter: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Dionysos [1998] The sun is blue like the eggs in winter\" (does not exist, or is not a file)","level":2,"time":1371742543}
{"app":"PHP","message":"Undefined offset: 1 at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/gallery\/ajax\/gallery.php#12","level":2,"time":1371742545}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Electric Guest [2012] Mondo: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Electric Guest [2012] Mondo\" (does not exist, or is not a file)","level":2,"time":1371742687}
{"app":"PHP","message":"Undefined offset: 1 at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/gallery\/ajax\/gallery.php#12","level":2,"time":1371742689}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Aerosmith [1989] Pump: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Aerosmith [1989] Pump\" (does not exist, or is not a file)","level":2,"time":1371744363}
{"app":"PHP","message":"Undefined offset: 1 at \/homepages\/36\/d297499038\/htdocs\/owncloud\/apps\/gallery\/ajax\/gallery.php#12","level":2,"time":1371744366}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Ridan [2007] L'Ange de Mon D\u00e9mon \u00b0: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Ridan [2007] L'Ange de Mon D\u00e9mon \u00b0\" (does not exist, or is not a file)","level":2,"time":1371744598}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Bobby McFerrin [1993] Somewhere Over The Rainbow: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Bobby McFerrin [1993] Somewhere Over The Rainbow\" (does not exist, or is not a file)","level":2,"time":1371744676}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Iron Maiden [1981] Killers: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Iron Maiden [1981] Killers\" (does not exist, or is not a file)","level":2,"time":1371744750}
{"app":"search_lucene","message":"failed to extract meta information for \/DjZU\/files\/Musique\/_Albums\/Tiken Jah Fakoly [1999] Cours d'histoire: Could not open \"\/homepages\/36\/d297499038\/htdocs\/owncloud\/data\/DjZU\/files\/Musique\/_Albums\/Tiken Jah Fakoly [1999] Cours d'histoire\" (does not exist, or is not a file)","level":2,"time":1371744827}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371745953}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371806150}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371806562}
{"app":"search_lucene","message":"need mimetype for content extraction","level":3,"time":1371806781}

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

The text was updated successfully, but these errors were encountered:

Niduroki · 2013-06-21T02:39:35Z

@DeepDiver1975 (?)

DeepDiver1975 · 2013-06-21T05:21:12Z

Locale en_us is not installed on the server.

DjZU · 2013-06-21T09:10:21Z

@DeepDiver1975 Do you mean this issue is related to my configuration? Where I can change this? I'm on a shared host and my instance of ownCloud is in French.

DeepDiver1975 · 2013-06-21T09:19:03Z

On the server hosting ownCloud we require the locale en_US.UTF8 to be installed.
This is unrelated to the language you are using within your ownCloud instance.

Please double check the logs and/or the admin page within ownCloud a message should be displayed accordingly.

DjZU · 2013-06-21T09:47:09Z

Nothing in owncloud.log related to locale en_US.UTF8 at first sight. Anyway, I can't get root on this host, so I will not be able to install this I guess. Though it seems to be a common package... Should I get cross with 1&1? ^^

DjZU · 2013-06-21T11:26:24Z

Added owncloud.log

DeepDiver1975 · 2013-06-21T11:32:33Z

Reload the page (indeed it shows up correctly before refresh...)

Forget my idea about the locale - the issue is related to different comparison algorithms php vs. js

@raghunayyar @Raydiation (aka JavaScript-Wizards ;-) ) any idea on proper javascript sorting respecting the language settings?

vgezer · 2014-04-05T19:07:48Z

~~I think this works now.~~

Took it back. Refreshing breaks the order as it is indicated.

LukasReschke · 2014-09-16T15:29:23Z

Should be fixed by #7254

vgezer · 2014-09-16T18:42:45Z

Unfortunately no :(. Ö should be just after O

LukasReschke · 2014-09-16T18:43:44Z

Is the intl extension installed?

vgezer · 2014-09-16T18:45:41Z

Yay! Now works. I will add this to documentation :)

LukasReschke · 2014-09-16T18:46:09Z

Great - thank you :-)

DeepDiver1975 closed this as completed Jun 21, 2013

DeepDiver1975 reopened this Jun 21, 2013

PVince81 mentioned this issue Feb 18, 2014

Fixed JS sort comparator to be consistent between JS and PHP #7254

Merged

LukasReschke closed this as completed Sep 16, 2014

vgezer reopened this Sep 16, 2014

vgezer closed this as completed Sep 16, 2014

vgezer mentioned this issue Sep 16, 2014

new appliance and explain intl extension owncloud-archive/documentation#566

Merged

lock bot locked as resolved and limited conversation to collaborators Aug 16, 2019

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Folders starting with UPPERCASE Umlaut (e.g. Ä, Ö, Ü) are not sorted correctly #3804

Folders starting with UPPERCASE Umlaut (e.g. Ä, Ö, Ü) are not sorted correctly #3804

DjZU commented Jun 20, 2013

Niduroki commented Jun 21, 2013

DeepDiver1975 commented Jun 21, 2013

DjZU commented Jun 21, 2013

DeepDiver1975 commented Jun 21, 2013

DjZU commented Jun 21, 2013

DjZU commented Jun 21, 2013

DeepDiver1975 commented Jun 21, 2013

vgezer commented Apr 5, 2014

LukasReschke commented Sep 16, 2014

vgezer commented Sep 16, 2014

LukasReschke commented Sep 16, 2014

vgezer commented Sep 16, 2014

LukasReschke commented Sep 16, 2014

Folders starting with UPPERCASE Umlaut (e.g. Ä, Ö, Ü) are not sorted correctly #3804

Folders starting with UPPERCASE Umlaut (e.g. Ä, Ö, Ü) are not sorted correctly #3804

Comments

DjZU commented Jun 20, 2013

Expected behaviour

Actual behaviour

Steps to reproduce

Server configuration

Client configuration

Logs

Web server error log

ownCloud log (data/owncloud.log)

Browser log

Niduroki commented Jun 21, 2013

DeepDiver1975 commented Jun 21, 2013

DjZU commented Jun 21, 2013

DeepDiver1975 commented Jun 21, 2013

DjZU commented Jun 21, 2013

DjZU commented Jun 21, 2013

DeepDiver1975 commented Jun 21, 2013

vgezer commented Apr 5, 2014

LukasReschke commented Sep 16, 2014

vgezer commented Sep 16, 2014

LukasReschke commented Sep 16, 2014

vgezer commented Sep 16, 2014

LukasReschke commented Sep 16, 2014