Sorting order (when manually configured) will not work as expected

[Githopp192]

Describe the bug Sorting order (when manually configured) will not work.

not in every case - but from time to time - all entries will be sorted alphabetically (benutzerdefinierte Sortierung - unchanged !). To re-order all entries (when there are more than 100) is very time intensive. This happens for parent folders (entries), children, sub-children ..

To Reproduce Steps to reproduce the behavior:

1. User Definded sorting (Benutzerdefinierte Sortierung)
2. Sort entries manually by "drag & drop"

Expected behavior

By refreshing the collectives page, by logging out/in, by leaving the app - the sorting order should be static.

Screenshots

Server details:

• Collectives app version: - collectives: 2.12.0
• Nextcloud version: 27.1.11
• PHP Version: 8.2
• Database: MariaDB 10.7

Client details:

OS:Windows Browser: Version 126.0.2592.87 (Offizielles Build) (64-Bit)

[castrv]

Hello,

The same happens to me. I'm using the latest Nextcloud AIO on latest Debian.

[Githopp192]

This happend to me again today, after drag & drop one content to another place .. had to manually order again some other stuff, which was in the right order previously

[mejo-]

Dear all, thanks for your reports. I didn't manage to reproduce this so far, and given that I know several setups where sorting by drag'n'drop is heavily used, I wonder what's the difference with your setup.

To get a better understanding: you sort pages with drag'n'drop, the UI reacts as expected and pages get rearranged. No error message pops up. After reloading, the custom ordering is gone again?

Is this reproducible for you in a reliable way? If so, could you open the browser console and see if any error messages get logged to it?

I could imagine that ordering in the frontend succeeds while updating the ordering in the database fails due to connectivity issues on your side, but in this case you should see an error message and the ordering should be reverted straight away.

[mejo-]

Another thought: could it be that the file IDs of your files change due to changes in the storage? That would explain why all the custom page order gets reset at once.

[Githopp192]

Dear Jonas .. regarding to some aspects you mentioned ==>

• you sort pages with drag'n'drop, the UI reacts as expected ==>

• Wanted to move one item to another place by drag and drop

• after that some items, which were on top previously, moved to the middle of the board

• so i had to re-order them

• this item i tried to move, did not get to the place, where i want the item is

• this item got at the top of board

no error message pops up. ==>

• no error messages seen

  After reloading, the custom ordering is gone again? ==>

• no, this will not be the case normally

• only in rare situation (where we don't know, where they come from ..), the order will re-arranged alphabetically (leaving the manuar order/sort)

reproducible for you in a reliable way? ==>

• at the moment i cannot reproduce, because it's rare, but it happens from time to time
• when this happen againg - yes - will press F12 to check the logs

... database fails due to connectivity issues on your side ==>

• don't think so - never saw a SQL-Error statement in the nextcloud.log
• network in my environment is stable (Gbit cabled stack, Enterprise Server)

.. hat the file IDs of your files change due to changes in the storage? ==>

• storage is a high-end datastore, provided through NFS & no other service is allowed to access the storage, than the nextcloud instance itself.

Thx Jonas to have a look to this item :-)

[blizzz]

I can reproduce it when adding a new page ("September" in the screenshot):