Re: No SQL errors visible in pgAdmin 4 1.5

That is strange. I do not see any error in log file :(

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

On Fri, Jun 9, 2017 at 2:31 AM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:

> Hi Murtuza,
>
> Thank you - I have followed those steps and please find attached the
> log file and the config files.
>
> The SQL I run was:
>
> select * from non_existing_table;
>
> and you can see it in line #2462 of the log file.
>
> I hope it helps.
>
> Thank you and kind regards
> Pawel
>
>
> On 8 June 2017 at 14:00, Murtuza Zabuawala
> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
> > Hi Pawel,
> >
> > I am not able not find any entry for your queries in log file, Can you
> turn
> > of the dashboard graphs for a while and then try to re-produce the issue.
> >
> > Steps to turn of the graphs,
> > 1) Goto File menu --> Preferences --> Dashboards --> Graphs
> > 2) Provide a rate value as 123456789 in all 5 inputs
> > 3) Click Ok
> > 4) close pgadmin4
> > 5) Delete the old log file
> > 6) start pgadmin4
> > 5) Re-produce the issue
> >
> > and send us this newly created log file.
> >
> > Again start the graphs,
> > 1) Goto File menu --> Preferences --> Dashboards --> Graphs
> > 2) Provide a rate value as 1 in all 5 inputs
> >
> > Thanks,
> > Murtuza Zabuawala
> > EnterpriseDB: http://www.enterprisedb.com
> > The Enterprise PostgreSQL Company
> >
> > On Thu, Jun 8, 2017 at 3:07 AM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:
> >>
> >> Hi Murtuza/Dave,
> >>
> >> I have created now the "config_local.py" as well and I am also
> >> attaching the output that now I can see in the Messages tab.
> >>
> >> I have run 2 SQLs:
> >> 1) select * from items; -- an existing table
> >> 2) select * from non_existing_table; -- a non-existing table
> >>
> >> Thanks and regards
> >> Pawel
> >>
> >> On 7 June 2017 at 12:00, Murtuza Zabuawala
> >> <murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
> >> > Hello,
> >> >
> >> > Are you able to locate "config.py" in pgAdmin4 directory?
> >> >
> >> > If yes then create a new file named "config_local.py" along side
> >> > "config.py"
> >> > and add below config option in it,
> >> > FILE_LOG_LEVEL = logging.DEBUG
> >> >
> >> > Restart pgAdmin4 and try to re-produce the issue again.
> >> >
> >> > --
> >> > Regards,
> >> > Murtuza Zabuawala
> >> > EnterpriseDB: http://www.enterprisedb.com
> >> > The Enterprise PostgreSQL Company
> >> >
> >> > On Wed, Jun 7, 2017 at 3:34 PM, Pawel Hadam <hadzio(at)gmail(dot)com> wrote:
> >> >>
> >> >> 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
>