Project

General

Profile

Actions

Bug #65193

closed

Upgrade Wizard: Image Sorting lost

Added by Philipp Müller almost 10 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Install Tool
Target version:
Start date:
2015-02-20
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
5.5
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:

Description

Hi

After the upgrade from 4.5 to 6.2 the image-sorting of content-elements will be lost.

Best regards
Philipp


Files

image_sorting_4.5.png (59.4 KB) image_sorting_4.5.png Image-Sorting before upgrade (TYPO3 4.5.39) Philipp Müller, 2015-02-20 11:34
image_sorting_6.2.png (111 KB) image_sorting_6.2.png Image-Sorting after upgrade (TYPO3 6.2.9) Philipp Müller, 2015-02-20 11:34
Actions #1

Updated by Gerrit Code Review almost 10 years ago

  • 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

Actions #2

Updated by Gerrit Code Review almost 10 years ago

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

Actions #3

Updated by Gerrit Code Review almost 10 years ago

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

Actions #4

Updated by Markus Klein almost 10 years ago

  • Complexity set to easy

Please test the patch linked above and vote for it. Thank you.

Actions #5

Updated by Nicole Cordes almost 10 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #6

Updated by Adrian Dymorz over 9 years ago

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.

Actions #7

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF