Doctrine setParameter makes MySQL error

Asked Feb 14 '16 at 19:04

Active May 18 '16 at 17:49

Viewed 72 times

This is my SQL query in Doctrine:

 ->andwhere("f.yearEvents LIKE :yearEvents")
 ->setParameter("yearEvents", $param)

When param has more than 10 signs, I get this error:

General error: 2008 MySQL client ran out of memory

When param has less than 10 signs everything works just fine!

Anyone have an idea? I can't figure out where the problem is. My DB is small.

edited May 18 '16 at 17:49

luchaninov

asked Feb 14 '16 at 19:04

S1arl

1

Not a MySQL guy, but it looks like this may help you: http://stackoverflow.com/questions/1178736/mysql-maximum-memory-usage – Nick Feb 14 '16 at 19:30
1

you could try to add an index on your yearEvents field – Hakim Feb 15 '16 at 10:43
Try to look at generated SQL: $qb->getQuery()->getSQL() and run it directly – luchaninov May 18 '16 at 17:51

0 Answers0