SQL LAB- Unexpected error

[zeedevio]

Bug description

I have an error on everything related to queries. I'm unable to open query editor.

Error is located in new query editor Action for line

    const dbIds = Object.values(databases).map(database => database.id);

Screenshots/recordings

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
• [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
• [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot[bot]]

I found a similar closed issue that might be relevant to the error you're encountering: SQL LAB - unexpected error. The suggested solution for this issue was to run the following commands after restarting the service:

export FLASK_APP=superset
superset db upgrade
superset init

This solution was confirmed to completely fix the issue ^[1].

Additionally, the "TypeError: Cannot convert undefined or null to object" error you're seeing in sqlLab.js might be related to how objects are being handled in the code. This type of error typically occurs when trying to access or manipulate properties of an undefined or null object. You might want to check the code around line 558 in sqlLab.js to ensure that all objects are properly initialized before use.

If the error persists, consider reviewing the logic that constructs objects using spread syntax, as shown in your code snippet, to ensure that all necessary properties are defined and available.

To continue talking to Dosu, mention @dosu.