Bug with Mysql ENUM in schema


#1

Hi,
We start to use dreamfactory with this version :
Database Version: 1.9.0
DreamFactory Services Platform Version: 1.9.4
Admin Application Version: 1.0.12

and all work great.
When we decide to install dreamfactory on our server we decide to install dreamfactory version 2.0.1 but we have one problem, all table with ENUM in structure are not working, with this error :
The Response content must be a string or object implementing __toString(), “boolean” given.
The full error trace :

{"error":{"context":null,"message":"The Response content must be a string or object implementing __toString(), "boolean" given.","code":500,"trace":["0  /bootstrap/cache/compiled.php(15548): Symfony\\Component\\HttpFoundation\\Response->setContent(false)","1  /bootstrap/cache/compiled.php(15061): Illuminate\\Http\\Response->setContent(Array)","2  /bootstrap/cache/compiled.php(15070): Symfony\\Component\\HttpFoundation\\Response->__construct(Array, 200, Array)","3  /vendor/dreamfactory/df-core/src/Utility/ResponseFactory.php(153): Symfony\\Component\\HttpFoundation\\Response::create(Array, 200, Array)","4  /bootstrap/cache/compiled.php(17595): DreamFactory\\Core\\Utility\\ResponseFactory::sendResponse(Object(DreamFactory\\Core\\Utility\\ServiceResponse), NULL, NULL, '_schema/acquere...')","5  /bootstrap/cache/compiled.php(17553): DreamFactory\\Http\\Controllers\\RestController->handleService('v2', 'toits-atlantiqu...', '_schema/acquere...')","6 [internal function]: DreamFactory\\Http\\Controllers\\RestController->handleGET('v2', 'toits-atlantiqu...', '_schema/acquere...')","7  /bootstrap/cache/compiled.php(8842): call_user_func_array(Array, Array)","8  /bootstrap/cache/compiled.php(8911): Illuminate\\Routing\\Controller->callAction('handleGET', Array)","9  /bootstrap/cache/compiled.php(8891): Illuminate\\Routing\\ControllerDispatcher->call(Object(DreamFactory\\Http\\Controllers\\RestController), Object(Illuminate\\Routing\\Route), 'handleGET')","10 [internal function]: Illuminate\\Routing\\ControllerDispatcher->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))","11  /bootstrap/cache/compiled.php(9553): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))","12  /bootstrap/cache/compiled.php(17848): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","13 [internal function]: DreamFactory\\Http\\Middleware\\AccessCheck->handle(Object(Illuminate\\Http\\Request), Object(Closure))","14  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","15 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","16  /bootstrap/cache/compiled.php(9535): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))","17  /bootstrap/cache/compiled.php(8892): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))","18  /bootstrap/cache/compiled.php(8877): Illuminate\\Routing\\ControllerDispatcher->callWithinStack(Object(DreamFactory\\Http\\Controllers\\RestController), Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'handleGET')","19  /bootstrap/cache/compiled.php(7831): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'DreamFactory\\\\Ht...', 'handleGET')","20  /bootstrap/cache/compiled.php(7802): Illuminate\\Routing\\Route->runWithCustomDispatcher(Object(Illuminate\\Http\\Request))","21  /bootstrap/cache/compiled.php(7455): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))","22 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))","23  /bootstrap/cache/compiled.php(9553): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))","24 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","25  /bootstrap/cache/compiled.php(9535): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))","26  /bootstrap/cache/compiled.php(7456): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))","27  /bootstrap/cache/compiled.php(7444): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))","28  /bootstrap/cache/compiled.php(7429): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))","29  /bootstrap/cache/compiled.php(2304): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))","30 [internal function]: Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))","31  /bootstrap/cache/compiled.php(9553): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))","32  /vendor/barryvdh/laravel-cors/src/HandleCors.php(43): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","33 [internal function]: Barryvdh\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))","34  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","35  /bootstrap/cache/compiled.php(17932): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","36 [internal function]: DreamFactory\\Http\\Middleware\\FirstUserCheck->handle(Object(Illuminate\\Http\\Request), Object(Closure))","37  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","38  /bootstrap/cache/compiled.php(12881): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","39 [internal function]: Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))","40  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","41  /bootstrap/cache/compiled.php(11504): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","42 [internal function]: Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))","43  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","44  /bootstrap/cache/compiled.php(12622): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","45 [internal function]: Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))","46  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","47  /bootstrap/cache/compiled.php(12561): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","48 [internal function]: Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))","49  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","50  /bootstrap/cache/compiled.php(2978): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","51 [internal function]: Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))","52  /bootstrap/cache/compiled.php(9545): call_user_func_array(Array, Array)","53 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))","54  /bootstrap/cache/compiled.php(9535): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))","55  /bootstrap/cache/compiled.php(2251): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))","56  /bootstrap/cache/compiled.php(2234): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))","57  /public/index.php(53): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))","58 {main}"]}}

How can we make ENUM work ?


#2

I’ll have to check with an engineer on this.
Can you provide more detail?
Are the tables with ENUM already created, and you’re just trying to read and write from/to them?