'REQUEST_TIME_FLOAT' => 1609323003.9932
'REQUEST_TIME' => 1609323003
]
+2021-01-11 09:41:20 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13
+ in /var/www/invent/basic/views/layouts/main.php:104
+ in /var/www/invent/basic/controllers/ItemsController.php:266
+2021-01-11 09:41:20 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13
+2021-01-11 09:41:20 [192.168.0.13][2][-][info][application] $_GET = [
+ 'r' => 'items/check'
+]
+
+$_POST = []
+
+$_FILES = []
+
+$_COOKIE = [
+ '_identity' => '0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[2,null,2592000]\";}'
+]
+
+$_SESSION = [
+ '__flash' => []
+ '__id' => 2
+]
+
+$_SERVER = [
+ 'HTTPS' => 'on'
+ 'SSL_SERVER_S_DN_C' => 'RU'
+ 'SSL_SERVER_S_DN_ST' => 'MSK'
+ 'SSL_SERVER_S_DN_L' => 'Moscow'
+ 'SSL_SERVER_S_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1'
+ 'SSL_SERVER_S_DN_OU' => 'IT'
+ 'SSL_SERVER_S_DN_CN' => '192.168.0.32'
+ 'SSL_SERVER_S_DN_Email' => 'tervet1@inbox.ru'
+ 'SSL_SERVER_I_DN_C' => 'RU'
+ 'SSL_SERVER_I_DN_ST' => 'MSK'
+ 'SSL_SERVER_I_DN_L' => 'Moscow'
+ 'SSL_SERVER_I_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1'
+ 'SSL_SERVER_I_DN_OU' => 'IT'
+ 'SSL_SERVER_I_DN_CN' => '192.168.0.32'
+ 'SSL_SERVER_I_DN_Email' => 'tervet1@inbox.ru'
+ 'SSL_VERSION_INTERFACE' => 'mod_ssl/2.4.25'
+ 'SSL_VERSION_LIBRARY' => 'OpenSSL/1.0.2u'
+ 'SSL_PROTOCOL' => 'TLSv1.2'
+ 'SSL_SECURE_RENEG' => 'true'
+ 'SSL_COMPRESS_METHOD' => 'NULL'
+ 'SSL_CIPHER' => 'ECDHE-RSA-AES128-GCM-SHA256'
+ 'SSL_CIPHER_EXPORT' => 'false'
+ 'SSL_CIPHER_USEKEYSIZE' => '128'
+ 'SSL_CIPHER_ALGKEYSIZE' => '128'
+ 'SSL_CLIENT_VERIFY' => 'NONE'
+ 'SSL_SERVER_M_VERSION' => '1'
+ 'SSL_SERVER_M_SERIAL' => 'A339F5E73AD6C129'
+ 'SSL_SERVER_V_START' => 'Sep 19 06:04:13 2020 GMT'
+ 'SSL_SERVER_V_END' => 'May 29 06:04:13 2034 GMT'
+ 'SSL_SERVER_S_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU'
+ 'SSL_SERVER_I_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU'
+ 'SSL_SERVER_A_KEY' => 'rsaEncryption'
+ 'SSL_SERVER_A_SIG' => 'sha256WithRSAEncryption'
+ 'SSL_SESSION_RESUMED' => 'Initial'
+ 'HTTP_HOST' => '192.168.0.32'
+ 'HTTP_CONNECTION' => 'keep-alive'
+ 'HTTP_CACHE_CONTROL' => 'max-age=0'
+ 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1'
+ 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Linux; Android 6.0.1; Le X527) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.101 Mobile Safari/537.36'
+ 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9'
+ 'HTTP_SEC_FETCH_SITE' => 'same-origin'
+ 'HTTP_SEC_FETCH_MODE' => 'navigate'
+ 'HTTP_SEC_FETCH_USER' => '?1'
+ 'HTTP_SEC_FETCH_DEST' => 'document'
+ 'HTTP_REFERER' => 'https://192.168.0.32/invent/index.php?r=items%2Fcheck'
+ 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate, br'
+ 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7'
+ 'HTTP_COOKIE' => '_identity=0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B2%2Cnull%2C2592000%5D%22%3B%7D'
+ 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
+ 'SERVER_SIGNATURE' => '<address>Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 443</address>
+'
+ 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)'
+ 'SERVER_NAME' => '192.168.0.32'
+ 'SERVER_ADDR' => '192.168.0.32'
+ 'SERVER_PORT' => '443'
+ 'REMOTE_ADDR' => '192.168.0.13'
+ 'DOCUMENT_ROOT' => '/var/www/html'
+ 'REQUEST_SCHEME' => 'https'
+ 'CONTEXT_PREFIX' => '/invent'
+ 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web'
+ 'SERVER_ADMIN' => 'webmaster@localhost'
+ 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php'
+ 'REMOTE_PORT' => '47605'
+ 'GATEWAY_INTERFACE' => 'CGI/1.1'
+ 'SERVER_PROTOCOL' => 'HTTP/1.1'
+ 'REQUEST_METHOD' => 'GET'
+ 'QUERY_STRING' => 'r=items%2Fcheck'
+ 'REQUEST_URI' => '/invent/index.php?r=items%2Fcheck'
+ 'SCRIPT_NAME' => '/invent/index.php'
+ 'PHP_SELF' => '/invent/index.php'
+ 'REQUEST_TIME_FLOAT' => 1610347280.5664
+ 'REQUEST_TIME' => 1610347280
+]
+2021-01-11 09:41:48 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13
+ in /var/www/invent/basic/views/items/check.php:192
+ in /var/www/invent/basic/controllers/ItemsController.php:266
+2021-01-11 09:41:48 [192.168.0.13][2][-][warning][yii\debug\Module::checkAccess] Access to debugger is denied due to IP address restriction. The requesting IP address is 192.168.0.13
+ in /var/www/invent/basic/views/items/check.php:192
+ in /var/www/invent/basic/controllers/ItemsController.php:266
+2021-01-11 09:41:48 [192.168.0.13][2][-][info][application] $_GET = [
+ 'r' => 'items/check'
+]
+
+$_POST = [
+ '_csrf' => 'Z8Dr0awl1xcyzT8yyukraS2rpw7zu43zvPYpTdyIx5IqqJjhgXHhQGC-SFmro2M_eJPQWLzB_bHRr2Uv7rihwQ=='
+ 'Check' => [
+ 'qrcheck' => '1630639, 3B1726X06799'
+ 'region' => ''
+ 'location' => ''
+ ]
+]
+
+$_FILES = []
+
+$_COOKIE = [
+ '_identity' => '0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[2,null,2592000]\";}'
+ 'PHPSESSID' => '9gbboi99p1fi3om5mgi7dr2m33'
+ '_csrf' => '0f500860b54cdb818156f8911cc63dd6598fc7948399fc149efdf6d535cb95ada:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"Mhs0-T6WRswkaJHVU8wVOzpBmYLb20fS\";}'
+]
+
+$_SESSION = [
+ '__flash' => []
+ '__id' => 2
+]
+
+$_SERVER = [
+ 'HTTPS' => 'on'
+ 'SSL_SERVER_S_DN_C' => 'RU'
+ 'SSL_SERVER_S_DN_ST' => 'MSK'
+ 'SSL_SERVER_S_DN_L' => 'Moscow'
+ 'SSL_SERVER_S_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1'
+ 'SSL_SERVER_S_DN_OU' => 'IT'
+ 'SSL_SERVER_S_DN_CN' => '192.168.0.32'
+ 'SSL_SERVER_S_DN_Email' => 'tervet1@inbox.ru'
+ 'SSL_SERVER_I_DN_C' => 'RU'
+ 'SSL_SERVER_I_DN_ST' => 'MSK'
+ 'SSL_SERVER_I_DN_L' => 'Moscow'
+ 'SSL_SERVER_I_DN_O' => 'GBUV MO TERVETUPRAVLENIE N1'
+ 'SSL_SERVER_I_DN_OU' => 'IT'
+ 'SSL_SERVER_I_DN_CN' => '192.168.0.32'
+ 'SSL_SERVER_I_DN_Email' => 'tervet1@inbox.ru'
+ 'SSL_VERSION_INTERFACE' => 'mod_ssl/2.4.25'
+ 'SSL_VERSION_LIBRARY' => 'OpenSSL/1.0.2u'
+ 'SSL_PROTOCOL' => 'TLSv1.2'
+ 'SSL_SECURE_RENEG' => 'true'
+ 'SSL_COMPRESS_METHOD' => 'NULL'
+ 'SSL_CIPHER' => 'ECDHE-RSA-AES128-GCM-SHA256'
+ 'SSL_CIPHER_EXPORT' => 'false'
+ 'SSL_CIPHER_USEKEYSIZE' => '128'
+ 'SSL_CIPHER_ALGKEYSIZE' => '128'
+ 'SSL_CLIENT_VERIFY' => 'NONE'
+ 'SSL_SERVER_M_VERSION' => '1'
+ 'SSL_SERVER_M_SERIAL' => 'A339F5E73AD6C129'
+ 'SSL_SERVER_V_START' => 'Sep 19 06:04:13 2020 GMT'
+ 'SSL_SERVER_V_END' => 'May 29 06:04:13 2034 GMT'
+ 'SSL_SERVER_S_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU'
+ 'SSL_SERVER_I_DN' => 'emailAddress=tervet1@inbox.ru,CN=192.168.0.32,OU=IT,O=GBUV MO TERVETUPRAVLENIE N1,L=Moscow,ST=MSK,C=RU'
+ 'SSL_SERVER_A_KEY' => 'rsaEncryption'
+ 'SSL_SERVER_A_SIG' => 'sha256WithRSAEncryption'
+ 'SSL_SESSION_ID' => 'a55f55fda6367926679498aa77880a624ddecaa475782a556f67403b32b05166'
+ 'SSL_SESSION_RESUMED' => 'Resumed'
+ 'HTTP_HOST' => '192.168.0.32'
+ 'HTTP_CONNECTION' => 'keep-alive'
+ 'CONTENT_LENGTH' => '548'
+ 'HTTP_ACCEPT' => 'text/html, */*; q=0.01'
+ 'HTTP_X_CSRF_TOKEN' => 'Z8Dr0awl1xcyzT8yyukraS2rpw7zu43zvPYpTdyIx5IqqJjhgXHhQGC-SFmro2M_eJPQWLzB_bHRr2Uv7rihwQ=='
+ 'HTTP_X_REQUESTED_WITH' => 'XMLHttpRequest'
+ 'HTTP_X_PJAX' => 'true'
+ 'HTTP_X_PJAX_CONTAINER' => '#p0'
+ 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Linux; Android 6.0.1; Le X527) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.101 Mobile Safari/537.36'
+ 'CONTENT_TYPE' => 'multipart/form-data; boundary=----WebKitFormBoundaryCOTvs1nq1m2lmOy5'
+ 'HTTP_ORIGIN' => 'https://192.168.0.32'
+ 'HTTP_SEC_FETCH_SITE' => 'same-origin'
+ 'HTTP_SEC_FETCH_MODE' => 'cors'
+ 'HTTP_SEC_FETCH_DEST' => 'empty'
+ 'HTTP_REFERER' => 'https://192.168.0.32/invent/index.php?r=items%2Fcheck'
+ 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate, br'
+ 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.9,en-US;q=0.8,en;q=0.7'
+ 'HTTP_COOKIE' => '_identity=0424a460104d24d440c97883d4a4b8af1b2fec1e80a4baf6c66247cbc223f9f7a%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B2%2Cnull%2C2592000%5D%22%3B%7D; PHPSESSID=9gbboi99p1fi3om5mgi7dr2m33; _csrf=0f500860b54cdb818156f8911cc63dd6598fc7948399fc149efdf6d535cb95ada%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%22Mhs0-T6WRswkaJHVU8wVOzpBmYLb20fS%22%3B%7D'
+ 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
+ 'SERVER_SIGNATURE' => '<address>Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 443</address>
+'
+ 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)'
+ 'SERVER_NAME' => '192.168.0.32'
+ 'SERVER_ADDR' => '192.168.0.32'
+ 'SERVER_PORT' => '443'
+ 'REMOTE_ADDR' => '192.168.0.13'
+ 'DOCUMENT_ROOT' => '/var/www/html'
+ 'REQUEST_SCHEME' => 'https'
+ 'CONTEXT_PREFIX' => '/invent'
+ 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web'
+ 'SERVER_ADMIN' => 'webmaster@localhost'
+ 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php'
+ 'REMOTE_PORT' => '47634'
+ 'GATEWAY_INTERFACE' => 'CGI/1.1'
+ 'SERVER_PROTOCOL' => 'HTTP/1.1'
+ 'REQUEST_METHOD' => 'POST'
+ 'QUERY_STRING' => 'r=items%2Fcheck'
+ 'REQUEST_URI' => '/invent/index.php?r=items%2Fcheck'
+ 'SCRIPT_NAME' => '/invent/index.php'
+ 'PHP_SELF' => '/invent/index.php'
+ 'REQUEST_TIME_FLOAT' => 1610347308.055
+ 'REQUEST_TIME' => 1610347308
+]
+2021-01-12 08:07:08 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][error][yii\db\Exception] PDOException: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean
+LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "...
+ ^
+HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. in /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php:1299
+Stack trace:
+#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1299): PDOStatement->execute()
+#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute()
+#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal()
+#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar()
+#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar()
+#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar()
+#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count()
+#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount()
+#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount()
+#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels()
+#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare()
+#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels()
+#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount()
+#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary()
+#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection()
+#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection()
+#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}()
+#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback()
+#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run()
+#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run()
+#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget()
+#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...')
+#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile()
+#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile()
+#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render()
+#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render()
+#26 [internal function]: app\controllers\SiteController->actionIndex()
+#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
+#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
+#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
+#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction()
+#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest()
+#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run()
+#33 {main}
+
+Next yii\db\Exception: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean
+LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "...
+ ^
+HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.
+The SQL being executed was: SELECT COUNT(*) FROM (SELECT "regions"."name", count("items".id) AS "icount", count(c.tid) AS "ccount" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" LEFT JOIN (SELECT "regions"."id", "items"."id" AS "tid" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" WHERE ("moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id")) AND ("items".checked = true)) "c" ON "regions".id = c.id AND "items".id = c.tid WHERE "moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id") GROUP BY "regions"."id") "c" in /var/www/invent/basic/vendor/yiisoft/yii2/db/Schema.php:678
+Stack trace:
+#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException()
+#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute()
+#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal()
+#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar()
+#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar()
+#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar()
+#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count()
+#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount()
+#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount()
+#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels()
+#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare()
+#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels()
+#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount()
+#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary()
+#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection()
+#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection()
+#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}()
+#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback()
+#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run()
+#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run()
+#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget()
+#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...')
+#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile()
+#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile()
+#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render()
+#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render()
+#26 [internal function]: app\controllers\SiteController->actionIndex()
+#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
+#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
+#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
+#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction()
+#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest()
+#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run()
+#33 {main}
+Additional Information:
+Array
+(
+ [0] => 42883
+ [1] => 7
+ [2] => ОШИБКА: оператор не существует: integer = boolean
+LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "...
+ ^
+HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.
+)
+
+2021-01-12 08:07:08 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][info][application] $_GET = []
+
+$_POST = []
+
+$_FILES = []
+
+$_COOKIE = [
+ '_identity' => '992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[1,null,2592000]\";}'
+ '_csrf' => '188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"3qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5\";}'
+ 'PHPSESSID' => 'v8ljrlq46s8u2tc1i37hav314q'
+]
+
+$_SESSION = [
+ '__flash' => []
+ '__id' => 1
+]
+
+$_SERVER = [
+ 'HTTP_HOST' => '192.168.0.32'
+ 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:84.0) Gecko/20100101 Firefox/84.0'
+ 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'
+ 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3'
+ 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate'
+ 'HTTP_DNT' => '1'
+ 'HTTP_CONNECTION' => 'keep-alive'
+ 'HTTP_REFERER' => 'http://192.168.0.32/invent/index.php?r=items%2Findex&page=63'
+ 'HTTP_COOKIE' => '_identity=992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B1%2Cnull%2C2592000%5D%22%3B%7D; _csrf=188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%223qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5%22%3B%7D; PHPSESSID=v8ljrlq46s8u2tc1i37hav314q'
+ 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1'
+ 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
+ 'SERVER_SIGNATURE' => '<address>Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 80</address>
+'
+ 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)'
+ 'SERVER_NAME' => '192.168.0.32'
+ 'SERVER_ADDR' => '192.168.0.32'
+ 'SERVER_PORT' => '80'
+ 'REMOTE_ADDR' => '192.168.0.68'
+ 'DOCUMENT_ROOT' => '/var/www/html'
+ 'REQUEST_SCHEME' => 'http'
+ 'CONTEXT_PREFIX' => '/invent'
+ 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web'
+ 'SERVER_ADMIN' => 'webmaster@localhost'
+ 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php'
+ 'REMOTE_PORT' => '57762'
+ 'GATEWAY_INTERFACE' => 'CGI/1.1'
+ 'SERVER_PROTOCOL' => 'HTTP/1.1'
+ 'REQUEST_METHOD' => 'GET'
+ 'QUERY_STRING' => ''
+ 'REQUEST_URI' => '/invent/index.php'
+ 'SCRIPT_NAME' => '/invent/index.php'
+ 'PHP_SELF' => '/invent/index.php'
+ 'REQUEST_TIME_FLOAT' => 1610428028.1935
+ 'REQUEST_TIME' => 1610428028
+]
+2021-01-12 08:09:58 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][error][yii\db\Exception] PDOException: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean
+LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "...
+ ^
+HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов. in /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php:1299
+Stack trace:
+#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1299): PDOStatement->execute()
+#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute()
+#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal()
+#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar()
+#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar()
+#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar()
+#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count()
+#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount()
+#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount()
+#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels()
+#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare()
+#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels()
+#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount()
+#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary()
+#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection()
+#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection()
+#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}()
+#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback()
+#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run()
+#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run()
+#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget()
+#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...')
+#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile()
+#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile()
+#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render()
+#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render()
+#26 [internal function]: app\controllers\SiteController->actionIndex()
+#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
+#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
+#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
+#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction()
+#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest()
+#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run()
+#33 {main}
+
+Next yii\db\Exception: SQLSTATE[42883]: Undefined function: 7 ОШИБКА: оператор не существует: integer = boolean
+LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "...
+ ^
+HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.
+The SQL being executed was: SELECT COUNT(*) FROM (SELECT "regions"."name", count("items".id) AS "icount", count(c.tid) AS "ccount" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" LEFT JOIN (SELECT "regions"."id", "items"."id" AS "tid" FROM "regions" LEFT JOIN "locations" ON "regions"."id" = "locations"."region_id" LEFT JOIN "moving" ON "locations"."id" = "moving"."location_id" LEFT JOIN "items" ON "moving"."item_id" = "items"."id" WHERE ("moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id")) AND ("items".checked = true)) "c" ON "regions".id = c.id AND "items".id = c.tid WHERE "moving"."id" IN (SELECT DISTINCT MAX(id) AS "id" FROM "moving" GROUP BY "item_id") GROUP BY "regions"."id") "c" in /var/www/invent/basic/vendor/yiisoft/yii2/db/Schema.php:678
+Stack trace:
+#0 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException()
+#1 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute()
+#2 /var/www/invent/basic/vendor/yiisoft/yii2/db/Command.php(433): yii\db\Command->queryInternal()
+#3 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(503): yii\db\Command->queryScalar()
+#4 /var/www/invent/basic/vendor/yiisoft/yii2/db/ActiveQuery.php(352): yii\db\Query->queryScalar()
+#5 /var/www/invent/basic/vendor/yiisoft/yii2/db/Query.php(366): yii\db\ActiveQuery->queryScalar()
+#6 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(169): yii\db\Query->count()
+#7 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(169): yii\data\ActiveDataProvider->prepareTotalCount()
+#8 /var/www/invent/basic/vendor/yiisoft/yii2/data/ActiveDataProvider.php(106): yii\data\BaseDataProvider->getTotalCount()
+#9 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(101): yii\data\ActiveDataProvider->prepareModels()
+#10 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(114): yii\data\BaseDataProvider->prepare()
+#11 /var/www/invent/basic/vendor/yiisoft/yii2/data/BaseDataProvider.php(155): yii\data\BaseDataProvider->getModels()
+#12 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(190): yii\data\BaseDataProvider->getCount()
+#13 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(158): yii\widgets\BaseListView->renderSummary()
+#14 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(326): yii\widgets\BaseListView->renderSection()
+#15 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(135): yii\grid\GridView->renderSection()
+#16 [internal function]: yii\widgets\BaseListView->yii\widgets\{closure}()
+#17 /var/www/invent/basic/vendor/yiisoft/yii2/widgets/BaseListView.php(138): preg_replace_callback()
+#18 /var/www/invent/basic/vendor/yiisoft/yii2/grid/GridView.php(301): yii\widgets\BaseListView->run()
+#19 /var/www/invent/basic/vendor/yiisoft/yii2/base/Widget.php(141): yii\grid\GridView->run()
+#20 /var/www/invent/basic/views/site/index.php(23): yii\base\Widget::widget()
+#21 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(348): require('/var/www/invent...')
+#22 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(257): yii\base\View->renderPhpFile()
+#23 /var/www/invent/basic/vendor/yiisoft/yii2/base/View.php(156): yii\base\View->renderFile()
+#24 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(410): yii\base\View->render()
+#25 /var/www/invent/basic/controllers/SiteController.php(71): yii\base\Controller->render()
+#26 [internal function]: app\controllers\SiteController->actionIndex()
+#27 /var/www/invent/basic/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
+#28 /var/www/invent/basic/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
+#29 /var/www/invent/basic/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
+#30 /var/www/invent/basic/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction()
+#31 /var/www/invent/basic/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest()
+#32 /var/www/invent/basic/web/index.php(12): yii\base\Application->run()
+#33 {main}
+Additional Information:
+Array
+(
+ [0] => 42883
+ [1] => 7
+ [2] => ОШИБКА: оператор не существует: integer = boolean
+LINE 1: ...moving" GROUP BY "item_id")) AND ("items".checked = true)) "...
+ ^
+HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.
+)
+
+2021-01-12 08:09:58 [192.168.0.68][1][v8ljrlq46s8u2tc1i37hav314q][info][application] $_GET = []
+
+$_POST = []
+
+$_FILES = []
+
+$_COOKIE = [
+ '_identity' => '992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa:2:{i:0;s:9:\"_identity\";i:1;s:16:\"[1,null,2592000]\";}'
+ '_csrf' => '188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a:2:{i:0;s:5:\"_csrf\";i:1;s:32:\"3qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5\";}'
+ 'PHPSESSID' => 'v8ljrlq46s8u2tc1i37hav314q'
+]
+
+$_SESSION = [
+ '__flash' => []
+ '__id' => 1
+]
+
+$_SERVER = [
+ 'HTTP_HOST' => '192.168.0.32'
+ 'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:84.0) Gecko/20100101 Firefox/84.0'
+ 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8'
+ 'HTTP_ACCEPT_LANGUAGE' => 'ru-RU,ru;q=0.8,en-US;q=0.5,en;q=0.3'
+ 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate'
+ 'HTTP_REFERER' => 'http://192.168.0.32/invent/index.php?r=items%2Findex&page=63'
+ 'HTTP_DNT' => '1'
+ 'HTTP_CONNECTION' => 'keep-alive'
+ 'HTTP_COOKIE' => '_identity=992cc680fcb56a39cf1a309dc6073fe21f1604f6f2a8c4dc514ba5f1d621968aa%3A2%3A%7Bi%3A0%3Bs%3A9%3A%22_identity%22%3Bi%3A1%3Bs%3A16%3A%22%5B1%2Cnull%2C2592000%5D%22%3B%7D; _csrf=188c1070b85264bfb7009e402414232b666a9bdda02a89a464df5a7ba83aeb95a%3A2%3A%7Bi%3A0%3Bs%3A5%3A%22_csrf%22%3Bi%3A1%3Bs%3A32%3A%223qwp9kFdsMrtfwkRmqxA48QwY5wZFHP5%22%3B%7D; PHPSESSID=v8ljrlq46s8u2tc1i37hav314q'
+ 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1'
+ 'HTTP_CACHE_CONTROL' => 'max-age=0'
+ 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
+ 'SERVER_SIGNATURE' => '<address>Apache/2.4.25 (Debian) Server at 192.168.0.32 Port 80</address>
+'
+ 'SERVER_SOFTWARE' => 'Apache/2.4.25 (Debian)'
+ 'SERVER_NAME' => '192.168.0.32'
+ 'SERVER_ADDR' => '192.168.0.32'
+ 'SERVER_PORT' => '80'
+ 'REMOTE_ADDR' => '192.168.0.68'
+ 'DOCUMENT_ROOT' => '/var/www/html'
+ 'REQUEST_SCHEME' => 'http'
+ 'CONTEXT_PREFIX' => '/invent'
+ 'CONTEXT_DOCUMENT_ROOT' => '/var/www/invent/basic/web'
+ 'SERVER_ADMIN' => 'webmaster@localhost'
+ 'SCRIPT_FILENAME' => '/var/www/invent/basic/web/index.php'
+ 'REMOTE_PORT' => '57910'
+ 'GATEWAY_INTERFACE' => 'CGI/1.1'
+ 'SERVER_PROTOCOL' => 'HTTP/1.1'
+ 'REQUEST_METHOD' => 'GET'
+ 'QUERY_STRING' => ''
+ 'REQUEST_URI' => '/invent/index.php'
+ 'SCRIPT_NAME' => '/invent/index.php'
+ 'PHP_SELF' => '/invent/index.php'
+ 'REQUEST_TIME_FLOAT' => 1610428198.7791
+ 'REQUEST_TIME' => 1610428198
+]