|
| Informações Técnicas |
| Tipo de Erro | 256 |
| Descrição do Erro | ERROR: invalid input syntax for type json
DETAIL: Expected end of input, but found ",".
CONTEXT: JSON data, line 1: ...do.pdf,!TI.02.3879.2025 assinado.pdf,!:sStrEnd"},... |
| URL | licenciamento.agenciaambientaldovale.sp.gov.br/publicas/tbl_indeferimento_list.php?masterkey1=3879&mastertable=app.tbl_requerimento1 |
| Arquivo de Erro | /usr/share/nginx/static/sp.lia.apps/publicas/connections/Connection.php |
| Linha com Erro | 668 |
| Consulta de SQL | SELECT
"uid", "uid_requer", "email_user", "motivo", "recomendacao", "arquivo", REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo_nm", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label"
FROM "app"."tbl_indeferimento" WHERE ( ( ( ( uid_requer=3879 ) ) ) ) ORDER BY 1 ASC limit 10 offset 0 |
| #0 |
connections/Connection.php:668 |
Connection->triggerError |
0. ERROR: invalid input syntax for type json
DETAIL: Expected end of input, but found ",".
CONTEXT: JSON data, line 1: ...do.pdf,!TI.02.3879.2025 assinado.pdf,!:sStrEnd"},... |
| #1 |
connections/PostgreConnection.php:104 |
PostgreConnection->query |
0. SELECT
"uid", "uid_requer", "email_user", "motivo", "recomendacao", "arquivo", REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo_nm", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label"
FROM "app"."tbl_indeferimento" WHERE ( ( ( ( uid_requer=3879 ) ) ) ) ORDER BY 1 ASC limit 10 offset 0 |
| #2 |
connections/dbfunctions/PostgreFunctions.php:122 |
PostgreFunctions->limitedQuery |
0. PostgreConnection
1. SELECT
"uid", "uid_requer", "email_user", "motivo", "recomendacao", "arquivo", REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo_nm", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label"
FROM "app"."tbl_indeferimento" WHERE ( ( ( ( uid_requer=3879 ) ) ) ) ORDER BY 1 ASC limit 10 offset 0
2. 0
3. 10
4. 1 |
| #3 |
connections/Connection.php:608 |
Connection->limitedQuery |
0. SELECT
"uid", "uid_requer", "email_user", "motivo", "recomendacao", "arquivo", REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'name','files/','') as "arquivo_nm", REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(arquivo, '[', ''), ']', '')::JSON ->> 'usrName', 'files/', ''), '.pdf', ''),'.PDF','') as "label"
FROM "app"."tbl_indeferimento" WHERE ( ( ( ( uid_requer=3879 ) ) ) ) ORDER BY 1 ASC
1. 0
2. 10
3. 1 |
| #4 |
classes/datasource/table.php:629 |
DataSourceTable->getListImpl |
0. DsCommand |
| #5 |
classes/datasource/datasource.php:44 |
DataSource->getList |
0. DsCommand |
| #6 |
classes/listpage.php:2053 |
ListPage->getRecordset |
N/A |
| #7 |
classes/listpage.php:2204 |
ListPage->prepareForBuildPage |
N/A |
| #8 |
tbl_indeferimento_list.php:158 |
Global scope |
N/A |