confluence 7.13.1 : Duplicate Attachment Errors:

[Ndofunsu]

Hi,

After upgrading from confluence 7.13.1 server to confluece 7.13.1 server,  we have duplicate pages and see this error occurs in log file:

ERROR Getting Duplicate Attachment Errors: "findSingleObject Uh oh - found more than one object when single object requested" in the Logs

and from postgresql database associated to confluence this request returns 0 line :

SELECT * FROM CONTENT WHERE TITLE = '<DUPLICATED ATTACHMENT TITLE>';

Any help is welcome,

Best regards

Roger Ndofunsu

[Dominic Lagger · Accepted solution]

Hi @Ndofunsu 

We do have the same errors and we also delete the content via DB.

You have to replace the "<DUPLICATED ATTACHMENT TITLE>" with the title of the duplicated attachment.

Let's say, in one of your pages the attachment "hello.jpg" is duplicated. 

Then find out which contentid this attachment has:

SELECT * FROM CONTENT WHERE TITLE = 'hello.jpg';

Then you have to delete one contentid with these statements

DELETE FROM IMAGEDETAILS where ATTACHMENTID = <CONTENT_ID>;
DELETE FROM CONTENTPROPERTIES WHERE CONTENTID = <CONTENT_ID>;
DELETE FROM CONTENT WHERE CONTENTID = <CONTENT_ID>;

 Please have a look: 

Getting Duplicate Attachment Errors: "findSingleObject Uh oh - found more than one object when single object requested" in the Logs 

Regards, Dominic