search

johannessteu / neos-development-collection

The unified repository containing the Neos core packages, used for Neos development.
GNU General Public License v3.0
0 stars 0 forks source link

Discard changes looses content #1024

Closed johannessteu closed 8 years ago

johannessteu commented 8 years ago

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:

{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

johannessteu commented 8 years ago

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