BookStack: Can't save SQL-Statements

Attempted Debugging

  • I have read the debugging page

Searched GitHub Issues

  • I have searched GitHub for the issue.

Describe the Scenario

Hey,

I have the following problem: When I try to save a SQL script, the error message “ERR_CONNECTION_RESET” comes up. In #1792 the problem was also described, but I could not find a solution there. On the demo website the problem does not occur. The problem occurs both in the Markdown editor and in the WYSIWYG editor.

Examples: Can’t be saved: , (SELECT count(*) FROM [BODA].[dbo].[WK_tabReRpZo_Zuordnung] WHERE [ReRpZo_Report] = 'TFKU286') But this can be saved: SELECT count(*)  FROM [BODA].[dbo].[WK_tabReRpZo_Zuordnung]  WHERE [ReRpZo_Report] = 'TFKU286'

Even this can’t be saved: SELECT (SELECT COUNT(*) FROM (SELECT

And even correct statements like this, can’t be saved: SELECT (SELECT COUNT(*) FROM (SELECT [ReRpBo_Block] FROM [BODA].[dbo].[WK_tabReRp_Report], [BODA].[dbo].[WK_tabReRpZo_Zuordnung], [BODA].[dbo].[WK_tabReRpBo_Block], [BODA].[dbo].[WK_tabReRpAw_Auswertung] WHERE [ReRp_Report] = 'TFKU286' AND [ReRp_Report] = [ReRpZo_Report] AND [ReRpZo_Block] = [ReRpBo_Block] AND [ReRpBo_Block] = [ReRpAw_Block] GROUP BY [ReRpBo_Block]) as bribra) as NumBlocksInTotal, (SELECT count(*) FROM [BODA].[dbo].[WK_tabReRpZo_Zuordnung] WHERE [ReRpZo_Report] = 'TFKU286') as NumBlocksInBlocks

Exact BookStack Version

22.09.1

Log Content

laravel.log

In the httpd (apache) log is no error message regarding this problem. If still needed or wanted I will provide it too.

PHP Version

PHP 8.0.24

Hosting Environment

RHEL 8

Linux mydomain.com 4.18.0-372.26.1.el8_6.x86_64 # 1 SMP Sat Aug 27 02:44:20 EDT 2022 x86_64 x86_64 x86_64 GNU/Linux

MySQL (MariaDB)

Version: mysql Ver 15.1 Distrib 10.3.35-MariaDB, for Linux (x86_64) using readline 5.1

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Comments: 20 (9 by maintainers)

Most upvoted comments

Thanks for the update. I’ll therefore close this off since there’s not much else I can advise without deeper knowledge of your environment. If you ever find a BookStack-based cause feel free to raise it with us but I’m fairly confident this is something environment specific.