When I open pgAdmin4 v4 on Windows 10, the dashboard displays
An error occured whilst rendering the graph
on all charts. The link (1) told me that the logs on windows are at
Windows log location: C:\Users\YOUR_USERNAME\AppData\Roaming\pgAdmin\pgadmin4.log
The logs contained numerous times the same error
2019-05-10 10:01:32,139: ERROR flask.app: string indices must be integers Traceback (most recent call last): File "C:/Program Files (x86)/pgAdmin 4/v4/venv/Lib/site-packages\flask\app.py", line 1813, in full_dispatch_request rv = self.dispatch_request() File "C:/Program Files (x86)/pgAdmin 4/v4/venv/Lib/site-packages\flask\app.py", line 1799, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "C:/Program Files (x86)/pgAdmin 4/v4/venv/Lib/site-packages\flask_login\utils.py", line 261, in decorated_view return func(*args, **kwargs) File "C:\Program Files (x86)\pgAdmin 4\v4\web\pgadmin\dashboard\__init__.py", line 251, in wrap return f(*args, **kwargs) File "C:\Program Files (x86)\pgAdmin 4\v4\web\pgadmin\dashboard\__init__.py", line 371, in dashboard_stats for chart_row in res['rows']: TypeError: string indices must be integers
I can also not open any databases(pressing the databases button doesn't unfold the list of databases) via pgAdmin4 v4.
Since I was working with the permissions of my users on certain databases, this has probably to do with it. The commands I recall running are
REVOKE ALL ON DATABASE Database_Name FROM Database_User; REVOKE ALL ON DATABASE Database_Name FROM PUBLIC;
To verify that I did not completly corrupt my databases and the error is just weird I logged in with the admin user via psql. Running
\l did not show anything was off.
What Should I do to fix this?
-- edit --
DataGrip doesn't seem to have the problem either.