Re: No SQL errors visible in pgAdmin 4 1.5

From: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
To: Pawel Hadam <hadzio(at)gmail(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: No SQL errors visible in pgAdmin 4 1.5
Date: 2017-06-07 04:52:35
Message-ID: CAKKotZRpWfBpSk9va2VxJE8MDg-yJO3pDK01UPswniZZb-38Bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

Without log file it very hard to trace the issue as this is not
re-producible on our side.
Are you sure that *pgadmin4.log* file is empty?

Can you try again changing the logging configuration, add below config
option in "config_local.py" (which is in pgAdmin4 installation directory),

FILE_LOG_LEVEL = logging.DEBUG

restart pgAdmin4 and re-produce the issue, check the log file for any error.

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Wed, Jun 7, 2017 at 2:30 AM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:

> Hi Murtuza,
>
> Thank you for your prompt answer. Those are the outputs for the two
> queries:
>
> *) UTF8
> *) UNICODE
>
> (I can see the same output in pgAdmin III)
>
> And the log file is created but it's empty.
>
> I am not sure if this helps?
>
> Thanks and regards
> Pawel
>
>
>
> On 6 June 2017 at 07:28, Murtuza Zabuawala
> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
> > Hello,
> >
> > Can you provide output from given queries,
> >
> > SHOW SERVER_ENCODING;
> > SHOW CLIENT_ENCODING;
> >
> > and also provide pgadmin4 log file just after re-producing the issue?
> > Log location: C:\Users\yourUserName\AppData\Roaming\pgAdmin
> >
> >
> > --
> > Regards,
> > Murtuza Zabuawala
> > EnterpriseDB: http://www.enterprisedb.com
> > The Enterprise PostgreSQL Company
> >
> > On Tue, Jun 6, 2017 at 11:29 AM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:
> >>
> >> Dear All,
> >>
> >> When I run an incorrect SQL I cannot see SQL error messages in pgAdmin 4
> >> 1.5. However, when the same SQL is run on the same database from
> pgAdmin III
> >> 1.22.2 I can see a full error message telling me what was wrong (please
> see
> >> the screenshots). It looks to me like the messages are turned off
> somewhere
> >> but I cannot see it in any preferences or options. I would appreciate
> any
> >> help or hints how to turn them on or where I can see them in pgAdmin 4
> 1.5.
> >>
> >> I am using PostgreSQl 9.6 on Windows 10 Pro.
> >>
> >> Thank you and kind regards
> >> Pawel
> >>
> >>
> >>
> >
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Pawel Hadam 2017-06-07 10:04:20 Re: No SQL errors visible in pgAdmin 4 1.5
Previous Message Pawel Hadam 2017-06-06 21:00:07 Re: No SQL errors visible in pgAdmin 4 1.5