Page Properties Macro is not showing in the Macro Browser
Users can't find the Page Properties macro in the Macro Browser. They also can comment about that the Page Properties macro change its name to Metadata.
If you check the logs you won't find any error related to it.
A third party plugin named as Metadata Plugin is the root cause of it.
Removing the Metadata plugin directly from the database
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Check if the the Metadata plugin is installed.
select * from plugindata where pluginkey like '%andya.confluence.plugins.metadata%'
- Stop Confluence.
If it returns any value, execute the following query:
remove from plugindata where pluginkey like '%andya.confluence.plugins.metadata%'
- Start Confluence.