TYPO3 Core

Here the message from firebug console :

POST http://mydomain/directory/typo3/ajax...axID=ExtDirect::route&namespace=TYPO3.Workspaces Aborted 29,94s

Referer http://mydomain/directory/typo3/mod.php?M=web_WorkspacesWorkspaces&moduleToken=2b08a7ba

Maybe this fix will solve it.

https://github.com/ohader/TYPO3.CMS-Workspaces/commit/e4fe2cba200ad18b1d3ba98fc700196fc10c0556

Could you check it please?

Related to https://forge.typo3.org/issues/61184

We checked the commit from Oliver and got a better performance. The difference is around 5 seconds!

Hi all,

Martin Trepper's patch from comment #66231-2 does in fact resolve the issue.

The original code is apparently yet unchanged in any TYPO3 CMS 6 version up¹ to² 6.2.12, so that I don't quite see how this could solve this issue aside from being a temporary fix.

The only issue I have with the patch is that it drops the second part of the workspace record check, i.e. the WHERE-clause includes

'A.pid=-1' .
' AND A.t3ver_wsid=' . $workspaceId .
' AND A.t3ver_oid=B.uid' .
BackendUtility::deleteClause($tableName, 'A') .
BackendUtility::deleteClause($tableName, 'B')

SELECT                                   
    B.uid as live_uid,                   
    B.pid as live_pid,                   
    A.uid as offline_uid                 
FROM                                     
    tt_content as A,                     
    tt_content as B
WHERE                                    
    A.pid = -1                           
    AND A.t3ver_wsid = ###WORKSPACE_ID###
    AND A.t3ver_oid = B.uid              
    AND A.deleted = 0                    
    AND B.deleted = 0                    

    A.t3ver_oid = B.uid
AND A.t3ver_state<>4
 OR A.t3ver_oid=B.t3ver_move_id
AND A.t3ver_state=4

I am therefore "+1"-ing the solution proposed in #66231 to be included into the core as a proper fix for this issue.

Best,
Grigori

¹ https://forge.typo3.org/projects/typo3cms-core/repository/revisions/master/entry/typo3/sysext/backend/Classes/Tree/View/AbstractTreeView.php#L930

² https://forge.typo3.org/projects/typo3cms-core/repository/revisions/master/entry/typo3/sysext/workspaces/Classes/ExtDirect/PagetreeCollectionsProcessor.php#L75

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/22528

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/22528

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/41425

We've tried this fix but it just breaks the website.

Need to go live at the end of this week so if anyone has any ideas on fixing this problem I'd be very grateful!

A new ticket has been opened detailing the problems we're having https://forge.typo3.org/issues/69068