Flow site:import leads to an error

kurztipp · October 17, 2016, 6:25pm

Hi,

I tried to transfer a project from one machine to another. As sugested in What is the best method for transferring a local Neos project to an online server? I executed ./flow site:export --package-key TH.Blog which completed without an error.
When I try to import the project on the other machine (freshly installed neos) importing fails:

./flow site:import --package-key=TH.Blog
Error: During the import of the "Sites.xml" from the package "TH.Blog" an exception occurred: Error: During import an exception occurred:
"An exception occurred while executing
'INSERT INTO typo3_typo3cr_domain_model_nodedata (
    Persistence_Object_Identifier,
    identifier,
    nodeType,
    workspace,
    sortingIndex,
    version,
    removed,
    hidden,
    hiddenInIndex,
    path,
    pathHash,
    parentPath,
    parentPathHash,
    dimensionsHash,
    dimensionValues,
    properties,
    creationDateTime,
    lastModificationDateTime,
    accessRoles
)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
with params [
    "f1f8c1c9-5a1c-4fa0-804f-9185df1f6440",
    "166366b0-97f3-448c-b523-5746222ab719",
    "TYPO3.Neos.NodeTypes:Page",
    "live",
    "100",
    "1",
    false,
    false,
    false,
    "\/sites\/blog",
    "24a5582558345283318d4b26b04f8b37",
    "\/sites",
    "dbd87ae51cbf5240fea77283585e69d5",
    "4f534b1eb0c1a785da31e681fb5e91ff",
    "{\n    \"language\": {\n        \"0\": \"en_US\"\n    }\n}", "{\n    \"title\": \"Home\",\n    \"uriPathSegment\": \"home\"\n}",
    "2016-07-22 21:53:18", "2016-07-22 21:53:18", "{}"
]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24a5582558345283318d4b26b04f8b37-live-4f534b1eb0c1a785da31e681fb' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'".
see log for further information.

Error Log:

Exception #1300360480: Error: During import an exception occurred: "An exception occurred while executing 'INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["83e5b262-53f4-4ea0-86c0-6956a1dcb25a", "166366b0-97f3-448c-b523-5746222ab719", "TYPO3.Neos.NodeTypes:Page", "live", "100", "1", false, false, false, "\/sites\/blog", "24a5582558345283318d4b26b04f8b37", "\/sites", "dbd87ae51cbf5240fea77283585e69d5", "4f534b1eb0c1a785da31e681fb5e91ff", "{\n    \"language\": {\n        \"0\": \"en_US\"\n    }\n}", "{\n    \"title\": \"Home\",\n    \"uriPathSegment\": \"home\"\n}", "2016-07-22 21:53:18", "2016-07-22 21:53:18", "{}"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24a5582558345283318d4b26b04f8b37-live-4f534b1eb0c1a785da31e681fb' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'".

23 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromPackage("TH.Blog")
22 call_user_func_array(array|2|, array|1|)
21 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("importFromPackage", array|1|)
20 TYPO3\Neos\Command\SiteCommandController_Original::importCommand("TH.Blog", NULL)
19 call_user_func_array(array|2|, array|2|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/var/www/html/stammprojekte/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Previous exception: Exception in line 128 of /var/www/html/stammprojekte/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: An exception occurred while executing 'INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["83e5b262-53f4-4ea0-86c0-6956a1dcb25a", "166366b0-97f3-448c-b523-5746222ab719", "TYPO3.Neos.NodeTypes:Page", "live", "100", "1", false, false, false, "\/sites\/blog", "24a5582558345283318d4b26b04f8b37", "\/sites", "dbd87ae51cbf5240fea77283585e69d5", "4f534b1eb0c1a785da31e681fb5e91ff", "{\n    \"language\": {\n        \"0\": \"en_US\"\n    }\n}", "{\n    \"title\": \"Home\",\n    \"uriPathSegment\": \"home\"\n}", "2016-07-22 21:53:18", "2016-07-22 21:53:18", "{}"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24a5582558345283318d4b26b04f8b37-live-4f534b1eb0c1a785da31e681fb' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

37 Doctrine\DBAL\Driver\AbstractMySQLDriver::convertException("An exception occurred while executing 'INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["83e5b262-53f4-4ea0-86c0-6956a1dcb25a", "166366b0-97f3-448c-b523-5746222ab719", "TYPO3.Neos.NodeTypes:Page", "live", "100", "1", false, false, false, "\/sites\/blog", "24a5582558345283318d4b26b04f8b37", "\/sites", "dbd87ae51cbf5240fea77283585e69d5", "4f534b1eb0c1a785da31e681fb5e91ff", "{\n    \"language\": {\n        \"0\": \"en_US\"\n    }\n}", "{\n    \"title\": \"Home\",\n    \"uriPathSegment\": \"home\"\n}", "2016-07-22 21:53:18", "2016-07-22 21:53:18", "{}"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24a5582558345283318d4b26b04f8b37-live-4f534b1eb0c1a785da31e681fb' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'", Doctrine\DBAL\Driver\PDOException)
36 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver, Doctrine\DBAL\Driver\PDOException, "INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", array|19|)
35 Doctrine\DBAL\Connection::executeUpdate("INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", array|19|, array|19|)
34 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::persistNodeData(array|19|)
33 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::parseEndElement(XMLReader)
32 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::importSubtree(XMLReader)
31 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::TYPO3\TYPO3CR\Domain\Service\ImportExport\{closure}()
30 Closure::__invoke()
29 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
28 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
27 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::import(XMLReader, "/sites", "resource://TH.Blog/Private/Content/Resources")
26 call_user_func_array(array|2|, array|3|)
25 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("import", array|3|)
24 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromFile("resource://TH.Blog/Private/Content/Sites.xml")
23 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromPackage("TH.Blog")
22 call_user_func_array(array|2|, array|1|)
21 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("importFromPackage", array|1|)
20 TYPO3\Neos\Command\SiteCommandController_Original::importCommand("TH.Blog", NULL)
19 call_user_func_array(array|2|, array|2|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/var/www/html/stammprojekte/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Previous exception: Exception #23000 in line 987 of /var/www/html/stammprojekte/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Connection.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24a5582558345283318d4b26b04f8b37-live-4f534b1eb0c1a785da31e681fb' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

36 Doctrine\DBAL\Driver\PDOStatement::execute()
35 Doctrine\DBAL\Connection::executeUpdate("INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", array|19|, array|19|)
34 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::persistNodeData(array|19|)
33 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::parseEndElement(XMLReader)
32 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::importSubtree(XMLReader)
31 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::TYPO3\TYPO3CR\Domain\Service\ImportExport\{closure}()
30 Closure::__invoke()
29 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
28 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
27 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::import(XMLReader, "/sites", "resource://TH.Blog/Private/Content/Resources")
26 call_user_func_array(array|2|, array|3|)
25 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("import", array|3|)
24 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromFile("resource://TH.Blog/Private/Content/Sites.xml")
23 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromPackage("TH.Blog")
22 call_user_func_array(array|2|, array|1|)
21 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("importFromPackage", array|1|)
20 TYPO3\Neos\Command\SiteCommandController_Original::importCommand("TH.Blog", NULL)
19 call_user_func_array(array|2|, array|2|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/var/www/html/stammprojekte/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Previous exception: Exception #23000 in line 91 of /var/www/html/stammprojekte/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '24a5582558345283318d4b26b04f8b37-live-4f534b1eb0c1a785da31e681fb' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

37 PDOStatement::execute(NULL)
36 Doctrine\DBAL\Driver\PDOStatement::execute()
35 Doctrine\DBAL\Connection::executeUpdate("INSERT INTO typo3_typo3cr_domain_model_nodedata (Persistence_Object_Identifier, identifier, nodeType, workspace, sortingIndex, version, removed, hidden, hiddenInIndex, path, pathHash, parentPath, parentPathHash, dimensionsHash, dimensionValues, properties, creationDateTime, lastModificationDateTime, accessRoles) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", array|19|, array|19|)
34 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::persistNodeData(array|19|)
33 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::parseEndElement(XMLReader)
32 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::importSubtree(XMLReader)
31 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::TYPO3\TYPO3CR\Domain\Service\ImportExport\{closure}()
30 Closure::__invoke()
29 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
28 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
27 TYPO3\TYPO3CR\Domain\Service\ImportExport\NodeImportService_Original::import(XMLReader, "/sites", "resource://TH.Blog/Private/Content/Resources")
26 call_user_func_array(array|2|, array|3|)
25 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("import", array|3|)
24 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromFile("resource://TH.Blog/Private/Content/Sites.xml")
23 TYPO3\Neos\Domain\Service\SiteImportService_Original::importFromPackage("TH.Blog")
22 call_user_func_array(array|2|, array|1|)
21 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("importFromPackage", array|1|)
20 TYPO3\Neos\Command\SiteCommandController_Original::importCommand("TH.Blog", NULL)
19 call_user_func_array(array|2|, array|2|)
18 TYPO3\Flow\Cli\CommandController_Original::callCommandMethod()
17 TYPO3\Flow\Cli\CommandController_Original::processRequest(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
16 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
15 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Cli\Request, TYPO3\Flow\Cli\Response)
14 TYPO3\Flow\Cli\CommandRequestHandler::TYPO3\Flow\Cli\{closure}()
13 Closure::__invoke()
12 TYPO3\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
11 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
10 call_user_func_array(array|2|, array|1|)
9 TYPO3\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(TYPO3\Flow\Aop\JoinPoint)
8 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
7 TYPO3\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(TYPO3\Flow\Aop\JoinPoint)
6 TYPO3\Flow\Aop\Advice\AroundAdvice::invoke(TYPO3\Flow\Aop\JoinPoint)
5 TYPO3\Flow\Aop\Advice\AdviceChain::proceed(TYPO3\Flow\Aop\JoinPoint)
4 TYPO3\Flow\Security\Context::withoutAuthorizationChecks(Closure)
3 TYPO3\Flow\Cli\CommandRequestHandler::handleRequest()
2 TYPO3\Flow\Core\Bootstrap::run()
1 require("/var/www/html/stammprojekte/Packages/Framework/TYPO3.Flow/Scripts/flow.php")

Why does this error occur and how can I fix it?

Regards

bwaidelich · October 18, 2016, 8:33am

Hi,

I can’t explain how exactly it came to that situation but the error complains about a unique key constraint violation:
There can ever be only one node in the Content Repository with the same path, workspace & dimensions.
For some reason the import tries to add the /sites/blog page node (identifier: 166366b0-97f3-448c-b523-5746222ab719) but there is already a node at that path with the same workspace (live) and the same dimensions (language: en_US) but with a different identifier.

If your Content Repository already contained nodes when you started the import probably the identifiers did not match (otherwise Neos will just update the existing node).
If you import into an empty Database your Sites.xml probably contain two nodes for that path with different identifiers for some reason.

kurztipp · October 18, 2016, 5:58pm

Hi,

thanks for the answer but how can I solve this problem. As I said: I tried to transfer the project to a completely fresh installation of neos.

Regards

bwaidelich · October 19, 2016, 1:59pm

As said:

If you import into an empty Database your Sites.xml probably contain two nodes for that path with different identifiers for some reason.

I can’t imagine how that could happen. But can you confirm that? If so, remove one of the duplicates from the XML

kurztipp · October 19, 2016, 3:55pm

Hi,

I solved the problem by deleting every table row that the Neos setup created in typo3_typo3cr_domain_model_nodedata. After that I tried to import the project again and it worked.

After that I read your post and checked the XML. There are no duplicates (maybe they’re gone because the import worked?).
I copied every identifier from the XML into a text file and ran sort identifier | uniq -cd which printed nothing. So, there are no duplicates in the XML. I compared the identifiers with the ones stored in the MySQL table (copied before deleting them) typo3_typo3cr_domain_model_nodedata but even that gave no results…
I don’t know what the problem was, but it seems to be solved so far.

christianm · October 19, 2016, 4:00pm

That means you didn’t have an empty database, but oyu imported a site in the setup. that probably explains the problem.

Did you copy your site from the demo site?

kurztipp · October 19, 2016, 4:09pm

Hi,

I didn’t let the setup create the demo site package on both Neos installations. I let, however, the setup create the empty site package “TH.Blog” on the new Neos installation. I thought this is necessary to import the data.

christianm · October 19, 2016, 4:10pm

No, not really. And it imports stuff already as you noticed.
But good to know what caused it.

bwaidelich · October 20, 2016, 10:53am

As the setup won’t create any nodes unless you import a site, my first comment probably applied:

If your Content Repository already contained nodes when you started the import probably the identifiers did not match (otherwise Neos will just update the existing node).