Project

General

Profile

Actions

Bug #35334

closed

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

Added by Roland Behme over 12 years ago. Updated about 9 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.

Actions

Also available in: Atom PDF