Hi I'm using this Laravel Package https://github.com/nicolaslopezj/searchable
This is my code:
$RelatedProducts = Product::where('product_status', 1)
->search($product->product_name)
->with('images')
->take(10)->get();
Its working fine on my Local Machine (XAMPP-Windows) but not on my Linux Shared Hosting
When I'm searching for something big it returning this error:
I think I have to change the SQL config file, but on shared hosting they won't allow it, is there any other way to do this?
SQLSTATE[HY000]: General error: 1436 Thread stack overrun: 230160 bytes used of a 262144 byte stack, and 32000 bytes needed.
Solution
You should raise the thread_stack to 512k, which is usually enough to avoid this problem permanently.
Backup and Edit my.cnf, locate thread_stack directive and modify to 512k
Restart MySQL service to reload new configuration
Run your PHP script or test again
for more information : Mysql bug report