search

dreamfactorysoftware / dreamfactory

DreamFactory API Management Platform
https://www.dreamfactory.com
Apache License 2.0
1.52k stars 311 forks source link

PostgreSQL 9.6 Error SQLSTATE[22023] #126

Open slickvik opened 7 years ago

slickvik commented 7 years ago

Error trying to get all tables from API Docs. Timezone value is empty in the service created. I have tried both UTC and EST with no luck. Restarted machine each time. The Database is set at UTC. Using Azure Bitnami Image connecting to PostgreSQL 9.6.

{ "error": { "context": null, "message": "SQLSTATE[22023]: Invalid parameter value: 7 ERROR: invalid value for parameter "TimeZone": """, "code": "22023", "trace": [ "0 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connectors/PostgresConnector.php(48): PDOStatement->execute()", "1 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(11559): Illuminate\Database\Connectors\PostgresConnector->connect(Array)", "2 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}()", "3 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(924): call_user_func(Object(Closure))", "4 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(792): Illuminate\Database\Connection->getPdo()", "5 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(677): Illuminate\Database\Connection->reconnectIfMissingConnection()", "6 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php(349): Illuminate\Database\Connection->run('SELECT table_na...', Array, Object(Closure))", "7 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Database/Schema/PostgresSchema.php(511): Illuminate\Database\Connection->select('SELECT table_na...')", "8 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Database/Schema/Schema.php(872): DreamFactory\Core\Database\Schema\PostgresSchema->findTableNames('public', true)", "9 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Database/Schema/Schema.php(841): DreamFactory\Core\Database\Schema\Schema->getCachedTableNames(true, false)", "10 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-sqldb/src/Services/SqlDb.php(193): DreamFactory\Core\Database\Schema\Schema->getTableNames('', true, false)", "11 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Resources/BaseDbTableResource.php(141): DreamFactory\Core\SqlDb\Services\SqlDb->getTableNames('', false)", "12 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(574): DreamFactory\Core\Resources\BaseDbTableResource->getResources()", "13 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Resources/BaseDbTableResource.php(365): DreamFactory\Core\Components\RestHandler->handleGET()", "14 [internal function]: DreamFactory\Core\Resources\BaseDbTableResource->handleGet()", "15 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(327): call_user_func(Array)", "16 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(185): DreamFactory\Core\Components\RestHandler->processRequest()", "17 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(243): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '')", "18 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseDbService.php(117): DreamFactory\Core\Components\RestHandler->handleResource(Array)", "19 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Components/RestHandler.php(160): DreamFactory\Core\Services\BaseDbService->handleResource(Array)", "20 /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/BaseRestService.php(89): DreamFactory\Core\Components\RestHandler->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '_table')", "21 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17202): DreamFactory\Core\Services\BaseRestService->handleRequest(Object(DreamFactory\Core\Utility\ServiceRequest), '_table')", "22 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17163): DreamFactory\Http\Controllers\RestController->handleService('v2', 'pados', '_table')", "23 [internal function]: DreamFactory\Http\Controllers\RestController->handleGET('v2', 'pados', '_table')", "24 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9138): call_user_func_array(Array, Array)", "25 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9200): Illuminate\Routing\Controller->callAction('handleGET', Array)", "26 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9180): Illuminate\Routing\ControllerDispatcher->call(Object(DreamFactory\Http\Controllers\RestController), Object(Illuminate\Routing\Route), 'handleGET')", "27 [internal function]: Illuminate\Routing\ControllerDispatcher->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "28 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "29 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17379): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "30 [internal function]: DreamFactory\Http\Middleware\AccessCheck->handle(Object(Illuminate\Http\Request), Object(Closure))", "31 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "32 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "33 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "34 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "35 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9662): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "36 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9181): Illuminate\Pipeline\Pipeline->then(Object(Closure))", "37 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9168): Illuminate\Routing\ControllerDispatcher->callWithinStack(Object(DreamFactory\Http\Controllers\RestController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'handleGET')", "38 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8238): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), 'DreamFactory\Ht...', 'handleGET')", "39 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(8225): Illuminate\Routing\Route->runController(Object(Illuminate\Http\Request))", "40 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7939): Illuminate\Routing\Route->run(Object(Illuminate\Http\Request))", "41 [internal function]: Illuminate\Routing\Router->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "42 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "43 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "44 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9662): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "45 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7940): Illuminate\Pipeline\Pipeline->then(Object(Closure))", "46 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7931): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))", "47 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(7921): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))", "48 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2419): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))", "49 [internal function]: Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http{closure}(Object(Illuminate\Http\Request))", "50 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "51 /opt/bitnami/apps/dreamfactory/htdocs/app/Http/Middleware/AuthCheck.php(183): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "52 [internal function]: DreamFactory\Http\Middleware\AuthCheck->handle(Object(Illuminate\Http\Request), Object(Closure))", "53 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "54 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "55 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "56 /opt/bitnami/apps/dreamfactory/htdocs/vendor/barryvdh/laravel-cors/src/HandleCors.php(34): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "57 [internal function]: Barryvdh\Cors\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))", "58 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "59 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "60 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "61 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(17483): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "62 [internal function]: DreamFactory\Http\Middleware\FirstUserCheck->handle(Object(Illuminate\Http\Request), Object(Closure))", "63 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "64 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "65 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "66 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(13188): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "67 [internal function]: Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))", "68 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "69 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "70 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "71 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(11678): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "72 [internal function]: Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))", "73 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "74 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "75 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "76 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(12927): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "77 [internal function]: Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))", "78 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "79 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "80 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "81 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(12864): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "82 [internal function]: Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))", "83 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "84 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "85 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "86 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(3286): Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "87 [internal function]: Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))", "88 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9677): call_user_func_array(Array, Array)", "89 [internal function]: Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Illuminate\Http\Request))", "90 /opt/bitnami/apps/dreamfactory/htdocs/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "91 [internal function]: Illuminate\Routing\Pipeline->Illuminate\Routing{closure}(Object(Illuminate\Http\Request))", "92 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(9662): call_user_func(Object(Closure), Object(Illuminate\Http\Request))", "93 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2366): Illuminate\Pipeline\Pipeline->then(Object(Closure))", "94 /opt/bitnami/apps/dreamfactory/htdocs/bootstrap/cache/compiled.php(2350): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))", "95 /opt/bitnami/apps/dreamfactory/htdocs/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))", "96 {main}" ] } }

drewpearce commented 6 years ago

filed as DF-813 I don't have an ETA on this, but you can work around this by either manually editing the sql config table in the system database to remove the timezone field, or recreate the service without adding the timezone field at all -- it is an optional field.