Bug #65193
closed
Upgrade Wizard: Image Sorting lost
Added by Philipp Müller almost 10 years ago.
Updated over 6 years ago.
Description
Hi
After the upgrade from 4.5 to 6.2 the image-sorting of content-elements will be lost.
Best regards
Philipp
Files
- Status changed from New to Under Review
Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/37042
Patch set 2 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/37042
Patch set 3 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/37042
Please test the patch linked above and vote for it. Thank you.
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
I just used the following SQL script to recreate the sortign fields some month after upgrading from T3 4.5 to 6.2:
SET @sorting := 0;
SET @previous := 0;
UPDATE `sys_file_reference`
SET `sorting` = (case when @previous = uid_foreign then @sorting := @sorting + 1 else concat( left(@previous := uid_foreign, 0), @sorting := 0) end),
`sorting_foreign` = (@sorting + 256)
ORDER BY `uid_foreign`, `uid`
Be aware that it overwrites all sorting fields that were changed since the upgrade. In my case, that was fine.
- Status changed from Resolved to Closed
Also available in: Atom
PDF