# Database API error when query related data and the relationship name is on pascal case

**URL:** <https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788>\
**Category:** REST API\
**Created:** [November 18, 2015, 1:16am UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788 "2015-11-18T01:16:48Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jose\_Manuel\_Ojeda](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jose_manuel_ojeda/32/1055_2.png) [@Jose\_Manuel\_Ojeda](https://community.dreamfactory.com/u/Jose_Manuel_Ojeda)\
**Post date:** [November 18, 2015, 1:16am UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/1 "2015-11-18T01:16:49Z")

</div>

Hi

I have posted this issue on the .net sdk, but I think is more an API problem, when I query a table with a relationship and the relationship name is on pascal casing it fails on retrieve the data

the name of the relationship is “imagedetail\_by\_PostBase”, here is the request [http://localhost:80/api/v2/LaGuiaApi/\_table/postbase?related=imagedetail\_by\_PostBase](http://localhost:80/api/v2/LaGuiaApi/_table/postbase?related=imagedetail_by_PostBase)

here is the response

{  
“error”: {  
“context”: null,  
“message”: “The Response content must be a string or object implementing \_\_toString(), “boolean” given.”,  
“code”: 500,  
“trace”: [  
“0 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(15548): Symfony\Component\HttpFoundation\Response-\>setContent(false)”,  
“1 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(15061): Illuminate\Http\Response-\>setContent(Array)”,  
“2 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(15070): Symfony\Component\HttpFoundation\Response-\>\_\_construct(Array, 200, Array)”,  
“3 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\vendor\dreamfactory\df-core\src\Utility\ResponseFactory.php(155): Symfony\Component\HttpFoundation\Response::create(Array, 200, Array)”,  
“4 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(17595): DreamFactory\Core\Utility\ResponseFactory::sendResponse(Object(DreamFactory\Core\Utility\ServiceResponse), NULL, NULL, ‘\_table/postbase’)”,  
“5 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(17553): DreamFactory\Http\Controllers\RestController-\>handleService(‘v2’, ‘LaGuiaApi’, ‘\_table/postbase’)”,  
“6 [internal function]: DreamFactory\Http\Controllers\RestController-\>handleGET(‘v2’, ‘LaGuiaApi’, ‘\_table/postbase’)”,  
“7 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(8842): call\_user\_func\_array(Array, Array)”,  
“8 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(8911): Illuminate\Routing\Controller-\>callAction(‘handleGET’, Array)”,  
“9 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9553): call\_user\_func(Object(Closure), Object(Illuminate\Http\Request))”,  
“12 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9535): call\_user\_func(Object(Closure), Object(Illuminate\Http\Request))”,  
“17 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(8892): Illuminate\Pipeline\Pipeline-\>then(Object(Closure))”,  
“18 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(8877): Illuminate\Routing\ControllerDispatcher-\>callWithinStack(Object(DreamFactory\Http\Controllers\RestController), Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), ‘handleGET’)”,  
“19 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(7831): Illuminate\Routing\ControllerDispatcher-\>dispatch(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request), ‘DreamFactory\\Ht…’, ‘handleGET’)”,  
“20 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(7802): Illuminate\Routing\Route-\>runWithCustomDispatcher(Object(Illuminate\Http\Request))”,  
“21 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9535): call\_user\_func(Object(Closure), Object(Illuminate\Http\Request))”,  
“26 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(7456): Illuminate\Pipeline\Pipeline-\>then(Object(Closure))”,  
“27 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(7444): Illuminate\Routing\Router-\>runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))”,  
“28 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(7429): Illuminate\Routing\Router-\>dispatchToRoute(Object(Illuminate\Http\Request))”,  
“29 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9553): call\_user\_func(Object(Closure), Object(Illuminate\Http\Request))”,  
“32 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9545): call\_user\_func\_array(Array, Array)”,  
“35 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9545): call\_user\_func\_array(Array, Array)”,  
“38 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9545): call\_user\_func\_array(Array, Array)”,  
“41 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9545): call\_user\_func\_array(Array, Array)”,  
“44 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9545): call\_user\_func\_array(Array, Array)”,  
“47 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9545): call\_user\_func\_array(Array, Array)”,  
“50 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\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 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(9535): call\_user\_func(Object(Closure), Object(Illuminate\Http\Request))”,  
“55 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(2251): Illuminate\Pipeline\Pipeline-\>then(Object(Closure))”,  
“56 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\bootstrap\cache\compiled.php(2234): Illuminate\Foundation\Http\Kernel-\>sendRequestThroughRouter(Object(Illuminate\Http\Request))”,  
“57 C:\Bitnami\dreamfactory-2.0.1-0\apps\dreamfactory\htdocs\public\index.php(53): Illuminate\Foundation\Http\Kernel-\>handle(Object(Illuminate\Http\Request))”,  
“58 {main}”  
]  
}  
}

here is the schema of the table

{  
“name”: “postbase”,  
“is\_view”: false,  
“label”: “Postbase”,  
“plural”: “Postbases”,  
“description”: null,  
“alias”: null,  
“field”: [  
{  
“name”: “Oid”,  
“label”: “Oid”,  
“description”: null,  
“type”: “string”,  
“db\_type”: “char(38)”,  
“length”: 38,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: true,  
“allow\_null”: false,  
“fixed\_length”: true,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: true,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “TypeOfObject”,  
“label”: “TypeOfObject”,  
“description”: null,  
“type”: “string”,  
“db\_type”: “varchar(100)”,  
“length”: 100,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “Name”,  
“label”: “Name”,  
“description”: null,  
“type”: “string”,  
“db\_type”: “varchar(100)”,  
“length”: 100,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “OptimisticLockField”,  
“label”: “OptimisticLockField”,  
“description”: null,  
“type”: “integer”,  
“db\_type”: “int(11)”,  
“length”: 11,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: false,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “GCRecord”,  
“label”: “GCRecord”,  
“description”: null,  
“type”: “integer”,  
“db\_type”: “int(11)”,  
“length”: 11,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: false,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: true,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “ObjectType”,  
“label”: “ObjectType”,  
“description”: null,  
“type”: “reference”,  
“db\_type”: “int(11)”,  
“length”: 11,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: false,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: true,  
“is\_unique”: false,  
“is\_index”: true,  
“ref\_table”: “xpobjecttype”,  
“ref\_fields”: “OID”,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “Description”,  
“label”: “Description”,  
“description”: null,  
“type”: “text”,  
“db\_type”: “text”,  
“length”: null,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “Address”,  
“label”: “Address”,  
“description”: null,  
“type”: “text”,  
“db\_type”: “longtext”,  
“length”: null,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “Lat”,  
“label”: “Lat”,  
“description”: null,  
“type”: “string”,  
“db\_type”: “varchar(100)”,  
“length”: 100,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “Lon”,  
“label”: “Lon”,  
“description”: null,  
“type”: “string”,  
“db\_type”: “varchar(100)”,  
“length”: 100,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: false,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: false,  
“is\_unique”: false,  
“is\_index”: false,  
“ref\_table”: null,  
“ref\_fields”: null,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
},  
{  
“name”: “Commerce”,  
“label”: “Commerce”,  
“description”: null,  
“type”: “string”,  
“db\_type”: “char(38)”,  
“length”: 38,  
“precision”: null,  
“scale”: null,  
“default”: null,  
“required”: false,  
“allow\_null”: true,  
“fixed\_length”: true,  
“supports\_multibyte”: true,  
“auto\_increment”: false,  
“is\_primary\_key”: false,  
“is\_foreign\_key”: true,  
“is\_unique”: false,  
“is\_index”: true,  
“ref\_table”: “postbase”,  
“ref\_fields”: “Oid”,  
“picklist”: null,  
“validation”: null,  
“alias”: null  
}  
],  
“related”: [  
{  
“name”: “imagedetail\_by\_PostBase”,  
“type”: “has\_many”,  
“ref\_table”: “imagedetail”,  
“ref\_fields”: “PostBase”,  
“field”: “Oid”,  
“join”: null  
},  
{  
“name”: “postbase\_by\_Commerce”,  
“type”: “belongs\_to”,  
“ref\_table”: “postbase”,  
“ref\_fields”: “Oid”,  
“field”: “Commerce”,  
“join”: null  
},  
{  
“name”: “xpobjecttype\_by\_ObjectType”,  
“type”: “belongs\_to”,  
“ref\_table”: “xpobjecttype”,  
“ref\_fields”: “OID”,  
“field”: “ObjectType”,  
“join”: null  
},  
{  
“name”: “postbaseattribute\_by\_PostBase”,  
“type”: “has\_many”,  
“ref\_table”: “postbaseattribute”,  
“ref\_fields”: “PostBase”,  
“field”: “Oid”,  
“join”: null  
},  
{  
“name”: “descriptionattribute\_by\_postbaseattribute”,  
“type”: “many\_many”,  
“ref\_table”: “descriptionattribute”,  
“ref\_fields”: “Oid”,  
“field”: “Oid”,  
“join”: “postbaseattribute(PostBase,DescriptionAttribute)”  
},  
{  
“name”: “tagtags\_postbasepostbases\_by\_PostBases”,  
“type”: “has\_many”,  
“ref\_table”: “tagtags\_postbasepostbases”,  
“ref\_fields”: “PostBases”,  
“field”: “Oid”,  
“join”: null  
},  
{  
“name”: “tag\_by\_tagtags\_postbasepostbases”,  
“type”: “many\_many”,  
“ref\_table”: “tag”,  
“ref\_fields”: “Oid”,  
“field”: “Oid”,  
“join”: “tagtags\_postbasepostbases(PostBases,Tags)”  
}  
],  
“primary\_key”: “Oid”,  
“name\_field”: null,  
“access”: 31  
}

---

<div class="post-metadata">

**Author:** ![kimpatro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/kimpatro/32/467_2.png) [@kimpatro](https://community.dreamfactory.com/u/kimpatro)\
**Post date:** [November 18, 2015, 12:55pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/2 "2015-11-18T12:55:07Z")

</div>

Hello @Jose_Manuel_Ojeda, please, when you paste some code, put it within the code style. It’s very exhausting trying to understand a non-indent and non-formatted code.

Which db are you using?

---

<div class="post-metadata">

**Author:** ![kimpatro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/kimpatro/32/467_2.png) [@kimpatro](https://community.dreamfactory.com/u/kimpatro)\
**Post date:** [November 18, 2015, 1:00pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/3 "2015-11-18T13:00:40Z")

</div>

If it’s mysql, maybe could be [this](http://stackoverflow.com/questions/8550789/where-to-change-the-value-of-lower-case-table-names-2-on-windows-xampp) or [that](http://www.toadworld.com/platforms/mysql/w/wiki/6104.tables).

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [November 18, 2015, 5:25pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/4 "2015-11-18T17:25:01Z")

</div>

There is a bug that I found last week with accessing related data. It will not work unless the relationship names are all lowercase. This issue is resolved in the next release (currently scheduled for 11/20.)

---

<div class="post-metadata">

**Author:** ![Jose\_Manuel\_Ojeda](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jose_manuel_ojeda/32/1055_2.png) [@Jose\_Manuel\_Ojeda](https://community.dreamfactory.com/u/Jose_Manuel_Ojeda)\
**Post date:** [November 19, 2015, 2:47am UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/5 "2015-11-19T02:47:23Z")

</div>

> [@formerstaff](#):
>
> t will not work unless the relationshi

I just did a new test with postgres and the same happened so the problem is not related to mysql only is general problem of the database API

---

<div class="post-metadata">

**Author:** ![kimpatro](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/kimpatro/32/467_2.png) [@kimpatro](https://community.dreamfactory.com/u/kimpatro)\
**Post date:** [November 19, 2015, 10:16am UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/6 "2015-11-19T10:16:48Z")

</div>

[http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html](http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html)

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [November 19, 2015, 1:10pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/7 "2015-11-19T13:10:26Z")

</div>

@Jose_Manuel_Ojeda, you are correct this bug is not limited to mysql. As I said it is resolved in the next release, which should be available tomorrow on Github.

---

<div class="post-metadata">

**Author:** ![Jose\_Manuel\_Ojeda](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jose_manuel_ojeda/32/1055_2.png) [@Jose\_Manuel\_Ojeda](https://community.dreamfactory.com/u/Jose_Manuel_Ojeda)\
**Post date:** [November 21, 2015, 10:35pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/8 "2015-11-21T22:35:43Z")

</div>

Hi @drewpearce I guess I will have to wait for the next release of the bitnami installer to see if this is fixed right?

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [November 23, 2015, 2:36pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/9 "2015-11-23T14:36:03Z")

</div>

Bitnami installs can be updated from github, if you are comfortable with git and the command line.  
In windows you’ll need to install a git shell (there are a few of these available.)

The basic update process is copy the htdocs folder. Run git pull, then composer install.

Details here: [https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade](https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade)

FYI, that update referenced above has not yet shipped. Targeting end of the day today.

---

<div class="post-metadata">

**Author:** ![Jose\_Manuel\_Ojeda](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jose_manuel_ojeda/32/1055_2.png) [@Jose\_Manuel\_Ojeda](https://community.dreamfactory.com/u/Jose_Manuel_Ojeda)\
**Post date:** [November 30, 2015, 9:05pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/10 "2015-11-30T21:05:55Z")

</div>

@formerstaff did you upload the new dreamfactory version? any idea when its going to be available as bitnami installer?

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [December 1, 2015, 3:33pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/11 "2015-12-01T15:33:35Z")

</div>

New version didn’t get pushed until last night. It is now live on the master branch ( [https://github.com/dreamfactorysoftware/dreamfactory](https://github.com/dreamfactorysoftware/dreamfactory) )

We have notified Bitnami of the changes and they are working on a package release. I don’t have an ETA on that yet.

---

<div class="post-metadata">

**Author:** ![Jose\_Manuel\_Ojeda](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jose_manuel_ojeda/32/1055_2.png) [@Jose\_Manuel\_Ojeda](https://community.dreamfactory.com/u/Jose_Manuel_Ojeda)\
**Post date:** [December 1, 2015, 11:04pm UTC](https://community.dreamfactory.com/t/database-api-error-when-query-related-data-and-the-relationship-name-is-on-pascal-case/1788/12 "2015-12-01T23:04:39Z")

</div>

Thanks @drewpearce ill give it a try
