Re: pgAdmin4 fatal error

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