Re: pgAdmin4 fatal error

Hi Michaela

After checking the screenshot it seems you are launching the wrong pgAdmin
4. As you downloaded and installed pgAdmin4 v5.2 from
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v5.2/windows/.
Please launch another pgAdmin 4. I forgot the exact name in the menu but it
might be 'pgAdmin 4 v5" something like that.

On Tue, May 18, 2021 at 5:27 PM Michaela Burrell <michaela(at)datalorian(dot)co(dot)uk>
wrote:

> 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*
>>>>
>>>

--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*