|
| 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=1&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=1 ) ) ) ) |
| #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=1 ) ) ) ) |
| #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=1 ) ) ) )
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=1 ) ) ) )
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] => 1
)
1. 1 |
| #7 |
classes\controls\ViewLookupWizardField.php:163 |
ViewLookupWizardField->getLookupValues |
0. 1 |
| #8 |
classes\controls\ViewLookupWizardField.php:228 |
ViewLookupWizardField->showDBValue |
0. Array
(
[empresa] => 1
[codigo] => 1
[fornecedor] => 4
[transportadora] => 1
[situacao] => 1
[serie] => 1
[cstat] =>
[tpnf] =>
[finnfe] =>
[modfrete] =>
[qvol] =>
[demi] => 2026-04-09
[dsaient] =>
[dentrada] => 2026-07-10
[hsaient] =>
[vprod] => 5171.00
[vdesc] => 0.00
[vnf] => 5937.63
[vbc] => 0.00
[vicms] => 0.00
[vfrete] => 322.00
[vseg] => 0.00
[vbcst] => 0.00
[vst] => 0.00
[vii] => 0.00
[vipi] => 444.63
[vpis] => 0.00
[vcofins] => 0.00
[voutro] => 0.00
[pesob] => 0.00
[cfop] =>
[nnf] => 270859
[natop] => Venda de mercadoria
[chnfe] => 31260408238299000390550010002708591925726202
[obs] =>
[gibs_vibs] => 4.67
[gcbs_vcbs] => 41.99
[pmarkup] => 10.00
[vmarkup] =>
[pesol] => 0.00
)
1. &key1=1&key2=1
2. 1 |
| #9 |
classes\runnerpage.php:4621 |
RunnerPage->showDBValue |
0. transportadora
1. Array
(
[empresa] => 1
[codigo] => 1
[fornecedor] => 4
[transportadora] => 1
[situacao] => 1
[serie] => 1
[cstat] =>
[tpnf] =>
[finnfe] =>
[modfrete] =>
[qvol] =>
[demi] => 2026-04-09
[dsaient] =>
[dentrada] => 2026-07-10
[hsaient] =>
[vprod] => 5171.00
[vdesc] => 0.00
[vnf] => 5937.63
[vbc] => 0.00
[vicms] => 0.00
[vfrete] => 322.00
[vseg] => 0.00
[vbcst] => 0.00
[vst] => 0.00
[vii] => 0.00
[vipi] => 444.63
[vpis] => 0.00
[vcofins] => 0.00
[voutro] => 0.00
[pesob] => 0.00
[cfop] =>
[nnf] => 270859
[natop] => Venda de mercadoria
[chnfe] => 31260408238299000390550010002708591925726202
[obs] =>
[gibs_vibs] => 4.67
[gcbs_vcbs] => 41.99
[pmarkup] => 10.00
[vmarkup] =>
[pesol] => 0.00
)
2. &key1=1&key2=1 |
| #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 |