Re: No SQL errors visible in pgAdmin 4 1.5

From: Pawel Hadam <hadzio(at)gmail(dot)com>
To: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(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 10:04:20
Message-ID: CAPZL3N3i=Ux+3fgTuYLOkuWNUB=KrHM8bNmB-De_BszN7h+DTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Murtuza,

Thank you. I attached the empty log file to my previous email - this
is what was produced. Just an empty file.

Also, I cannot find "config_local.py" in my installation folder:
C:\Program Files (x86)\pgAdmin 4

Thank you and kind regards
Pawel

On 7 June 2017 at 05:52, Murtuza Zabuawala
<murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
> 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 Murtuza Zabuawala 2017-06-07 11:00:12 Re: No SQL errors visible in pgAdmin 4 1.5
Previous Message Murtuza Zabuawala 2017-06-07 04:52:35 Re: No SQL errors visible in pgAdmin 4 1.5