[OpenSIPS-Users] OpenSIPS-CP errors

[bobsy]

Hi,

I’m using opensips 3.1.1 from deb repo
And opensips-cp 8.3.1
With nginx and php7.3-fpm
Postgresql for db

And I’ve configured mi_http for json…

I’m receiving a few errors like this:

Failed to issue total count query, error message : Array ( [0] => 42P01 [1] => 7 [2] => ERROR: relation "cc_agents" does not exist LINE 2: from cc_agents ^ ) [select count(id) from cc_agents]

On the call centre page and on the dialog page


2021/01/14 12:50:29 [error] 3849#3849: *289 FastCGI sent in stderr: "PHP message: PHP Warning:  Creating default object from empty value in /var/www/opensips-cp/config/tools/system/dialog/local.inc.php on line 27PHP message: PHP Notice:  Array to string conversion in /var/www/opensips-cp/web/tools/system/dialog/dialog.php on line 112" while reading response header from upstream, client: 119.18.18.117, server: opensips.vale.ski, request: "GET /tools/system/dialog/dialog.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.3-fpm.sock:", host: "opensips.vale.ski", referrer: "http://opensips.vale.ski/menu.php”

I get this error on that page:

MI command failed with code -32601 (Method not found)

Any insight would be greatly appreciated.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20210114/a33b2ac6/attachment.html>