Task #48098
closed
Reversed order in sorting field in sys_file_reference compared to e.g. tt_content
Added by Klaus Hinum about 11 years ago.
Updated almost 11 years ago.
Priority:
Won't have this time
Category:
File Abstraction Layer (FAL)
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.
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,...
- 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?
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.
- 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.
- 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.
- Related to Bug #80800: Too many records on sys_file_reference table breaks TYPO3 when saving IRRE records added
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by