Re: PgAdmin Fatal Error

From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
To: Chan Say Hao <sayhaochan(at)gmail(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: PgAdmin Fatal Error
Date: 2020-09-08 05:00:41
Message-ID: CAFOhELe2QjWAGnaTw2KQH6QpXU4Y6=yq7O=PVQgDqCecR0JeKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

On Mon, Sep 7, 2020 at 9:03 PM Chan Say Hao <sayhaochan(at)gmail(dot)com> wrote:

> there you go
>
> On Mon, Sep 7, 2020 at 7:46 PM Khushboo Vashi <
> khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> Please provide the pgAdmin 4 log files located at "
>> *C:\Users\<user_name>\AppData\Local*".
>>
>> It's a SQLite database problem.
Error: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError)
duplicate column name: comment
[SQL: ALTER TABLE server ADD COLUMN comment TEXT(1024)]

You can do following to get rid of the error:

- Take the backup of the '*pgadmin4.db*' file located at "
*C:\Users\<user_name>\.pgadmin*" and then delete it.
- Restart the pgAdmin4

Have you upgraded your existing pgAdmin setup or it's a fresh installation?

Thanks,
Khushboo

Thanks,
>> Khushboo
>>
>> On Mon, Sep 7, 2020 at 5:07 PM Chan Say Hao <sayhaochan(at)gmail(dot)com> wrote:
>>
>>> Good day,
>>>
>>> I am currently encountering the problem of "Fatal Error: The application
>>> server could not be comtacted." when I was trying to run the PgAdmin 4.exe.
>>> I'd tried every method shown in "
>>> https://stackoverflow.com/questions/46633839/pgadmin-fatal-error-the-appllication-server-could-not-be-contacted"
>>> including reinstall, run as administrator, modify config_local.py file,
>>> restart in my server, but the problem hasn't been resolved. Could you help
>>> me with this?
>>>
>>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2020-09-08 08:15:47 Re: PgAdmin Fatal Error
Previous Message Khushboo Vashi 2020-09-07 11:46:21 Re: PgAdmin Fatal Error