Re: pgAdmin4 fatal error

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