search

umarley / seteAPI

BSD 3-Clause "New" or "Revised" License
2 stars 0 forks source link

Erro no Laminas na requisição de custo #67

Closed marcosroriz closed 2 years ago

marcosroriz commented 2 years ago

Erro ao tentar requisitar um custo de uma rota (53384) no município 5201405 GET https://sete.transportesufg.eng.br/custo/5201405/53384

A API está retornando a seguinte mensagem:

{
    "trace": [
        {
            "file": "/var/www/seteAPI/module/Application/src/Entity/SetePG/SeteParametros.php",
            "line": 77,
            "function": "execute",
            "class": "Laminas\\Db\\Adapter\\Driver\\Pdo\\Statement",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/module/Application/src/Entity/SetePG/SeteValidacaoDadosCusto.php",
            "line": 380,
            "function": "getById",
            "class": "Db\\SetePG\\SeteParametros",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/module/Application/src/Entity/SetePG/SeteValidacaoDadosCusto.php",
            "line": 373,
            "function": "processarParametroPrecoMedioCombustivel",
            "class": "Db\\SetePG\\SeteValidacaoDadosCusto",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoModel.php",
            "line": 113,
            "function": "processarParametrosFrotaGeral",
            "class": "Db\\SetePG\\SeteValidacaoDadosCusto",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoModel.php",
            "line": 74,
            "function": "validarDadosCadastrosParaCalculoCusto",
            "class": "Sete\\V1\\Rest\\Custo\\CustoModel",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoResource.php",
            "line": 65,
            "function": "validarParametrosCusto",
            "class": "Sete\\V1\\Rest\\Custo\\CustoModel",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoResource.php",
            "line": 56,
            "function": "processarValidacaoParametrosCusto",
            "class": "Sete\\V1\\Rest\\Custo\\CustoResource",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/AbstractResourceListener.php",
            "line": 181,
            "function": "fetch",
            "class": "Sete\\V1\\Rest\\Custo\\CustoResource",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
            "line": 319,
            "function": "dispatch",
            "class": "Laminas\\ApiTools\\Rest\\AbstractResourceListener",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
            "line": 179,
            "function": "triggerListeners",
            "class": "Laminas\\EventManager\\EventManager",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/Resource.php",
            "line": 549,
            "function": "triggerEventUntil",
            "class": "Laminas\\EventManager\\EventManager",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/Resource.php",
            "line": 500,
            "function": "triggerEvent",
            "class": "Laminas\\ApiTools\\Rest\\Resource",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/RestController.php",
            "line": 493,
            "function": "fetch",
            "class": "Laminas\\ApiTools\\Rest\\Resource",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php",
            "line": 373,
            "function": "get",
            "class": "Laminas\\ApiTools\\Rest\\RestController",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/RestController.php",
            "line": 335,
            "function": "onDispatch",
            "class": "Laminas\\Mvc\\Controller\\AbstractRestfulController",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
            "line": 319,
            "function": "onDispatch",
            "class": "Laminas\\ApiTools\\Rest\\RestController",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
            "line": 179,
            "function": "triggerListeners",
            "class": "Laminas\\EventManager\\EventManager",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php",
            "line": 97,
            "function": "triggerEventUntil",
            "class": "Laminas\\EventManager\\EventManager",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php",
            "line": 307,
            "function": "dispatch",
            "class": "Laminas\\Mvc\\Controller\\AbstractController",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/DispatchListener.php",
            "line": 132,
            "function": "dispatch",
            "class": "Laminas\\Mvc\\Controller\\AbstractRestfulController",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
            "line": 319,
            "function": "onDispatch",
            "class": "Laminas\\Mvc\\DispatchListener",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
            "line": 179,
            "function": "triggerListeners",
            "class": "Laminas\\EventManager\\EventManager",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Application.php",
            "line": 325,
            "function": "triggerEventUntil",
            "class": "Laminas\\EventManager\\EventManager",
            "type": "->"
        },
        {
            "file": "/var/www/seteAPI/public/index.php",
            "line": 73,
            "function": "run",
            "class": "Laminas\\Mvc\\Application",
            "type": "->"
        }
    ],
    "exception_stack": [
        {
            "code": 42703,
            "message": "SQLSTATE[42703]: Undefined column: 7 ERROR:  column \"preco_medio_gasolina\" does not exist\nLINE 1: ...odigo_cidade = 5201405 AND eta.codigo_parametro = PRECO_MEDI...\n                                                             ^",
            "trace": [
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-db/src/Adapter/Driver/Pdo/Statement.php",
                    "line": 212,
                    "function": "execute",
                    "class": "PDOStatement",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Application/src/Entity/SetePG/SeteParametros.php",
                    "line": 77,
                    "function": "execute",
                    "class": "Laminas\\Db\\Adapter\\Driver\\Pdo\\Statement",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Application/src/Entity/SetePG/SeteValidacaoDadosCusto.php",
                    "line": 380,
                    "function": "getById",
                    "class": "Db\\SetePG\\SeteParametros",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Application/src/Entity/SetePG/SeteValidacaoDadosCusto.php",
                    "line": 373,
                    "function": "processarParametroPrecoMedioCombustivel",
                    "class": "Db\\SetePG\\SeteValidacaoDadosCusto",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoModel.php",
                    "line": 113,
                    "function": "processarParametrosFrotaGeral",
                    "class": "Db\\SetePG\\SeteValidacaoDadosCusto",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoModel.php",
                    "line": 74,
                    "function": "validarDadosCadastrosParaCalculoCusto",
                    "class": "Sete\\V1\\Rest\\Custo\\CustoModel",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoResource.php",
                    "line": 65,
                    "function": "validarParametrosCusto",
                    "class": "Sete\\V1\\Rest\\Custo\\CustoModel",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/module/Sete/src/V1/Rest/Custo/CustoResource.php",
                    "line": 56,
                    "function": "processarValidacaoParametrosCusto",
                    "class": "Sete\\V1\\Rest\\Custo\\CustoResource",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/AbstractResourceListener.php",
                    "line": 181,
                    "function": "fetch",
                    "class": "Sete\\V1\\Rest\\Custo\\CustoResource",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
                    "line": 319,
                    "function": "dispatch",
                    "class": "Laminas\\ApiTools\\Rest\\AbstractResourceListener",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
                    "line": 179,
                    "function": "triggerListeners",
                    "class": "Laminas\\EventManager\\EventManager",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/Resource.php",
                    "line": 549,
                    "function": "triggerEventUntil",
                    "class": "Laminas\\EventManager\\EventManager",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/Resource.php",
                    "line": 500,
                    "function": "triggerEvent",
                    "class": "Laminas\\ApiTools\\Rest\\Resource",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/RestController.php",
                    "line": 493,
                    "function": "fetch",
                    "class": "Laminas\\ApiTools\\Rest\\Resource",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php",
                    "line": 373,
                    "function": "get",
                    "class": "Laminas\\ApiTools\\Rest\\RestController",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas-api-tools/api-tools-rest/src/RestController.php",
                    "line": 335,
                    "function": "onDispatch",
                    "class": "Laminas\\Mvc\\Controller\\AbstractRestfulController",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
                    "line": 319,
                    "function": "onDispatch",
                    "class": "Laminas\\ApiTools\\Rest\\RestController",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
                    "line": 179,
                    "function": "triggerListeners",
                    "class": "Laminas\\EventManager\\EventManager",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php",
                    "line": 97,
                    "function": "triggerEventUntil",
                    "class": "Laminas\\EventManager\\EventManager",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Controller/AbstractRestfulController.php",
                    "line": 307,
                    "function": "dispatch",
                    "class": "Laminas\\Mvc\\Controller\\AbstractController",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/DispatchListener.php",
                    "line": 132,
                    "function": "dispatch",
                    "class": "Laminas\\Mvc\\Controller\\AbstractRestfulController",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
                    "line": 319,
                    "function": "onDispatch",
                    "class": "Laminas\\Mvc\\DispatchListener",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-eventmanager/src/EventManager.php",
                    "line": 179,
                    "function": "triggerListeners",
                    "class": "Laminas\\EventManager\\EventManager",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/vendor/laminas/laminas-mvc/src/Application.php",
                    "line": 325,
                    "function": "triggerEventUntil",
                    "class": "Laminas\\EventManager\\EventManager",
                    "type": "->"
                },
                {
                    "file": "/var/www/seteAPI/public/index.php",
                    "line": 73,
                    "function": "run",
                    "class": "Laminas\\Mvc\\Application",
                    "type": "->"
                }
            ]
        }
    ],
    "type": "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html",
    "title": "Internal Server Error",
    "status": 500,
    "detail": "Statement could not be executed (42703 - 7 - ERROR:  column \"preco_medio_gasolina\" does not exist\nLINE 1: ...odigo_cidade = 5201405 AND eta.codigo_parametro = PRECO_MEDI...\n                                                             ^)"
}
umarley commented 2 years ago

@marcosroriz problema resolvido.