Changing type to different childElements + discard changes looses content

[neos-bot]

Jira issue originally created by user @rolandschuetz:

To reproduce the problem:

1. Create a ThreeColumn content element
2. Add a content element to the third column, a simple text node is fine
3. Change the content type to TwoColumn

Now there a two issues:

• When you discard the changes, the text node is gone
• When you change the node to ThreeColumn the following error is thrown:

{quote}An exception occurred while executing 'INSERT INTO typo3_typo3cr_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 ["f2933aa9-a3ae-41f7-b093-666099487116", "209d745498deccfed8743fd93e2eca46", "\/sites\/hltravel\/main\/node-57af144a4a7b4\/column2", "707d070f65ecf813e5c7b16980e257c8", "\/sites\/hltravel\/main\/node-57af144a4a7b4", "ac581093-8462-466a-a252-06ba5c4854a9", 400, 0, "fb11fdde869d0a8fcfe00a2fd35c031d", "2016-08-13 14:37:30", null, null, null, "{\n \"language\": {\n \"0\": \"de\"\n }\n}", "{}", "TYPO3.Neos:ContentCollection", "2016-08-13 14:37:30", 0, 0, "{}", "user-rolandschuetz", null, null]:#23000: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '209d745498deccfed8743fd93e2eca46-user-rolandschuetz-fb11fdde869d' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'#23000: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '209d745498deccfed8743fd93e2eca46-user-rolandschuetz-fb11fdde869d' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '209d745498deccfed8743fd93e2eca46-user-rolandschuetz-fb11fdde869d' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01' Doctrine\DBAL\Exception\UniqueConstraintViolationException thrown in file
Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 66.

Nested Exception Doctrine\DBAL\Driver\PDOException thrown in file
Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php in line 93.

Nested Exception PDOException thrown in file
Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php in line 91{quote}

Jira-URL: https://jira.neos.io/browse/NEOS-1874

[neos-bot]

Comment created by @johannessteu:

Hey [~rolandschuetz],

thanks for reporting this! After changing the node the textNode is not really gone. It is still present in your database, but the path does no longer exist so you won't see the text node for now. But should still be fixed! At least that shouldn't run in some sql error

[mhsdesign]

@Sebobo i meant this issue, is this fixed?