nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Code Block with SQL Insert Into statement breaking page

David Liljeblad

Recently, my team found that our SQL coding standards page cannot be edited; it just spins and displays a popup with the following error

The editor didn't load this time
The connection timed out. If it happens again, speak to your Confluence admin. You may be using a proxy server that prevents WebSocket connections.

After investigations into the content of the page, I found out that it was because of code block macros that had "INSERT INTO table" on the same line. I was able to replicate it in many ways, even just putting "INSERT INTO [something]" in the title of the confluence page.

However, if I separated "INSERT INTO" and "table" in different lines, the page was able to be edited just fine.

All other pages work fine for editing & collaborative editing.

Has anyone encountered this error before?

Accepted answers

Diego_88dj6o

Hello there! Thanks for contacting the Community David.

I have tried to replicate this behaviour with Confluence 6.12.2 but was unable to. The macro Syntax Highlighting was set to SQL. I have used a generic INSERT INTO example from W3Schools.

With this in mind, could you provide us with some clarification:

Has this worked at some point in the past?

What syntax highlight is used in the macro?

Does this happen with any SQL query in a Code Block macro?

Is this issue present regardless of browser?

Are more users affected by this?

Are you using the built-in Code Block macro or third-party?

Also, would it be possible for you to send us the SQL Query that triggers this error? If possible, could you also send us screenshots of the settings for the Code Block Macro?

Be aware that anyone can see content in Community. With this in mind, be careful not to disclose any sensitive information with both screenshots and SQL Query!

Let us know your answer David, looking forward to solving this.

All comments

Diego_88dj6o

Hello there! Thanks for contacting the Community David.

I have tried to replicate this behaviour with Confluence 6.12.2 but was unable to. The macro Syntax Highlighting was set to SQL. I have used a generic INSERT INTO example from W3Schools.

With this in mind, could you provide us with some clarification:

Has this worked at some point in the past?

What syntax highlight is used in the macro?

Does this happen with any SQL query in a Code Block macro?

Is this issue present regardless of browser?

Are more users affected by this?

Are you using the built-in Code Block macro or third-party?

Also, would it be possible for you to send us the SQL Query that triggers this error? If possible, could you also send us screenshots of the settings for the Code Block Macro?

Be aware that anyone can see content in Community. With this in mind, be careful not to disclose any sensitive information with both screenshots and SQL Query!

Let us know your answer David, looking forward to solving this.

David Liljeblad

Yes, this was working before we upgraded to 6.14.1 server based Confluence from 6.5.1.
SQL, but it doesn't matter which one I have selected.
It is specific to having "INSERT INTO ______" any where on the page, broke the page when I had that in the title as well
Issue happens in IE & Chrome
Yes, it was reported to me by other employees in my computer.
Built-in

Even just "INSERT INTO SOMETHING" breaks the page, doesn't matter if I have more content in the page than that.

The settings for the Code Block Administration is Default theme = Confluence and Default Language = C#.

I have noticed that I cannot edit the Code block with "INSERT INTO _______" until after I remove it or put a line break after INTO.

David Liljeblad

Just did some additional tests:

These break the editor after the initial creation:

2019-03-11 17_09_16-Test Insert Into Something.png 2019-03-11 17_09_35-Testing Insert Into something title.png 2019-03-11 17_09_46-Testing something body.png 2019-03-11 17_09_58-Testing something code block.png

David Liljeblad

It didn't let me post all the images at once, so broke it down to what worked too.

These don't break the editor after the initial creation (I kept it simple to just the body content since it now doesn't seem like a code block macro specific issue):

2019-03-11 17_10_27-Testing Line break 1-1-1.png 2019-03-11 17_10_41-Testing Line breaks 1-2.png 2019-03-11 17_12_36-Testing Line breaks 2-1.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

sql

macro

code-block