Bug #35334

Upgrade Wizard does not correctly convert WS states from TYPO3 4.4 -> 4.6

Added by Roland Behme over 9 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Workspaces
Target version:
Start date:
2012-03-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.6
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

When upgrading a TYPO3 installation from 4.4 to 4.6 some of the content records in workspace remained in a "unknown" state after running the Workspace Upgrade Wizard. The Workspace Module displayed "state not found" for these records.

The output of the Upgrade Wizard was:

Update successful!
SELECT COUNT FROM sys_workspace WHERE adminusers != "" AND adminusers NOT LIKE "%be_users%" AND adminusers NOT LIKE "%be_groups%" AND deleted=0
SELECT uid, adminusers FROM sys_workspace WHERE adminusers != "" AND adminusers NOT LIKE "%be_users%" AND adminusers NOT LIKE "%be_groups%" AND deleted=0
UPDATE sys_workspace SET adminusers='be_users_36,be_users_41' WHERE uid = 1
UPDATE sys_workspace SET adminusers='be_users_24,be_users_41' WHERE uid = 3
UPDATE sys_workspace SET adminusers='be_users_41' WHERE uid = 6
SELECT COUNT FROM pages WHERE t3ver_wsid=-1
SELECT COUNT FROM tt_content WHERE t3ver_wsid=-1
SELECT COUNT FROM pages_language_overlay WHERE t3ver_wsid=-1
SELECT COUNT FROM sys_template WHERE t3ver_wsid=-1
SELECT COUNT FROM backend_layout WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_templavoila_tmplobj WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_templavoila_datastructure WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_aoetemplavoila_category WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_aoetemplavoila_definition WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_aoetemplavoila_contentset WHERE t3ver_wsid=-1
SELECT COUNT FROM tt_news WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_mediacorner_category WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_mediacorner_media_element WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_mediacorner_media_rating WHERE t3ver_wsid=-1
SELECT COUNT FROM tx_mediacorner_media_comment WHERE t3ver_wsid=-1
SELECT * FROM sys_workspace WHERE deleted=0 AND uid NOT IN (1,2,3,4,5,6)

I was able to fix this issue by manually running the following SQL-Statement on the database:
UPDATE `tt_content` SET t3ver_stage = -10 WHERE t3ver_stage = 10;

So it seems the wizard does only look for records in Default Draft Workspace (wsuid = -1), here we used a custom Workspace with uid=1.

#1

Updated by Michael Stucki almost 8 years ago

  • Category set to Workspaces
#2

Updated by Michael Stucki almost 8 years ago

  • Project changed from 624 to TYPO3 Core
  • Category changed from Workspaces to Workspaces
#3

Updated by Mathias Schreiber almost 7 years ago

  • Target version set to 7.5
#4

Updated by Benni Mack about 6 years ago

  • Target version changed from 7.5 to 7 LTS
#5

Updated by Benni Mack about 6 years ago

  • Status changed from New to Closed
  • Is Regression set to No

As we don't support 4.x anymore, and all code should be fixed by 6.2 and 7 by now, I will close this issue. If you see it differently or still have trouble - let me know via email () and I will re-open the ticket again.

Also available in: Atom PDF