I’ve been having this problem for a while. That my content disappears in ContentCollector and an error message appears in its place.
When I execute ./flow node:repair, the message
Found orphan node named "main" (Neos.Neos:ContentCollection) in "/sites/site/node-v9qqrl5yhbypy/node-sbbctcdqjkhlx/node-ixhusmyusb5al/main"
`Found orphan node named "sidebar" (Neos.Neos:ContentCollection) in "/sites/site/node-v9qqrl5yhbypy/node-sbbctcdqjkhlx/node-ixhusmyusb5al/sidebar"
If I deny this, come later:
❱ Add node c0405e12-c7a7-88ac-8230-04e7da9c6302 named "main" in "/sites/site/node-> v9qqrl5yhbypy/node-sbbctcdqjkhlx/node-qbpf0o0c1zyz2"
applied ✔
Created 1 new child nodes
An exception occurred while executing 'INSERT INTO neos_contentrepository_domain_model_nodedata (persistence_object_identifier, pathhash, path, parentpathhash, parentpath, identifier, sortingindex, removed, dimensionshash, lastmodificationdatetime, lastpublicationdatetime, hiddenbeforedatetime, hiddenafterdatetime, dimensionvalues, properties, nodetype, creationdatetime, hidden, hiddeninindex, accessroles, workspace, contentobjectproxy, movedto) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["d1517218-0673-4bc6-b4b3-9ef62a540963", "1497732105f63b4d5105c322bc0450b3", "\/sites\/site\/node-v9qqrl5yhbypy\/node-sbbctcdqjkhlx\/node-qbpf0o0c1zyz2\/main", "3cef46ef50d6b91da7cd7638fb654f63", "\/sites\/site\/node-v9qqrl5yhbypy\/node-sbbctcdqjkhlx\/node-qbpf0o0c1zyz2", "c0405e12-c7a7-88ac-8230-04e7da9c6302", 300, 0, "fb11fdde869d0a8fcfe00a2fd35c031d", "2020-02-28 10:09:18", null, null, null, "{\n \"language\": {\n \"0\": \"de\"\n }\n}", "{}", "Neos.Neos:ContentCollection", "2020-02-28 10:09:18", 0, 0, "{}", "live", null, null]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'1497732105f63b4d5105c322bc0450b3-live-fb11fdde869d0a8fcfe00a2fd3' for
key 'UNIQ_CE6515692DBEC7578D94001992F8FB01'
Type: Doctrine\DBAL\Exception\UniqueConstraintViolationException
File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriv
er.php
Line: 55
Nested exception:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1497732105f63b4d5105c322bc0450b3-live-fb11fdde869d0a8fcfe00a2fd3' for key 'UNIQ_CE6515692DBEC7578D94001992F8FB01'
Type: Doctrine\DBAL\Driver\PDOException
Code: 23000
File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
Line: 123
Nested exception:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1497732105f63b4d5105c322bc0450b3-live-fb11fdde869d0a8fcfe00a2fd3' for key 'UNIQ_CE6515692DBEC7578D94001992F8FB01'
Type: PDOException
Code: 23000
File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
Line: 121
How can it be that if there is a change in the aftermath, the whole block is gone? I’ve got nothing in the logs either, except:
Exception #1389352984: No content collection of type Neos.Neos:ContentCollection could be found in the current node (/sites/site/node-v9qqrl5yhbypy/node-sbbctcdqjkhlx/node-qbpf0o0c1zyz2) or at the path "main". You might want to adjust your node type configuration and create the missing child node through the "flow node:repair --node-type Foo.Bar:Article" command.