How to remove "unknown macro" in confluence

[Siddheshwar mhetre]

I have upgrade confluence 3.x to 5.x

In earlier version(i.e. 3.x) I was using some macros, but in latest version (5.x) most of the macros are not compatible.

Currently in latest version it is showing following unknown macro error

bm1.jpg

So I want to remove these Unknown Macro from confluence 

I do not want to uninstall plugin/macro from my system, just need to remove this error from my page.

From database can we write any query?

or any plugin to remove the Unknown Macro?

[Nic Brough -Adaptavist-]

Once you've done what Lukas suggests in terms of working out which macro is broken, I usually cheat quite a lot and write a "user macro" with the same name, and accepting the same parameters

This will:

• Work automatically
• Allow you to use the "macroName: X" search to get pages where it is used so you can edit it out
• For a simple macro, echo out the body, parameters and a big red warning that the macro is broken and implore the users to edit the page to replace it with something better
• If you can reproduce the desired functionality in the user macro, you may not need to remove anything

I wouldn't try anything with SQL until the very last resort.  Try the user macro tricks first

[Mike Smith]

Hey Nic, great suggestion.  All I need to do now is to have the new macro output whatever is actually contained within it... can you offer a suggestion for that?

[Nic Brough -Adaptavist-]

What does the old macro do?

[Mike Smith]

We’ve uninstalled theme press, and I am trying to not have to edit all of the pages where their macros were used.  Those macros are:

Content Layer

|à Content Column

|----àContent Block

They aren’t doing anything at all, but are just there.  The content within these macro blocks is normal Confluence content. The content is visible and renders correctly when editing the page, but not when simply viewing it. 

[Mike Smith]

I should add that we are license holders of Theme Press.

[Nic Brough -Adaptavist-]

That makes sense.  I suspect you can define a replacement "user macro" called "content layer" that simple passes $body through without any parameters.  That will at least make the page viewable.

[Lukas Knoch -Rumpelcoders-]

If you find out wich macro is causing the error by looking at the editor, you can remove all the macro(s) with this plugin: 

Search and Replace

[Siddheshwar mhetre]

Thanks Lukas, Is it working for Unknown Macro? I have tried this for used macro, it is working fine. But unknown macro it is not showing any occurrence.

[Lukas Knoch -Rumpelcoders-]

Usually it is a macro that causes the 'unknown macro' text to appear on the page. When you edit the page, what is shown in the wysiwyg at the place of the "unkown macro " error ?

[Siddheshwar mhetre]

on edit page it is showing like {xyz}some text {xyz} After save the page it is showing Unknown Macro : xyz

[Nic Brough -Adaptavist-]

Your xyz is the name of the macro. The search and replace trick Lukas suggests will work, but you'll need to replace it with something that preserves your data.

[Siddheshwar mhetre]

Yes Nic, I want replace these unknown macro with blank space.

[Lukas Knoch -Rumpelcoders-]

if the macro is wrapped in a wiki-markup block, the suggested opition won't work, I'm sorry. Your only option with search and replace would be to replace all wiki-markup macros, wich would also remove other wiki-markup macros with working content.

[Siddheshwar mhetre]

ok thanks