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,
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:
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...
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