|
| Informações Técnicas |
| Tipo de Erro | 256 |
| Descrição do Erro | ERRO: coluna "cod_cidade" não existe
LINE 2: ...ereco", "nro", "complemento", "bairro", "cidade", cod_cidade...
^
HINT: Talvez você queira fazer referência à coluna "transportadora.codicidade". |
| URL | omegaerp.com.br/sistema/compras_itens_list.php?masterkey1=1&masterkey2=8&mastertable=public.compras |
| Arquivo de Erro | C:\inetpub\vhosts\omegaerp.com.br\httpdocs\sistema\connections\Connection.php |
| Linha com Erro | 664 |
| Consulta de SQL | SELECT
"codigo", "razao_social", "fantasia", "endereco", "nro", "complemento", "bairro", "cidade", cod_cidade, "cep", "uf", cnpj_cpf, insc_id, telefone, celular, "email", "observacoes"
FROM "public"."transportadora" WHERE ( ( ( ( codigo=3 ) ) ) ) |
| #0 |
connections\Connection.php:664 |
Connection->triggerError |
0. ERRO: coluna "cod_cidade" não existe
LINE 2: ...ereco", "nro", "complemento", "bairro", "cidade", cod_cidade...
^
HINT: Talvez você queira fazer referência à coluna "transportadora.codicidade". |
| #1 |
connections\PostgreConnection.php:113 |
PostgreConnection->query |
0. SELECT
"codigo", "razao_social", "fantasia", "endereco", "nro", "complemento", "bairro", "cidade", cod_cidade, "cep", "uf", cnpj_cpf, insc_id, telefone, celular, "email", "observacoes"
FROM "public"."transportadora" WHERE ( ( ( ( codigo=3 ) ) ) ) |
| #2 |
connections\dbfunctions\PostgreFunctions.php:128 |
PostgreFunctions->limitedQuery |
0. PostgreConnection
1. SELECT
"codigo", "razao_social", "fantasia", "endereco", "nro", "complemento", "bairro", "cidade", cod_cidade, "cep", "uf", cnpj_cpf, insc_id, telefone, celular, "email", "observacoes"
FROM "public"."transportadora" WHERE ( ( ( ( codigo=3 ) ) ) )
2. 0
3. -1
4. 1 |
| #3 |
connections\Connection.php:604 |
Connection->limitedQuery |
0. SELECT
"codigo", "razao_social", "fantasia", "endereco", "nro", "complemento", "bairro", "cidade", cod_cidade, "cep", "uf", cnpj_cpf, insc_id, telefone, celular, "email", "observacoes"
FROM "public"."transportadora" WHERE ( ( ( ( codigo=3 ) ) ) )
1. 0
2. -1
3. 1 |
| #4 |
classes\datasource\table.php:645 |
DataSourceTable->getListImpl |
0. DsCommand |
| #5 |
classes\datasource\datasource.php:44 |
DataSource->getList |
0. DsCommand |
| #6 |
classes\controls\ViewLookupWizardField.php:191 |
ViewLookupWizardField->fetchLookupValues |
0. Array
(
[0] => 3
)
1. 1 |
| #7 |
classes\controls\ViewLookupWizardField.php:163 |
ViewLookupWizardField->getLookupValues |
0. 3 |
| #8 |
classes\controls\ViewLookupWizardField.php:228 |
ViewLookupWizardField->showDBValue |
0. Array
(
[empresa] => 1
[codigo] => 8
[fornecedor] => 9
[transportadora] => 3
[situacao] =>
[serie] => 1
[cstat] =>
[tpnf] =>
[finnfe] =>
[modfrete] =>
[qvol] =>
[demi] => 2026-03-27
[dsaient] =>
[dentrada] => 2026-07-21
[hsaient] =>
[vprod] => 359.56
[vdesc] => 0.00
[vnf] => 359.56
[vbc] => 0.00
[vicms] => 0.00
[vfrete] => 0.00
[vseg] => 0.00
[vbcst] => 0.00
[vst] => 0.00
[vii] => 0.00
[vipi] => 0.00
[vpis] => 0.00
[vcofins] => 0.00
[voutro] => 0.00
[pesob] => 0.00
[cfop] =>
[nnf] => 215
[natop] => DEVOLUCAO DE COMPRA P/ COMERCIALIZACAO
[chnfe] => 24260340785834000174550010000002151141267039
[obs] =>
[gibs_vibs] => 0.00
[gcbs_vcbs] => 0.00
[pmarkup] => 30.00
[vmarkup] =>
[pesol] => 0.00
)
1. &key1=1&key2=8
2. 1 |
| #9 |
classes\runnerpage.php:4621 |
RunnerPage->showDBValue |
0. transportadora
1. Array
(
[empresa] => 1
[codigo] => 8
[fornecedor] => 9
[transportadora] => 3
[situacao] =>
[serie] => 1
[cstat] =>
[tpnf] =>
[finnfe] =>
[modfrete] =>
[qvol] =>
[demi] => 2026-03-27
[dsaient] =>
[dentrada] => 2026-07-21
[hsaient] =>
[vprod] => 359.56
[vdesc] => 0.00
[vnf] => 359.56
[vbc] => 0.00
[vicms] => 0.00
[vfrete] => 0.00
[vseg] => 0.00
[vbcst] => 0.00
[vst] => 0.00
[vii] => 0.00
[vipi] => 0.00
[vpis] => 0.00
[vcofins] => 0.00
[voutro] => 0.00
[pesob] => 0.00
[cfop] =>
[nnf] => 215
[natop] => DEVOLUCAO DE COMPRA P/ COMERCIALIZACAO
[chnfe] => 24260340785834000174550010000002151141267039
[obs] =>
[gibs_vibs] => 0.00
[gcbs_vcbs] => 0.00
[pmarkup] => 30.00
[vmarkup] =>
[pesol] => 0.00
)
2. &key1=1&key2=8 |
| #10 |
classes\listpage_master.php:61 |
ListPage_Master->preparePage |
N/A |
| #11 |
classes\runnerpage.php:2001 |
RunnerPage->displayMasterTableInfo |
N/A |
| #12 |
classes\listpage.php:420 |
ListPage->addCommonHtml |
N/A |
| #13 |
classes\listpage_simple.php:184 |
ListPage_Simple->addCommonHtml |
N/A |
| #14 |
classes\listpage.php:2179 |
ListPage->prepareForBuildPage |
N/A |
| #15 |
compras_itens_list.php:154 |
Global scope |
N/A |