Had to dig a bit deeper to figure out why it’s not working. Basically it’s a bug in the core related to a missing content dimension record in the database.
Try inserting this record:
INSERT INTO `typo3_typo3cr_domain_model_nodedimension` (`persistence_object_identifier`, `nodedata`, `name`, `value`)
VALUES
('977bccbf-e1dc-85ef-9288-42819cde797f', '179d62e4-7e65-6283-177b-b3401db585c0', 'language', 'en_US');
Here’s an example of the query it does to find the /sites node:
SELECT t0_.persistence_object_identifier AS persistence_object_identifier0, t0_.version AS version1, t0_.pathhash AS pathhash2, t0_.path AS path3, t0_.parentpathhash AS parentpathhash4, t0_.parentpath AS parentpath5, t0_.identifier AS identifier6, t0_.sortingindex AS sortingindex7, t0_.removed AS removed8, t0_.dimensionshash AS dimensionshash9, t0_.lastmodificationdatetime AS lastmodificationdatetime10, t0_.lastpublicationdatetime AS lastpublicationdatetime11, t0_.hiddenbeforedatetime AS hiddenbeforedatetime12, t0_.hiddenafterdatetime AS hiddenafterdatetime13, t0_.dimensionvalues AS dimensionvalues14, t0_.properties AS properties15, t0_.nodetype AS nodetype16, t0_.creationdatetime AS creationdatetime17, t0_.hidden AS hidden18, t0_.hiddeninindex AS hiddeninindex19, t0_.accessroles AS accessroles20, t0_.workspace AS workspace21, t0_.contentobjectproxy AS contentobjectproxy22, t0_.movedto AS movedto23 FROM typo3_typo3cr_domain_model_nodedata t0_ WHERE t0_.workspace IN ('live') AND (t0_.persistence_object_identifier IN (SELECT t1_.nodedata AS sclr24 FROM typo3_typo3cr_domain_model_nodedimension t1_ WHERE t1_.name = 'language' AND t1_.value IN ('en_US'))) AND t0_.pathhash = 'dbd87ae51cbf5240fea77283585e69d5'