Execution of Velocity Macros Not Allowed

For every user including superadmin, every macro has been replaced by the error message, “Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed. Check the rights of its last author or the parameters if it’s rendered from another script.]. Click on this message for details.” It’s possible that I made a mistake while making some permission changes recently, though those changes were intended to give one user more permissions, not take anybody’s, much less everybody’s, permissions away. Without any macros I don’t know how to correct or reset the permissions. Is there a way for me to correct the permissions directly in the database, or any other way to recover from this issue?

I ended up fixing this with the following two SQL statements on the database. It erases all information on who actually owned the various pages, but that was acceptable for me.

update xwikidoc
set xwd_author = ‘XWiki.superadmin’
,xwd_content_author = ‘XWiki.superadmin’
,xwd_creator = ‘XWiki.superadmin’;

update xwikircs
set xwr_author = ‘XWiki.superadmin’

1 Like

This was helpful in getting control of my own wiki back.