Bug Report: pgAdmin 6.12 doesn't show contents of information_schema and pg_catalog
Hello! I noticed that with pgAdmin 6.12, the contents of information_schema and pg_catalog in the Browser cannot be displayed. Clicking on the arrows to unfold these schemas, flips the arrow downwards, but yields no results. I downgraded to 6.11 and it still works with that version. Kind regards, Nicolas Dechamps Nicolas Dechamps IT Service decha...@intend.de INTEND Geoinformatik GmbH Johanna-Waescher-Stra?e 5 D - 34131 Kassel Tel +49 (0561) 316 799 0 Fax +49 (0561) 316 799 7 Web http://www.intend.de INTEND Geoinformatik GmbH Amtsgericht Kassel HRB 7336 Gesch?ftsf?hrer Michael Zintel UstID-Nr.: DE206491704 St.-Nr.: 025 236 30022
AW: Upgraded to 4.28 and can no longer Login
Hi Aditya, thanks but this did not help. After a clean uninstall and reinstall, there is no profile folder yet. pdAdmin does not start after clicking the Shortcut, no splash screen appears and the browser does not open. There is however a running pgadmin4.exe Process, however it is not listening on any Port. Kind regards, N. Dechamps Von: Aditya Toshniwal Gesendet: Freitag, 13. November 2020 11:17 An: Nicolas Dechamps Cc: pgadmin-support@lists.postgresql.org Betreff: Re: Upgraded to 4.28 and can no longer Login Hi Nicolas, Shutdown pgAdmin, rename the file pgadmin4.db to pgadmin4.db.bak in directory - %APPDATA%/local/pgAdmin or %APPDATA%/roaming/pgAdmin, and then try starting pgAdmin again. On Fri, Nov 13, 2020 at 3:10 PM Nicolas Dechamps mailto:decha...@intend.de>> wrote: Hi Aditya, here is the log file and a Screenshot [cid:image001.png@01D6B9AF.C21D8C20] The Message is the same in three different Browsers Microsoft Edge, Firefox, Brave. I now tried to completely uninstall v4.28 and reinstall. Now, not even the splash-screen appears and no browser-windows opens, no profile-folder is created and no log is written. There is a Process pgadmin4.exe running, but no system-tray-icon. Thanks for the help! Nicolas Dechamps Von: Aditya Toshniwal mailto:aditya.toshni...@enterprisedb.com>> Gesendet: Freitag, 13. November 2020 09:10 An: Nicolas Dechamps mailto:decha...@intend.de>> Cc: pgadmin-support@lists.postgresql.org<mailto:pgadmin-support@lists.postgresql.org> Betreff: Re: Upgraded to 4.28 and can no longer Login Hi Nicolas, Please share the screenshot and pgAdmin logs (https://www.pgadmin.org/faq/#8) On Thu, Nov 12, 2020 at 11:26 PM Nicolas Dechamps mailto:decha...@intend.de>> wrote: Hi! I upgraded to today's new release 4.28 x64 on Windows and it says "404 Unauthorized. The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required." I deleted any stored passwords from my browser, disabled password-storing-feature of my Browser, tried 3 different browsers, rebooted, tried installing pgAdmin on other Computer but problem still persists. I uninstalled v. 4.28 to reinstall 4.27 but the it crashes/exits right after splash screen. Kind regards, N. Dechamps ____ Nicolas Dechamps IT Service decha...@intend.de<mailto:decha...@intend.de> INTEND Geoinformatik GmbH Johanna-Waescher-Straße 5 D - 34131 Kassel Tel +49 (0561) 316 799 0 Fax +49 (0561) 316 799 7 Web http://www.intend.de INTEND Geoinformatik GmbH Amtsgericht Kassel HRB 7336 Geschäftsführer Michael Zintel UstID-Nr.: DE206491704 St.-Nr.: 025 236 30022 -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | edbpostgres.com<http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE" -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | edbpostgres.com<http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE"
Upgraded to 4.28 and can no longer Login
Hi! I upgraded to today's new release 4.28 x64 on Windows and it says "404 Unauthorized. The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad password), or your browser doesn't understand how to supply the credentials required." I deleted any stored passwords from my browser, disabled password-storing-feature of my Browser, tried 3 different browsers, rebooted, tried installing pgAdmin on other Computer but problem still persists. I uninstalled v. 4.28 to reinstall 4.27 but the it crashes/exits right after splash screen. Kind regards, N. Dechamps ____ Nicolas Dechamps IT Service decha...@intend.de INTEND Geoinformatik GmbH Johanna-Waescher-Stra?e 5 D - 34131 Kassel Tel +49 (0561) 316 799 0 Fax +49 (0561) 316 799 7 Web http://www.intend.de INTEND Geoinformatik GmbH Amtsgericht Kassel HRB 7336 Gesch?ftsf?hrer Michael Zintel UstID-Nr.: DE206491704 St.-Nr.: 025 236 30022
pgAdmin4 Bug Report
Hi! I registered an account and signed up for this mailing list just to report this bug, so here is goes: pgAdmin4 v. 1.21 cannot handle Tables who's pk is called uppercase "ID". This sucks a lot because I have to deal with many such tables. Hope this will be fixed, thank you! Further Information: Windows 10 Desktop Mode Steps to reproduce: Create a table with "ID" als primary key. Try to enter data into a row in the grid, click save. This Error appears in the Application: 500 Internal Server Error Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application. This Error appears in the pgadmin4 log: 2018-02-12 09:43:53,704: ERROR werkzeug: Error on request: Traceback (most recent call last): File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\werkzeug\serving.py", line 209, in run_wsgi execute(self.server.app) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\werkzeug\serving.py", line 197, in execute application_iter = app(environ, start_response) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1997, in __call__ return self.wsgi_app(environ, start_response) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1985, in wsgi_app response = self.handle_exception(e) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1540, in handle_exception reraise(exc_type, exc_value, tb) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1982, in wsgi_app response = self.full_dispatch_request() File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1614, in full_dispatch_request rv = self.handle_user_exception(e) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1517, in handle_user_exception reraise(exc_type, exc_value, tb) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1612, in full_dispatch_request rv = self.dispatch_request() File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask\app.py", line 1598, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "C:\Program Files (x86)\pgAdmin 4\v2\venv\Lib\site-packages\flask_login.py", line 792, in decorated_view return func(*args, **kwargs) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\tools\sqleditor\__init__.py", line 991, in save default_conn) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\tools\sqleditor\command.py", line 647, in save item['select_sql'], res['rows'][0]) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", line 1028, in execute_dict self.__internal_blocking_execute(cur, query, params) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\utils\driver\psycopg2\__init__.py", line 575, in __internal_blocking_execute cur.execute(query, params) File "C:\Program Files (x86)\pgAdmin 4\v2\web\pgadmin\utils\driver\psycopg2\cursor.py", line 176, in execute return _cursor.execute(self, query, params) KeyError: '"ID"' Kind regards Nicolas Dechamps
