| :","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"short-text","parameters":{"id":"dmsk8ag1a0","extensionKey":"short-text","name":"content:space","placeholder":"","isRequired":false,"type":"line","atlassian-macro-output-type":"INLINE"}}}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Question:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"short-text","parameters":{"id":"s0uuddasnc","extensionKey":"short-text","name":"page:title","placeholder":"","isRequired":false,"type":"line","atlassian-macro-output-type":"INLINE"}}}]}]}]},{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"paragraph","content":[{"text":"Answer:","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1},"content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"paragraph","parameters":{"id":"o088j6iumi","extensionKey":"paragraph","name":"kbAnswer","isRequired":false,"Type":"area","atlassian-macro-output-type":"BLOCK"},"layout":"default"}}]}]}]}]} | | fieldGroupName | migrated |
|---|
| fieldGroupId | 6bzqkqrf7e |
|---|
| excerpt | Add-on: Linking for Confluence Server Question: Removing duplicated entries from database Answer: On older versions of Linking, Linking creates duplicated entries on the LINKS table. This issue has been rectified on Linking 3.0.12. However, older duplicated entries will still remain on the database. Therefore, you'll need to manually remove the duplicated entries from the database. Here's an example query which you can use to remove the duplicated entries: DROP TEMPORARY TABLE IF EXISTS link_min_ids; CREATE TEMPORARY TABLE link_ids_to_delete (INDEX(linkid)) ( SELECT Linkid from LINKS t1 where exists( select 'x' from LINKS t2 where t2.CONTENTID = t1.CONTENTID and t2.DESTPAGETITLE = t1.DESTPAGETITLE and t2.DESTSPACEKEY = t1.DESTSPACEKEY and t2.LINKID < t1.LINKID ) ); DELETE l from link_ids_to_delete lm, links l WHERE l.linkid = lm.linkid; |
|---|
| propertyKeys | ["net.customware.confluence.plugin.scaffolding__6bzqkqrf7e__data_0_j5c2bnsdn6"] |
|---|
|