[Bug]: File sorting based on numbers (with points ) changed in NC 28 #42826

ONP-ISI · 2024-01-16T08:25:59Z

⚠️ This issue respects the following points: ⚠️

This is a bug, not a question or a configuration/webserver/proxy issue.
This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
I agree to follow Nextcloud's Code of Conduct.

Bug description

File sorting based on numbers with points ( YYYY.MM.DD ) has changed in 28.0.1. No problem is 27.1.5
For example, with 3 folders named 2023.01.08, 2023.04.09, 2023.10.12, if I to do descending sort order or ascending, 2023.01.08 will be in the middle, not at the beginning or the end.
If you replace points with hyphens (2023-01-08, 2023-04-09, 2023-10-12), 2023-01-08 will be at beginning or at the end.

Steps to reproduce

1.Create 3 folder named 2023.01.08, 2023.04.09, 2023.10.12
2.Clich on file sort by name
3.

Expected behavior

NOK : Descending sort order or ascending, 2023.01.08 will be in the middle, not at the beginning or the end.
OK : Replace points with hyphens (2023-01-08, 2023-04-09, 2023-10-12), 2023-01-08 will be at beginning or at the end.

Installation method

Community Manual installation with Archive

Nextcloud Server version

28

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 22 to 23)

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

Default user-backend (database)
LDAP/ Active Directory
SSO - SAML
Other

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "192.168.XXX.XXX",
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "28.0.1.1",
        "overwrite.cli.url": "https:\/\/XXX.XXX.XXX.fr\/nextcloud",
        "overwritehost": "XXX.XXX.XXX.fr",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "default_phone_region": "FR",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "mail_sendmailmode": "smtp",
        "default_language": "fr",
        "default_locale": "fr_FR",
        "skeletondirectory": "",
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "user_email_visible": "true"
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - circles: 28.0.0-dev
  - cloud_federation_api: 1.11.0
  - dav: 1.29.1
  - federatedfilesharing: 1.18.0
  - federation: 1.18.0
  - files: 2.0.0
  - files_accesscontrol: 1.18.0
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - files_trashbin: 1.18.0
  - files_versions: 1.21.0
  - groupfolders: 16.0.2
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - notifications: 2.16.0
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - quota_warning: 1.18.0
  - recommendations: 2.0.0
  - related_resources: 1.3.0
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - sharebymail: 1.18.0
  - systemtags: 1.18.0
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - updatenotification: 1.18.0
  - user_ldap: 1.19.0
  - viewer: 2.2.0
  - workflowengine: 2.10.0
Disabled:
  - admin_audit: 1.18.0
  - bruteforcesettings: 2.8.0 (installed 2.4.0)
  - comments: 1.18.0 (installed 1.10.0)
  - contactsinteraction: 1.9.0 (installed 1.1.0)
  - dashboard: 7.8.0 (installed 7.0.0)
  - encryption: 2.16.0
  - files_antivirus: 5.4.0 (installed 5.4.0)
  - files_automatedtagging: 1.18.0 (installed 1.18.0)
  - files_downloadactivity: 1.16.0 (installed 1.16.0)
  - files_external: 1.20.0
  - files_retention: 1.16.0 (installed 1.16.0)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - files_trackdownloads: 1.11.0 (installed 1.11.0)
  - firstrunwizard: 2.17.0 (installed 2.9.0)
  - nextcloud_announcements: 1.17.0 (installed 1.9.0)
  - photos: 2.4.0 (installed 1.1.0)
  - ransomware_protection: 1.14.0 (installed 1.14.0)
  - sharelisting: 1.2.0 (installed 1.2.0)
  - side_menu: 3.11.2 (installed 3.11.2)
  - support: 1.11.0 (installed 1.3.0)
  - survey_client: 1.16.0 (installed 1.8.0)
  - suspicious_login: 6.0.0
  - text: 3.9.1 (installed 3.1.0)
  - twofactor_totp: 10.0.0-beta.2
  - user_status: 1.8.1 (installed 1.0.1)
  - weather_status: 1.8.0 (installed 1.0.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

No response

Additional info

No response

ONP-ISI · 2024-01-16T08:27:04Z

https://help.nextcloud.com/t/file-sorting-based-on-numbers-changed-in-nc-28-0-1/179028

jop217 · 2024-02-06T08:54:53Z

Same here. Very frustrating for large folders

v3DJG6GL · 2024-03-07T17:38:04Z

The same goes for me, it's very annoying to have dozens of folders with this naming structure:

szaimen · 2024-03-07T17:43:21Z

Cc @nextcloud/server-frontend

visit1985 · 2024-05-05T12:25:20Z

I have a similar issue with slightly different pattern.

Sorting by Name descending in NC 28:

This may have the same root cause.

v3DJG6GL · 2024-05-06T12:11:54Z

@szaimen
This issue is still present with Nextcloud 29.0.0. Hopefully it will be addressed soon...

autoantwort · 2024-05-13T12:25:00Z

I don't know if I should create a separate bug report for it, but the files are in the right order for me, but when I open the preview the order is not correct.

Screen.Recording.2024-05-13.at.14.19.24.mov

DevMichaelSabo · 2024-06-01T20:56:19Z

The 29.0.1 doesn't fix the problem in https://help.nextcloud.com/t/sorting-doesnt-working/190105!

susnux · 2024-06-01T21:02:26Z

You can see from the milestone of the merged PR that the fix will only be available in Nextcloud 29.0.2+ (and 28.0.7+).

nightcore500 · 2024-06-06T12:45:32Z

As @autoantwort already mentioned, this sorting problem exists not only in the folder listing in the file browser but also in the file preview.
I am now on release 29.0.2 and unfortunately still have the problem that when scrolling through the images in the file preview, the images are displayed completely mixed up. However, the files are displayed correctly in the file browser according to the timestamp in the file name.

Filebrowser:

First file:

Next file:

susnux · 2024-06-07T00:11:27Z

I am now on release 29.0.2 and unfortunately still have the problem that when scrolling through the images in the file preview, the images are displayed completely mixed up.

@nightcore500 you screenshot is lacking the table headers, from the content it seems like you are sorting by date not name?

nightcore500 · 2024-06-07T09:10:15Z

@susnux That is correct. The folder is sorted by date. In the folder view, it is sorted correctly as shown in the screenshot. After IMG20240605 comes IMG20240604. In the preview, however, IMG20240403 suddenly appears after IMG20240605, which is far in the past. I have just sorted by name. It then no longer seems to occur.

susnux · 2024-06-07T15:18:34Z

Yes if you sort by "Modified" then the mtime of the files is checked not the filename, if you sort by "Name" then the filename is taken into account.

nightcore500 · 2024-06-11T09:16:45Z

@susnux Thank you for your help. But after IMG20240605 the file named IMG20240403 is displayed whose mtime does not come after that of IMG20240605. The files are also sorted correctly by mtime in the file browser. IMG20240403 also correctly appears there much later. But not in the preview?

susnux · 2024-06-11T13:54:25Z

I am not sure if I understand you here correctly, this issue is just about the files list.
If you sort by "Name" then only the name is considered, if you sort by "Modified" then only the mtime (the filename is ignored).

If you have issues with the "viewer" (that one that opens if you click on a file), then this is a different issue and should be reported here:

https://github.com/nextcloud/viewer/issues

ONP-ISI added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Jan 16, 2024

szaimen added the 28-feedback label Jan 16, 2024

ONP-ISI changed the title ~~[Bug]:~~ [Bug]: File sorting based on numbers (with points ) changed in NC 28 Jan 16, 2024

joshtrichards added the feature: files label Jan 16, 2024

susnux mentioned this issue May 21, 2024

fix(files): Implement SortingService to fix sorting of files #45419

Merged

4 tasks

susnux closed this as completed in #45419 May 27, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[Bug]: File sorting based on numbers (with points ) changed in NC 28 #42826

[Bug]: File sorting based on numbers (with points ) changed in NC 28 #42826

ONP-ISI commented Jan 16, 2024

ONP-ISI commented Jan 16, 2024

jop217 commented Feb 6, 2024

v3DJG6GL commented Mar 7, 2024 •

edited

Loading

szaimen commented Mar 7, 2024

visit1985 commented May 5, 2024

v3DJG6GL commented May 6, 2024

autoantwort commented May 13, 2024

DevMichaelSabo commented Jun 1, 2024

susnux commented Jun 1, 2024

nightcore500 commented Jun 6, 2024

susnux commented Jun 7, 2024

nightcore500 commented Jun 7, 2024

susnux commented Jun 7, 2024

nightcore500 commented Jun 11, 2024

susnux commented Jun 11, 2024

[Bug]: File sorting based on numbers (with points ) changed in NC 28 #42826

[Bug]: File sorting based on numbers (with points ) changed in NC 28 #42826

Comments

ONP-ISI commented Jan 16, 2024

⚠️ This issue respects the following points: ⚠️

Bug description

Steps to reproduce

Expected behavior

Installation method

Nextcloud Server version

Operating system

PHP engine version

Web server

Database engine version

Is this bug present after an update or on a fresh install?

Are you using the Nextcloud Server Encryption module?

What user-backends are you using?

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

ONP-ISI commented Jan 16, 2024

jop217 commented Feb 6, 2024

v3DJG6GL commented Mar 7, 2024 • edited Loading

szaimen commented Mar 7, 2024

visit1985 commented May 5, 2024

v3DJG6GL commented May 6, 2024

autoantwort commented May 13, 2024

DevMichaelSabo commented Jun 1, 2024

susnux commented Jun 1, 2024

nightcore500 commented Jun 6, 2024

susnux commented Jun 7, 2024

nightcore500 commented Jun 7, 2024

susnux commented Jun 7, 2024

nightcore500 commented Jun 11, 2024

susnux commented Jun 11, 2024

v3DJG6GL commented Mar 7, 2024 •

edited

Loading