TYPO3 Core

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.