Bug #69068


Workspace not opening page tree

Added by Rhodri Jones almost 9 years ago. Updated over 5 years ago.

Should have
Target version:
Start date:
Due date:
% Done:


Estimated time:
TYPO3 Version:
PHP Version:
Is Regression:
Sprint Focus:


Hi everyone,

We're currently upgrading our Typo3 site from 4.6.18 to 6.2.14, the upgrade has been successful. We've upgraded extensions and managed to get the site working and up and running. However, when changing Workspaces to our draft workspace of the site, the page tree fails to load.

Our issue is identical to the problem in the following ticket, (, and we've attempted the patch fixes suggested, but this only caused major PHP errors which broke the entire site. I'll reproduce the PHP errors and add them to the ticket.

We're running this on a 64 bit RHEL6 Virtual Machine, with version 5.5.27 of PHP.

Anyone have any more ideas of what we could try?

Thanks all in advance.

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Task #69439: Enhance SQL query reduction in page tree in workspacesClosedOliver Hader2015-08-31

Actions #1

Updated by Oliver Hader over 8 years ago

  • Status changed from New to Needs Feedback

Can you please provide the PHP errors that occur on your side?
Concerning performance there's a follow-up in,n,z - the change-set that got merged in July 2015 unfortunately has been lying around for two years then...

Actions #2

Updated by Michael Voehringer over 8 years ago

Hi Rhodri,
we have the same error after updating from 4.2 to 6.2. Looks like an SQL query takes very very long.

SELECT B.uid as live_uid, as live_pid, A.uid as offline_uid 
FROM tt_content A,tt_content B 
AND A.t3ver_wsid=2 
AND A.t3ver_state<>4 
OR A.t3ver_oid=B.t3ver_move_id 
AND A.t3ver_state=4) 
AND A.deleted=0 
AND B.deleted=0 
GROUP BY live_pid

We have fixed it by adding some extra indexes to the tt_content table:

ALTER TABLE `tt_content`
 ADD INDEX `pid` (`pid`),
 ADD INDEX `t3ver_wsid` (`t3ver_wsid`),
 ADD INDEX `t3ver_state` (`t3ver_state`),
 ADD INDEX `t3ver_move_id` (`t3ver_move_id`)
Actions #3

Updated by Oliver Hader over 8 years ago

Give the patch in #69439 a try...

Actions #4

Updated by Benni Mack about 8 years ago

  • Status changed from Needs Feedback to Resolved

Fixed in master

Actions #5

Updated by Anonymous almost 6 years ago

Can anybody say in which versions of TYPO3 this is fixed? Have the problem still in 7.6.29.

Actions #6

Updated by Benni Mack almost 6 years ago

  • Status changed from Resolved to Closed
Actions #7

Updated by Philipp Kitzberger over 5 years ago

Thanks for the hint with the SQL indicies. Didn't make any difference though. So I've tried it with a combined index which boosted performance of said query (with TYPO3 8.7) by factor 20.000 or so. Instead of 45s it's only 0,00025s now ;-)

I've wrapped it into a tiny extension:

Maybe someone stumbles over this issue here and needs a quick solution for this.

Cheers, Philipp


Also available in: Atom PDF