# Cannot convert value of type string to integer when joining multiple tables

**URL:** <https://discourse.cakephp.org/t/cannot-convert-value-of-type-string-to-integer-when-joining-multiple-tables/10105>\
**Category:** Need Help\
**Created:** [January 21, 2022, 7:43pm UTC](https://discourse.cakephp.org/t/cannot-convert-value-of-type-string-to-integer-when-joining-multiple-tables/10105 "2022-01-21T19:43:41Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![drtrppr](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/drtrppr/32/1763_2.png) [@drtrppr](https://discourse.cakephp.org/u/drtrppr)\
**Post date:** [January 23, 2022, 2:04pm UTC](https://discourse.cakephp.org/t/cannot-convert-value-of-type-string-to-integer-when-joining-multiple-tables/10105/9 "2022-01-23T14:04:30Z")

</div>

In this case, just (?):

- tablename ‘people’ to ‘peoples’
- fieldname ‘direp\_id’ to people\_id’

> [@Join tables error - need help please](https://discourse.cakephp.org/t/join-tables-error-need-help-please/10070/10):
>
> I offered to my boss to make a simple database system based on CakePHP

So, I guess since user\_looser is building the database, it’s not a problem to do the renaming?

> [@Join tables error - need help please](https://discourse.cakephp.org/t/join-tables-error-need-help-please/10070/10):
>
> I know very little from cakephp but I like it very much.

As I replied in the other post, my advice is to focus on the database and do multiple runs of the bake-command until you’re stuck on functionality (Think you still have to get the subjects into the play?).

There won’t be bugs, code is on the place where it has to be (e.g. joins in models), you can show your boss a first take of the app.

At that point there will be the need for more functionality (e.g. authentication etc.), at that point you can start work on that.

Just pointing to this because I hope you will keep liking CakePHP. Working several days on a join wouldn’t make me happy.

---

_[View the full topic](https://discourse.cakephp.org/t/cannot-convert-value-of-type-string-to-integer-when-joining-multiple-tables/10105)._