[Bug]: Reopening SQL Console Breaks the code editor

[10PoundGorilla-ChrisBehling]

Is there an existing issue for this?

• I have searched the existing issues

What happened?

When working in SQL Console, if you hit the escape key, the PersonaBar will close. Trying to open the SQL Console again, you will see that the queries you had written are gone, and there is an initilization error with the SQL code editor.

Video of issue: https://www.loom.com/share/c25e8fa39257434d87d6ad8f918b7731?sid=f6f2f77c-8c51-479b-9b94-0304d7ccb864

Steps to replicate:

• Open up the DNN SQL Editor
• Write your fancy SQL statement
• Click Execute Run Script
• Hit the Escape key on your keyboard
• Click to re-open the SQL Console dialog
• See that the editor fails to initialize correctly

Steps to reproduce?

1. Open up the DNN SQL Editor
2. Write your fancy SQL statement
3. Click Execute Run Script
4. Hit the Escape key on your keyboard
5. Click to re-open the SQL Console dialog
6. See that the editor fails to initialize correctly

Current Behavior

When re-opening SQL Console, you will see an initialization error, and you have to completely reload the page to resolve the issue.

Expected Behavior

1. Clicking to reload the SQL Console should load the editor for you, so you can write and execute SQL scripts.
2. Ideally if you closed the panel, you could reload the queries you had pulled up. This behavior already exists. For example, go to Pages, and select a page you are not currently on, change to the Users view, and then go back to Pages, you will see that page pre-loads for you on your return trip.

Relevant log output

No response

Anything else?

No response

Affected Versions

9.13.5 (latest release)

What browsers are you seeing the problem on?

Firefox, Chrome, Safari, Microsoft Edge

Code of Conduct

• I agree to follow this project's Code of Conduct