# Dreamfactory has bug, Big size parameter Error

**URL:** <https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276>\
**Category:** REST API\
**Created:** [September 30, 2016, 5:22am UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276 "2016-09-30T05:22:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![1112](https://avatars.discourse-cdn.com/v4/letter/1/ba8739/32.png) [@1112](https://community.dreamfactory.com/u/1112)\
**Post date:** [September 30, 2016, 5:22am UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276/1 "2016-09-30T05:22:05Z")

</div>

My English level so low.  
Please understand.

- Database  
MariaDB

- my.cnf  
max\_allowed\_packet = 128M

- procedure  
CREATE PROCEDURE `test`(IN query LONGTEXT)  
BEGIN  
SELECT LENGTH(query);  
END

I try send parameter size 44MB string with mysql library.  
It success.

But i try send parameter size 44MB string with dreamfactory.  
It failed.

So i try send parameter size \<= 10MB string with dreamfactory.  
It success.

2.0.4 and 2.3.0 dreamfactory version both failed.

Help me please.

---

<div class="post-metadata">

**Author:** ![DFCommunityManager](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/dfcommunitymanager/32/887_2.png) [@DFCommunityManager](https://community.dreamfactory.com/u/DFCommunityManager)\
**Post date:** [October 3, 2016, 3:46pm UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276/2 "2016-10-03T15:46:44Z")

</div>

Hello @1112,

Can you send over your POST parameters?

Have you checked out this resource: [https://wiki.dreamfactory.com/DreamFactory/Features/Database/Records#Common\_Parameters\_and\_Usage](https://wiki.dreamfactory.com/DreamFactory/Features/Database/Records#Common_Parameters_and_Usage)

Thanks, I am still looking into this for you.  
@AlexBowen

---

<div class="post-metadata">

**Author:** ![1112](https://avatars.discourse-cdn.com/v4/letter/1/ba8739/32.png) [@1112](https://community.dreamfactory.com/u/1112)\
**Post date:** [October 4, 2016, 1:32am UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276/3 "2016-10-04T01:32:55Z")

</div>

Hello @AlexBowen

Request Param

- Version 2.0.4  
{  
“params”: [  
{  
“name”: “query”,  
“value”: “AAAAAAAAA…”,  
“param\_type”: “IN”,  
“length”: [value Length]  
}  
]  
}

- Version 2.3.0  
{  
“params”: [  
{  
“name”: “query”,  
“value”: “AAAAAAAAA…”  
}  
]  
}

Response Body

- Success (\<= 10MB)  
Length = 10000000

- Failed (\> 10MB)  
Whoops, looks like something went wrong.

---

<div class="post-metadata">

**Author:** ![1112](https://avatars.discourse-cdn.com/v4/letter/1/ba8739/32.png) [@1112](https://community.dreamfactory.com/u/1112)\
**Post date:** [October 10, 2016, 12:57am UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276/5 "2016-10-10T00:57:09Z")

</div>

Hello.

Anyone help me PLEASE!!

---

<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:** [October 10, 2016, 12:52pm UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276/6 "2016-10-10T12:52:49Z")

</div>

This is likely due to PHP settings. Best guess is either max\_execution\_time or memory\_limit need to be increased in php.ini.

What’s the error you get back when it fails?

---

<div class="post-metadata">

**Author:** ![1112](https://avatars.discourse-cdn.com/v4/letter/1/ba8739/32.png) [@1112](https://community.dreamfactory.com/u/1112)\
**Post date:** [October 11, 2016, 3:54am UTC](https://community.dreamfactory.com/t/dreamfactory-has-bug-big-size-parameter-error/3276/7 "2016-10-11T03:54:18Z")

</div>

OOOOOOOHHHHHHH!!!

Thank you @formerstaff !!

I change memory\_limit 128MB -\> 1G.  
Then it Success!

But…  
Why PHP need 1G memory for send 50MB Post Parameter??

It is mystery…