Deleting pages Error

Whenever I try to delete a page I recieve the following error :

#1: Warning: trim() expects parameter 1 to be string, object given in /…/TYPO3_Flow_Mvc_Routing_RouterCachingService.php line 196

I’m not sure why this happening, ever happened to anyone?

I am not sure if this may have anything to do with it

An exception occurred while executing 'UPDATE typo3_typo3cr_domain_model_nodedata SET dimensionshash = ?, dimensionvalues = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ?
AND version = ?' with params ["04b58c26be3237383d4904dce856aa79", "{\n   
\"country\": {\n        \"0\": \"de\"\n    },\n    \"language\": {\n     
  \"0\": \"en\"\n    }\n}", "2016-09-23 00:45:19",
"0cfd0e1c-70e7-4dae-8345-ea3714db7e11", 2]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'f3c3ef0eb153ced13ca86ca196a82d2f-live-04b58c26be3237383d4904dce8' for
key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

  Type: Doctrine\DBAL\Exception\UniqueConstraintViolationException
  File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriv
        er.php
  Line: 66

Nested exception:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'f3c3ef0eb153ced13ca86ca196a82d2f-live-04b58c26be3237383d4904dce8' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

  Type: Doctrine\DBAL\Driver\PDOException
  Code: 23000
  File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
  Line: 93

Nested exception:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'f3c3ef0eb153ced13ca86ca196a82d2f-live-04b58c26be3237383d4904dce8' for key 'UNIQ_60A956B92DBEC7578D94001992F8FB01'

  Type: PDOException
  Code: 23000
  File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
  Line: 91

I found this on NEOS scrum board, I figure this related to the issue.

https://jira.neos.io/browse/NEOS-1861

In this case it should be fixed with the latest versions of Neos. What version do you use and did you try upgrading to the latest patch release?

I believe I am currently using version 2.2.5 based on the composer.json file and no I haven’t tried upgrading, where would I find instruction to go about doing that?

2.2.5 is exactly the problematic version. If you do a ‘composer update’ you should get a working version now. Current latest version of the 2.2 branch is 2.2.8

1 Like

so unless I didn’t upgrade properly, I am still experiencing the same issues, I cannot delete elements nor Pages. Where do I check the version of neos I am running? I even followed this just to be sure https://www.neos.io/download-and-extend/upgrade-instructions-2-1-2-2.html

There is a packages module in the admin section.

The error in Neos 2.2.4 prevented publishing of single deletions … so if your problem occurred directly on delete it is probably unrelated.

BTW: publish all worked also in Neos 2.2.4 as expected.