Page 3 of 3

Re: Afanasy Statistics

Posted: Thu Feb 20, 2020 1:03 pm
by vdobrv
Hello

1. I checked that the user has full rights to work with Postgresql, and specifically to the necessary databases
2. I turned on Postgresql advanced logging, which translates all calls to the database.
SELECT and INSERT operations occur without errors, as can be seen on the logs.
What direction to dig further if there are no problems with the database.

Ubuntu Server 18.04 LTS
Afanasy 2.3.1
PSQL 10
Apache 2.4.29
PHP 7.2.24

And could you add a debug mod in the future

Re: Afanasy Statistics

Posted: Thu Feb 20, 2020 1:38 pm
by timurhai
So, now server insets data into jobs and tasks tables?
Have you checked that tables are not empty?
Can you check it by command line?
What is that commands output:

Code: Select all

select count(*) from jobs;

Code: Select all

select count(*) from tasks;

Re: Afanasy Statistics

Posted: Thu Feb 20, 2020 6:32 pm
by vdobrv
In the table TASKS created record
There are no entries in the JOBS table

Added afadmin database user, super user rights, just in case
Here is a screen of server logs and DB

Re: Afanasy Statistics

Posted: Fri Feb 21, 2020 9:20 am
by timurhai
Hi.
It is hard (some times impossible) to read images that you attach. Can you not to do it.
If you want to show some text, please copy and paste it as a text.
And it seems that you should consult some SQL (PostgreSQL) experienced user, i am not.
Or try to google this psql errors.
"FATAL ..." errors are printed by pslq library.