# API Error (Array to string conversion)

**URL:** <https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890>\
**Category:** Miscellaneous\
**Created:** [December 6, 2015, 9:20am UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890 "2015-12-06T09:20:44Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![allensandiego](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@allensandiego](https://community.dreamfactory.com/u/allensandiego)\
**Post date:** [December 6, 2015, 9:20am UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/1 "2015-12-06T09:20:44Z")

</div>

Hi,

I keep getting this error when I try to click Update on the Schema tab. First I try to create a table. Then added the following columns:

created\_by - user\_id\_on\_create  
last\_updated\_by - user\_id\_on\_update  
created\_on - timestamp\_on\_create  
last\_updated\_on - timestamp\_on\_update

At this point I am still able to Update the table. Next I added a column id as binary with length of 36. Then I set this as the primary key and delete the example column that was created by default. When I hit Update now I get the error API Error Array to string conversion.

Not sure what to do at this point. Appreciate any assistance.

Thanks,  
Allen

---

<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 10, 2015, 3:20pm UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/2 "2015-12-10T15:20:40Z")

</div>

Can you post the whole error?

Also, what type of sql database is this? What version of DreamFactory and what operating system/install type?

---

<div class="post-metadata">

**Author:** ![allensandiego](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@allensandiego](https://community.dreamfactory.com/u/allensandiego)\
**Post date:** [December 11, 2015, 1:48am UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/3 "2015-12-11T01:48:11Z")

</div>

> [@formerstaff](#):
>
> Can you post the whole error?
> 
> Also, what type of sql database is this? What version of DreamFactory and what operating system/install type?

That’s the only error message that comes up on the notification box on the upper left side of the page whenever I click Update.

Details of my DF below:

Admin Application Version: 2.0.1  
DreamFactory Version: 2.0.1

Using MySQL 5.6 with Amazon RDS.

Although, just wanted to point out that other than this error, everything seems to be working okay.

Thanks,  
Allen

---

<div class="post-metadata">

**Author:** ![allensandiego](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@allensandiego](https://community.dreamfactory.com/u/allensandiego)\
**Post date:** [December 16, 2015, 1:00am UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/4 "2015-12-16T01:00:24Z")

</div>

Here’s a screen shot for reference.

![](https://cdck-file-uploads-canada1.s3.dualstack.ca-central-1.amazonaws.com/flex035/uploads/dreamfactory/original/1X/0832fc9b7cb66d1887d87b89a06fa0d5c60daa55.PNG)

---

<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 17, 2015, 3:41pm UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/5 "2015-12-17T15:41:01Z")

</div>

You should update to 2.0.2

I attempted to recreate your schema and had no trouble with the binary field.

---

<div class="post-metadata">

**Author:** ![allensandiego](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@allensandiego](https://community.dreamfactory.com/u/allensandiego)\
**Post date:** [December 18, 2015, 1:32am UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/6 "2015-12-18T01:32:17Z")

</div>

> [@formerstaff](#):
>
> You should update to 2.0.2
> 
> I attempted to recreate your schema and had no trouble with the binary field.

Hi.

Can you provide steps on how to update to 2.0.2? I can’t see anywhere in the Admin UI where I can do this.

Thanks,  
Allen

---

<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 18, 2015, 1:34pm UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/7 "2015-12-18T13:34:59Z")

</div>

Sure.  
Installation and Upgrade instructions are available on the wiki. [https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade](https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade)

---

<div class="post-metadata">

**Author:** ![allensandiego](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@allensandiego](https://community.dreamfactory.com/u/allensandiego)\
**Post date:** [December 19, 2015, 12:41am UTC](https://community.dreamfactory.com/t/api-error-array-to-string-conversion/1890/8 "2015-12-19T00:41:33Z")

</div>

> [@formerstaff](#):
>
> Sure.Installation and Upgrade instructions are available on the wiki. [Installation - DreamFactory](https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade)

Upgrading to 2.0.2 fixed the issue.

UPDATE: Had encountered others issues upon doing this. Some of which are:

1. Email service stopped working. Getting the error.

> “message”: “Error processing password reset. Argument 1 passed to DreamFactory\Library\Utility\ArrayUtils::get() must be of the type array, null given, called in /opt/bitnami/apps/dreamfactory/htdocs/vendor/dreamfactory/df-core/src/Services/Email/BaseService.php on line 69 and defined”

1. Role service access particularly the Component was set to blank.

Will try to re-install DF 2.0.2

UPDATE: Re-installing DF 2.0.2 fixed all issues.

Regards,  
Allen
