Re: pgAdmin4 fatal error

Thank you for asking Akshay.

This is the screenshot:
[image: image.png]
When I click Configure, this is the screen I get:
[image: image.png]

And this is the code in the error message pop up:
pgAdmin Runtime Environment
--------------------------------------------------------
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 -s C:\Program Files\PostgreSQL\13\pgAdmin
4\web\pgAdmin4.py"
Environment:
- ALLUSERSPROFILE: C:\ProgramData
- APPDATA: C:\Users\micha\AppData\Roaming
- CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_3972_BYNOMHADLKGWPQNK
- CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch
now?|LEFT_TO_RIGHT
- CommonProgramFiles: C:\Program Files\Common Files
- CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
- CommonProgramW6432: C:\Program Files\Common Files
- COMPUTERNAME: DESKTOP-NO39ITH
- ComSpec: C:\Windows\system32\cmd.exe
- DriverData: C:\Windows\System32\Drivers\DriverData
- HOMEDRIVE: C:
- HOMEPATH: \Users\micha
- LOCALAPPDATA: C:\Users\micha\AppData\Local
- LOGONSERVER: \\DESKTOP-NO39ITH
- NUMBER_OF_PROCESSORS: 8
- OneDrive: C:\Users\micha\OneDrive
- OneDriveConsumer: C:\Users\micha\OneDrive
- OS: Windows_NT
- Path:
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\PostgreSQL\13\bin;
- PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
- PGADMIN_INT_KEY: c347bce5-ffef-46b1-92af-6005bcd17a88
- PGADMIN_INT_PORT: 65516
- PGADMIN_SERVER_MODE: OFF
- PROCESSOR_ARCHITECTURE: AMD64
- PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 12,
GenuineIntel
- PROCESSOR_LEVEL: 6
- PROCESSOR_REVISION: 8e0c
- ProgramData: C:\ProgramData
- ProgramFiles: C:\Program Files
- ProgramFiles(x86): C:\Program Files (x86)
- ProgramW6432: C:\Program Files
- PSModulePath: C:\Program
Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
- PUBLIC: C:\Users\Public
- SESSIONNAME: Console
- SystemDrive: C:
- SystemRoot: C:\Windows
- TEMP: C:\Users\micha\AppData\Local\Temp
- TMP: C:\Users\micha\AppData\Local\Temp
- USERDOMAIN: DESKTOP-NO39ITH
- USERDOMAIN_ROAMINGPROFILE: DESKTOP-NO39ITH
- USERNAME: micha
- USERPROFILE: C:\Users\micha
- windir: C:\Windows
--------------------------------------------------------

Traceback (most recent call last):
File "C:\Program Files\PostgreSQL\13\pgAdmin 4\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'

I've uninstalled and installed a few times, I've restarted the computer and
I'm still getting the error :(

I'd be over the moon if I could have it resolved.

Many thanks,
Michaela

On Tue, May 18, 2021 at 12:47 PM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> What is the error?
>
> On Tue, 18 May, 2021, 5:14 pm Michaela Burrell, <michaela(at)datalorian(dot)co(dot)uk>
> wrote:
>
>> Many thanks Akshay,
>>
>> I've followed the steps but unfortunately, I've not been able to run
>> pgAdmin.
>>
>> I suppose I'll just wait for the next release and try again later.
>>
>> Many thanks again,
>> Michaela
>>
>> On Tue, May 18, 2021 at 12:12 PM Akshay Joshi <
>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Michaela
>>>
>>> We have figured out the issue, it is because of the latest version of
>>> the 'itsdangerous' python package which was released on 12th May. We are
>>> working on fixing the issue with EDB Installers.
>>>
>>> Meanwhile, you can perform the following steps:
>>>
>>> 1. Take a backup of your 'pgadmin4.db' file which is present at the
>>> "%APPDATA%\Roaming\pgadmin" folder.
>>> 2. Delete 'pgadmin4.db' file.
>>> 3. Download pgAdmin4 v5.2 from
>>> https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/windows/
>>> 4. Install and Launch 'pgAdmin4 v5'.
>>>
>>>
>>>
>>>
>>> On Tue, May 18, 2021 at 4:32 PM Michaela Burrell <
>>> michaela(at)datalorian(dot)co(dot)uk> wrote:
>>>
>>>> Hi Fahar and team,
>>>>
>>>> Many thanks for your kind and detailed advice, I've tried to follow the
>>>> steps and am still getting an error. I really don't know where I'm going
>>>> wrong.. I've also removed Program Files. Could the options I select during
>>>> the set-up cause the issue? I've noticed that when I receive the error,
>>>> there's a button that prompts me to Configure and then takes me to this
>>>> screen:
>>>> [image: image.png]
>>>>
>>>> Do I need to make some changes here?
>>>>
>>>> Apologies I've still not been able to resolve the issue..
>>>>
>>>> FYI, this is the error code:
>>>>
>>>> pgAdmin Runtime Environment
>>>> --------------------------------------------------------
>>>> 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 -s C:\Program Files\PostgreSQL\13\pgAdmin
>>>> 4\web\pgAdmin4.py"
>>>> Environment:
>>>> - ALLUSERSPROFILE: C:\ProgramData
>>>> - APPDATA: C:\Users\micha\AppData\Roaming
>>>> - CHROME_CRASHPAD_PIPE_NAME: \\.\pipe\crashpad_17492_YQFAERXYIGXBJWKH
>>>> - CHROME_RESTART: NW.js|Whoa! NW.js has crashed. Relaunch
>>>> now?|LEFT_TO_RIGHT
>>>> - CommonProgramFiles: C:\Program Files\Common Files
>>>> - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files
>>>> - CommonProgramW6432: C:\Program Files\Common Files
>>>> - COMPUTERNAME: DESKTOP-NO39ITH
>>>> - ComSpec: C:\Windows\system32\cmd.exe
>>>> - DriverData: C:\Windows\System32\Drivers\DriverData
>>>> - HOMEDRIVE: C:
>>>> - HOMEPATH: \Users\micha
>>>> - LOCALAPPDATA: C:\Users\micha\AppData\Local
>>>> - LOGONSERVER: \\DESKTOP-NO39ITH
>>>> - NUMBER_OF_PROCESSORS: 8
>>>> - OneDrive: C:\Users\micha\OneDrive
>>>> - OneDriveConsumer: C:\Users\micha\OneDrive
>>>> - OS: Windows_NT
>>>> - Path:
>>>> C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\PostgreSQL\13\bin;
>>>> - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
>>>> - PGADMIN_INT_KEY: db1beb31-746e-49e5-9338-e53e2ebfd8fe
>>>> - PGADMIN_INT_PORT: 63139
>>>> - PGADMIN_SERVER_MODE: OFF
>>>> - PROCESSOR_ARCHITECTURE: AMD64
>>>> - PROCESSOR_IDENTIFIER: Intel64 Family 6 Model 142 Stepping 12,
>>>> GenuineIntel
>>>> - PROCESSOR_LEVEL: 6
>>>> - PROCESSOR_REVISION: 8e0c
>>>> - ProgramData: C:\ProgramData
>>>> - ProgramFiles: C:\Program Files
>>>> - ProgramFiles(x86): C:\Program Files (x86)
>>>> - ProgramW6432: C:\Program Files
>>>> - PSModulePath: C:\Program
>>>> Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
>>>> - PUBLIC: C:\Users\Public
>>>> - SESSIONNAME: Console
>>>> - SystemDrive: C:
>>>> - SystemRoot: C:\Windows
>>>> - TEMP: C:\Users\micha\AppData\Local\Temp
>>>> - TMP: C:\Users\micha\AppData\Local\Temp
>>>> - USERDOMAIN: DESKTOP-NO39ITH
>>>> - USERDOMAIN_ROAMINGPROFILE: DESKTOP-NO39ITH
>>>> - USERNAME: micha
>>>> - USERPROFILE: C:\Users\micha
>>>> - windir: C:\Windows
>>>> --------------------------------------------------------
>>>>
>>>> Traceback (most recent call last):
>>>> File "C:\Program Files\PostgreSQL\13\pgAdmin 4\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'
>>>>
>>>> Many thanks,
>>>> Michaela
>>>>
>>>> On Mon, May 17, 2021 at 6:53 AM Fahar Abbas <
>>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Hi Michaela,
>>>>>
>>>>> Can you please follow instructions below:
>>>>>
>>>>> 1. Uninstall pgadmin4 community build(www.pgadmin.org)
>>>>> 2. uninstall all postgresql that downloaded from enterprisedb.com
>>>>> 3. Go into run and search %appdata% and remove pgadmin4
>>>>> 5. Can you please shutdown the Windows machine and start Windows
>>>>> machine again
>>>>> 6. Download and install the latest postgresql from
>>>>> https://www.enterprisedb.com/downloads/postgresql
>>>>> 7. Now hopefully you will be able to launch pgadmin4 successfully.
>>>>>
>>>>> On Tue, May 11, 2021 at 10:24 AM Fahar Abbas <
>>>>> fahar(dot)abbas(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> yes issue will be resolved on Postgresql.
>>>>>>
>>>>>> On Mon, May 10, 2021 at 3:28 PM Michaela Burrell <
>>>>>> michaela(at)datalorian(dot)co(dot)uk> wrote:
>>>>>>
>>>>>>> Many thanks Fahar,
>>>>>>>
>>>>>>> Does it mean it should resolve the issue I’m facing?
>>>>>>>
>>>>>>> Kind regards,
>>>>>>> Michaela
>>>>>>>
>>>>>>> Sent from my iPhone
>>>>>>>
>>>>>>> On 10 May 2021, at 09:23, Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>> 
>>>>>>> Hi Michaela,
>>>>>>>
>>>>>>> Our PostgreSQL packagers team will update the latest pgadmin4 5.2
>>>>>>> on the upcoming PostgreSQL minor release by the end of this week.
>>>>>>>
>>>>>>> On Tue, May 4, 2021 at 10: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.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.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"
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Fahar Abbas
>>>>>>> EnterpriseDB Corporation
>>>>>>> Phone Office: +92-51-835-8874
>>>>>>> Phone Direct: +92-51-8466803
>>>>>>> Mobile: +92-333-5409707
>>>>>>> Skype ID: *live:fahar.abbas*
>>>>>>> Website: www.enterprisedb.com
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> Fahar Abbas
>>>>>> EnterpriseDB Corporation
>>>>>> Phone Office: +92-51-835-8874
>>>>>> Phone Direct: +92-51-8466803
>>>>>> Mobile: +92-333-5409707
>>>>>> Skype ID: *live:fahar.abbas*
>>>>>> Website: www.enterprisedb.com
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Fahar Abbas
>>>>> EnterpriseDB Corporation
>>>>> Phone Office: +92-51-835-8874
>>>>> Phone Direct: +92-51-8466803
>>>>> Mobile: +92-333-5409707
>>>>> Skype ID: *live:fahar.abbas*
>>>>> Website: www.enterprisedb.com
>>>>>
>>>>
>>>
>>> --
>>> *Thanks & Regards*
>>> *Akshay Joshi*
>>> *pgAdmin Hacker | Principal Software Architect*
>>> *EDB Postgres <http://edbpostgres.com>*
>>>
>>> *Mobile: +91 976-788-8246*
>>>
>>