Order by Date doesn't work

[simonbuehler]

Bug report

Steps to reproduce

1. sort by date or name descending
2. images are not in correct order

Expected behaviour

sort it out

Actual behaviour

Server configuration detail

Operating system: Linux 3.2.12-gentoo #5 SMP Wed Apr 4 01:38:47 CEST 2012 x86_64

Webserver: Apache (fpm-fcgi)

Database: mysql 5.6.35

PHP version: 5.6.31-pl0-gentoo Modules loaded: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, session, intl, json, ldap, mbstring, mcrypt, standard, mysqlnd, mysqli, mysql, PDO, pdo_mysql, pdo_sqlite, Phar, posix, pspell, readline, Reflection, imap, SimpleXML, soap, exif, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, zip, cgi-fcgi, geoip, apcu, imagick, magickwand, apc, Zend OPcache

Nextcloud version: 13.0.0 Beta 3 - 13.0.0.8

Updated from an older Nextcloud/ownCloud or fresh install:

Where did you install Nextcloud from: unknown

Signing status

Array

List of activated apps

``` Enabled: - activity: 2.6.1 - admin_audit: 1.3.0 - audioplayer: 2.2.1 - bruteforcesettings: 1.0.3 - calendar: 1.5.7 - circles: 0.13.6 - comments: 1.3.0 - contacts: 2.0.1 - dav: 1.4.5 - federatedfilesharing: 1.3.1 - federation: 1.3.0 - files: 1.8.0 - files_downloadactivity: 1.2.0 - files_external: 1.4.1 - files_pdfviewer: 1.2.0 - files_retention: 1.2.0 - files_sharing: 1.5.0 - files_texteditor: 2.5.1 - files_trashbin: 1.3.0 - files_versions: 1.6.0 - files_videoplayer: 1.2.0 - firstrunwizard: 2.2.1 - gallery: 18.0.0 - impersonate: 1.0.2 - issuetemplate: 0.3.0 - logreader: 2.0.0 - lookup_server_connector: 1.1.0 - mail: 0.7.6 - nextcloud_announcements: 1.2.0 - notes: 2.3.2 - notifications: 2.1.2 - oauth2: 1.1.0 - password_policy: 1.3.0 - provisioning_api: 1.3.0 - rainloop: 5.0.6 - serverinfo: 1.3.0 - sharebymail: 1.3.0 - spreedme: 0.3.11 - survey_client: 1.1.0 - systemtags: 1.3.0 - theming: 1.4.1 - twofactor_backupcodes: 1.2.3 - updatenotification: 1.3.0 - user_external: 0.4 - workflowengine: 1.3.0 Disabled: - encryption - socialsharing_diaspora - socialsharing_email - socialsharing_facebook - socialsharing_googleplus - socialsharing_twitter - spreed - tasks - user_ldap - weather ```

Configuration (config/config.php)

``` { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "13.0.0.8", "installed": true, "forcessl": false, "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "php", "preview_libreoffice_path": "\/usr\/bin\/loffice", "enable_previews": true, "preview_max_x": 2048, "preview_max_y": 2048, "preview_max_scale_factor": 10, "preview_max_filesize_image": 50, "loglevel": "3", "enabledPreviewProviders": [ "OC\\Preview\\PNG", "OC\\Preview\\JPEG", "OC\\Preview\\GIF", "OC\\Preview\\BMP", "OC\\Preview\\XBitmap", "OC\\Preview\\MP3", "OC\\Preview\\TXT", "OC\\Preview\\MarkDown" ], "theme": "", "maintenance": false, "secret": "***REMOVED SENSITIVE VALUE***", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "trashbin_retention_obligation": "auto", "user_backends": [ { "class": "OC_User_IMAP", "arguments": [ ] } ], "memcache.local": "\\OC\\Memcache\\APCu", "updater.release.channel": "beta", "htaccess.RewriteBase": "\/", "htaccess.IgnoreFrontController": true, "updater.secret": "***REMOVED SENSITIVE VALUE***" } ```

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

``` With access to your command line run e.g.: sudo -u www-data php occ ldap:show-config from within your Nextcloud installation folder Without access to your command line download the data/owncloud.db to your local computer or access your SQL server remotely and run the select query: SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap'; Eventually replace sensitive data as the name/IP-address of your LDAP server or groups. ```

Client configuration

Browser: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:57.0) Gecko/20100101 Firefox/57.0

[oparoz]

How did you assess they were not in the correct order? We can only sort them based on the upload date.

[simonbuehler]

they are even in a different order everytime when changing to sort by name and then change back to date

[simonbuehler]

maybe this happens when changing sort order while the first page hasen't completely been filled up

[oparoz]

maybe this happens when changing sort order while the first page hasen't completely been filled up

Ah, this is probably it. We can only sort what we see