| Новости | FAQ | Авторы | Документация | В действии | Библиотека |
| Инструменты | Полезные ссылки | Хостинги | Скачать | Примеры | Форум |
AK666 18.03 04:09 / 18.03 04:32
пробую сохранять exeption в базу: $lMessage[EXCEPTION: ^if(def $aMessage){${aMessage}^#0A}^if(def $lException ){^json:string[$lException]}^if($lStack){^#0AStack:^#0A^lStack.menu{ $lStack.name : $lStack.file ($lStack.lineno) }[^#0A]}]строго по Вашему шаблону: ^connect[$lLogger.db]{
$query[^apply-taint[sql][
INSERT INTO $lLogger.table
SET
Session = '${status:pid}/$status:tid'
^if(def $lLevel){ ,Level = ^lLevel.int(-1) }
^if(def $lSection){ ,Section = _utf8'^lSection.left(250)'}
,Message = _utf8'^taint[$lMessage]'
,Host = _utf8'$env:REMOTE_ADDR ^if($env:HTTP_X_REAL_IP ne $env:REMOTE_ADDR || def $env:HTTP_CF_IPCOUNTRY){($env:HTTP_X_REAL_IP $env:HTTP_CF_IPCOUNTRY)} -> $env:SERVER_ADDR'
,Domain = _utf8'$env:HTTP_HOST / $env:SERVER_NAME'
,URI = _utf8'$env:REQUEST_URI -> $env:PATH_TRANSLATED'
,ENV = _utf8'^taint[^json:string[$env:fields]]'
,Forms = ^if(def $form:fields){_utf8'^taint[^json:string[$form:fields]]'}{NULL}
]]
^void:sql{$query}
}не пишет в базу, пишет в лог парсера:Unhandled exception in eLogger.p(87:13): '\n INSERT INTO log_exception\n SET\n Session = '58979/58979'\n ,Level = 65535 \n ,Section = _utf8'UNHANDLED'\n ,Message = _utf8'EXCEPTION: type: sql.execute\\nsource: \\n INSERT INTO log_exception\\n SET\\n Session = \\'58979/58979\\'\\n ,Level = 65535 \\n ,Section = _utf8\\'db\\'\\n ,Message = _utf8\\'EXCEPTION: type: sql.execute\\\\nsource: UPDATE email SET StatusID = 200 WHERE ID = 102970\\\\nfile: /ext.bounce.p\\\\nlineno: 72\\\\ncolno: 13\\\\ncomment: UPDATE command denied to user \\\\\\'API\\\\\\'@\\\\\\'10.0.0.22\\\\\\' for table \\\\\\'email\\\\\\'\\\\nhandled: 0\\'\\n ,Host = _utf8\\'10.0.0.60 ( ) -> 10.0.0.22\\'\\n ,Domain = _utf8\\'t.local / t.local\\'\\n ,URI = _utf8\\'/?bounce -> /EXT.local/index.p3h\\'\\n "