I fixed it. I noticed that the the database only had one organization but my user id was a member of organization 2.
This fixed it.
update grafana.user set org_id = 1 where id = 1
Maybe we can add an error check that verifies that there is a group before changing it or not allowing someone to delete a group if there is a member in it. I don’t know how it happened.
When you create a new organization you’ll automatically switch to that new organization. I guess that’s why you thought that all your dashboards was gone.
I saved the json file but I got a permission error while trying to upload it.
No idea what you mean here - did you try to import a dashboard?
A user is only active in one organization at a time. When you navigate to your profile you can switch between active organization. See http api documentation for more information.
I have had this happen now as well. However I cannot seem to connect to the database with any tools as I normally would. I also tried SQLite command line and it tells me its not installed. I just a default install. Is there any command line i can use to do the above?