Task #48098
closed
Reversed order in sorting field in sys_file_reference compared to e.g. tt_content
0%
Description
The sorting field in the sys_file_reference table used for the ordering of the images in the content elements is in the wrong order compared to e.g. the sorting field in the tt_content table. Highest sorting number is the first element in sys_file_reference whereas the lowest sorting number is usually the first element in other tables of Typo3.
Updated by Klaus Hinum almost 11 years ago
Correction the sorting field is not used for the ordering of the images in the content element, sorting_foreign is, which is used in the correct ordering (but not like everywhere else with magnitudes of 2). e.g. 1,2,3,4 instead of 1,2,4,8,...
Updated by Thorsten Kahler almost 11 years ago
- Status changed from New to Needs Feedback
- Assignee set to Klaus Hinum
Klaus Hinum wrote:
Correction the sorting field is not used for the ordering of the images in the content element, sorting_foreign is, which is used in the correct ordering (but not like everywhere else with magnitudes of 2). e.g. 1,2,3,4 instead of 1,2,4,8,...
So can this issue be closed?
Updated by Klaus Hinum almost 11 years ago
Altough it is not that important (not sure why that sorting is used), it is still the wrong order, and the sorting_foreign is, like i mentioned not like the other sorting field conventions.
Updated by Alexander Opitz over 10 years ago
- Status changed from Needs Feedback to New
- Assignee deleted (
Klaus Hinum) - Is Regression set to No
Do not assign yourself to an issue, if you don't work on them.
Updated by Ernesto Baschny over 10 years ago
- Tracker changed from Bug to Task
- Category set to File Abstraction Layer (FAL)
- Status changed from New to Rejected
- Priority changed from Should have to Won't have this time
sys_file_reference.sorting is indeed not used at all, and it remains to be analysed if we can remove it. I'll open up an issue for that.
The sorting_foreign field is being updated by IRRE when storing the elements, and it does not use the same algorythm than regular records. But the only requirement is that these integers are comparable.
The 1,2,4,8,16 etc convention for regular records is to improve performance while moving one element "Up" or "Down" (in the list view), so that not the whole table needs to be SQL-UPDATED, but only certain records.
Updated by Stephan Großberndt over 6 years ago
- Related to Bug #80800: Too many records on sys_file_reference table breaks TYPO3 when saving IRRE records added