Re: pgAdmin4 fatal error

From: Michaela Burrell <michaela(at)datalorian(dot)co(dot)uk>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: Rahul Shirsat <rahul(dot)shirsat(at)enterprisedb(dot)com>, "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin4 fatal error
Date: 2021-05-09 20:14:08
Message-ID: CAHU0OypvouKppv7GwCKe+B4cRXHKWB7tHk+n7XBdb2c5gC_bjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Raul and Aditya,

Many thanks for looking into this for me.

I have uninstalled and installed again (newer version) and only have 1
pgAdmin installed now, thank you for flagging that.

This is the error message I receive:
Python Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\python\python.exe"
Runtime Config File:
"C:\Users\micha\AppData\Roaming\pgadmin\runtime_config.json"
pgAdmin Config File: "C:\Program Files\PostgreSQL\13\pgAdmin
4\web\config.py"
Webapp Path: "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgAdmin4.py"
pgAdmin Command: "C:\Program Files\PostgreSQL\13\pgAdmin
4\python\python.exe C:\Program Files\PostgreSQL\13\pgAdmin
4\web\pgAdmin4.py"
Traceback (most recent call last):
File "../web/pgAdmin4.py", line 98, in <module>
app = create_app()
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\web\pgadmin\__init__.py",
line 347, in create_app
if not os.path.exists(SQLITE_PATH) or get_version() == -1:
File "C:\Program Files\PostgreSQL\13\pgAdmin
4\web\pgadmin\setup\db_version.py", line 19, in get_version
return version.value
AttributeError: 'NoneType' object has no attribute 'value'

Is this what you meant Raul? Apologies in case it's something else, I'm not
very technical.

Many thanks again,
Michaela

On Tue, May 4, 2021 at 6:27 AM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi Michaela,
>
> I suspect you're using pgAdmin shipped with PostgeSQL 10 installer which
> is an older version. Please check if you have two pgAdmin installed - one
> which comes with PostgreSQL bundle (you can uninstall this) and another
> which you have separately downloaded and installed.
>
> On Tue, May 4, 2021 at 9:53 AM Rahul Shirsat <
> rahul(dot)shirsat(at)enterprisedb(dot)com> wrote:
>
>> Hi Michaela,
>>
>> Could you please share the log files generated at
>> %APPDATA\Roaming\pgadmin\% by name pgadmin4<number>.log?
>>
>> Also do share pgadmin4.startup file residing under
>> %APPDATA%\AppData\Local ..
>>
>> On Tue, May 4, 2021, 12:59 AM Michaela Burrell <michaela(at)datalorian(dot)co(dot)uk>
>> wrote:
>>
>>> Hi,
>>>
>>> I wonder if you could help please.
>>>
>>> I'm doing an SQL training course and I'm struggling to open pgadmin.
>>>
>>> I've been in contact with course provider but they've not been able to
>>> resolve my issue despite multiple email exchanges and I wonder if you might
>>> be able to help please?
>>>
>>> I've downloaded PostgreSQL (v10.16) from
>>> https://www.postgresql.org/download/ and then pgAdmin4 (v 5.1) as
>>> advised by the trainer.
>>>
>>> However, when I open pgAdmin, I receive this message:
>>> [image: image.png]
>>>
>>> I;ve been advised to update my system settings (.i.e. Path in
>>> Environment Variables) to the following but it's not resolved the issue.
>>> I'd be most grateful if you could please help.
>>>
>>> [image: image.png]
>>>
>>> Many thanks in advance,
>>> Michaela
>>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Fahar Abbas 2021-05-10 08:23:41 Re: pgAdmin4 fatal error
Previous Message Rahul Shirsat 2021-05-09 11:57:19 Re: Ubuntu install problem