Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

confluence 7.13.1 : Duplicate Attachment Errors:

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

 

 

1 answer

1 accepted

2 votes
Answer accepted
Dominic Lagger Community Leader Oct 13, 2021

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,631 views 7 30
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you