Page wont publish, I suspect as it has SQL code snippets

[Chris Brown]

Hi

I am trying to publish a page on confluence which has SQL code snippets which contain EXEC etc in it. So I suspect it thinks I am trying to do a injection attack. Is that likely the issue, does anyone know a way to effectively modify the page so that the publish would be happy. Maybe decorate the code in some way so it is benign. Then I could just put a comment on like remove " " around the statements for developers etc. 

[Marc Koppelaar · Accepted solution]

Hi @Chris Brown 

I can't reproduce your problem on Confluence Cloud.

I have implemented a code snippet on a random page with content;

SELECT Count(*) AS DistinctCountries FROM (SELECT DISTINCT Country FROM Customers); --Executing stored procedure EXECUTE | EXEC <stored procedure name> WITH <execute_option> -- Execting string EXECUTE | EXEC ('sql string') WITH <execute_option> EXEC SelectAllCustomers;

The publish/update succeeds as normal.

Do you use the snippet in another macro from a 3rd party app or just use 3rd party apps, disable them and see if all works.

Then an app is the reason of the problem, if it stil occurs you wil need to contact Atlassian, as it might be an issue with your instance

[Chris Brown]

Thanks. I deleted the page and slowly added the content back in publishing after each stage. That seems to have worked. I had copied direct from Azure DevOps Wiki, this time I did it via word and that seems to have worked. 

Thanks for testing it.