EXCEPTION: SQLSTATE[22032]: : 3141 Invalid JSON text in argument 1 to function json_contains: "The document is empty." at position 0.SELECT `ur_canned_responses`.`language` FROM `ur_canned_responses` WHERE (language != 'all') AND (available_type = 'all' OR available_type = 'selected_agents' AND JSON_CONTAINS(available_value, '') OR available_type = 'selected_teams' AND JSON_CONTAINS(available_value, '4')) GROUP BY `language`Exception on line 234 in file /var/www/html/application/8.20.0/library/Zend/Db/Statement/Pdo.php, PHP 8.3.21 (Linux)

Error has occured!

Error description:

EXCEPTION: SQLSTATE[22032]: <>: 3141 Invalid JSON text in argument 1 to function json_contains: "The document is empty." at position 0.SELECT `ur_canned_responses`.`language` FROM `ur_canned_responses` WHERE (language != 'all') AND (available_type = 'all' OR available_type = 'selected_agents' AND JSON_CONTAINS(available_value, '') OR available_type = 'selected_teams' AND JSON_CONTAINS(available_value, '4')) GROUP BY `language`

Exception on line 234 in file /var/www/html/application/8.20.0/library/Zend/Db/Statement/Pdo.php, PHP 8.3.21 (Linux)

Requested page:

http://help.locusmap.eu/agent/object/40516

Module name:	system
Controller name:	agent
Action name:	object
Parameters:	object_id = (string) 40516

Stack trace:

In file	On line	Called class	Called function	With arguments
Statement.php	300	Zend_Db_Statement_Pdo	_execute	NULL
Abstract.php	482	Zend_Db_Statement	execute	NULL
Abstract.php	238	Zend_Db_Adapter_Abstract	query	NULL
Abstract.php	805	Zend_Db_Adapter_Pdo_Abstract	query	NULL
CannedResponses.php	208	Zend_Db_Adapter_Abstract	fetchCol	NULL
Events.php	476	System_Model_DbTable_CannedResponses	findLanguages	NULL
Event.php	78	System_Handler_Events	onPreDispatchFull	NULL
Events.php	92	Singular_Event	dispatch	NULL
Broker.php	309	Singular_Controller_Plugin_Events	preDispatch	NULL
Front.php	944	Zend_Controller_Plugin_Broker	preDispatch	NULL
Bootstrap.php	960	Zend_Controller_Front	dispatch	NULL
index.php	48	Singular_Bootstrap	run	NULL
index.php	55		{closure}	NULL

System information:

PHP version:

8.3.21 on Linux runned as fpm-fcgi

Loaded extensions:

Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium, cgi-fcgi, mysqlnd, PDO, xml, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, imap, intl, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache

MySQL server:

MySQL 8.0.46 via PDO_MYSQL 8.3.21

UseResponse:

Product version:

8.18.0 released on May 1, 2026 12:00:00 AM GMT by UseResponse Inc.

Installed modules:

System	v. 8.18.0 on May 1, 2026 12:00:00 AM GMT by UseResponse Inc.
Resources	v. 3.2 on February 20, 2015 12:00:00 AM GMT by UseResponse Inc.
Announcements	v. 3.0 on March 20, 2014 12:00:00 AM GMT by UseResponse Inc.
Single Sign-On	v. 3.0 on August 5, 2013 12:00:00 AM GMT by UseResponse Inc.
Polls	v. 3.0 on June 7, 2012 12:00:00 AM GMT by UseResponse Inc.
Help Desk	v. 3.0 on February 20, 2015 12:00:00 AM GMT by UseResponse Inc.
Feedback	v. 3.0 on October 9, 2013 12:00:00 AM GMT by UseResponse Inc.
Knowledge Base	v. 3.0 on March 15, 2013 12:00:00 AM GMT by UseResponse Inc.
Backup	v. 1.0 on August 26, 2018 12:00:00 AM GMT by UseResponse Inc.
Multi-Communities	v. 4.0 on February 20, 2015 12:00:00 AM GMT by UseResponse Inc.
Enterprise	v. 4.0 on February 20, 2015 12:00:00 AM GMT by UseResponse Inc.
Google Translate & DeepL	v. 1.0 on April 13, 2022 12:00:00 AM GMT by UseResponse Inc.
Git	v. 1.0 on March 16, 2023 12:00:00 AM GMT by UseResponse Inc.

Autoglobal variables:

GETArray
(
)

POSTArray
(
)

COOKIEArray
(
    [URSESSID] => h5m3h00ab3a279s0v7v8j1kbfi
    [csrf_protection_votes_csrf_key] => 6ed0b5aac06192fe39987dfb9bad3b11
    [views] => 10121-11041-343-16717-1976-707-4589-3657-25759-7994-34021-18388-2266-21069-15272
)

SESSIONArray
(
    [KbSharing] => Array
        (
            [accessKey] => 
        )

    [Notifications] => Array
        (
            [messages] => Array
                (
                    [error] => Array
                        (
                        )

                    [success] => Array
                        (
                        )

                    [info] => Array
                        (
                        )

                )

        )

    [csrf_protection] => Array
        (
            [votes_csrf_key] => 6ed0b5aac06192fe39987dfb9bad3b11
        )

    [csrf_tokens_storage] => Array
        (
            [votes_csrf_key] => Array
                (
                    [b493d3ab1ae80122d50e68073f6d88f7] => 1782414402
                    [f2378782c2876ceea9ebac20f3ec1bae] => 1782414403
                    [d9f3aa322bd94f62d8face1dac924e7e] => 1782414403
                    [25355e0757d015a8528df13d45ba93f1] => 1782414404
                    [dbc0a624720336c28c725d4203b0b740] => 1782414406
                    [429f196ebb7c86cbed07cda3cd589432] => 1782414408
                    [2bc018fee06e6a01502a5e980e86a5b6] => 1782414411
                    [16f3f954759e84dff293d71bac6867f4] => 1782414413
                    [83efd65a9f7a00b491c3cbf3d7836d5b] => 1782414414
                    [db0530883f3f9a7918679fb07a19a2f9] => 1782414416
                    [9e27197e19b0fcfcb756e8f85ac5c78e] => 1782414419
                    [87fe3df56aa74bfbe726813ac14ce45e] => 1782414419
                    [4e3e176f63c88d72b1bd531ae2380ace] => 1782414419
                    [894a266dbb9bc40c48b1dff76b8cdbb9] => 1782414423
                    [86351b3591536c333a4acb88303950b1] => 1782414423
                    [eb4455d296af92f4de4d92d3ce2bd924] => 1782414424
                    [85091bf9d01ad4c4d3fb761a8abe1e97] => 1782414425
                    [6ed0b5aac06192fe39987dfb9bad3b11] => 1782414426
                )

        )

)