2008 Mysql client run out of memory !?!

2001-08-21 Thread Patrice Garbe
Hello, I use PHP 4.0.6 with mySQL 3.23.40 and I have the error 2008 (client run out of memory) performing this query : select i2f.item_id, i2f.value, f.id from features as f, item2feature as i2f, items as i where i.scat_id = '244d713abba5f2ffb8d0ba8c858111ef' and i.id = i2f.item_id and f.id =

Re: 2008 : MySQL client run out of memory

2001-08-09 Thread Patrice Garbe
Hello, I tried with unbuffered queries and It doesn't solve the problem at all I have an weird error performing "select id from categories where name = 'Hifi'". The error is now : '0 : ' (nothing). There's an error but it is not defined ?!? Note that only the crashing query is unbuffer

Re: 2008 : MySQL client run out of memory

2001-08-09 Thread Werner Stuerenburg
> ini_set("memory_limit", "16M"); >> >> in your script. Otherwise, it may be a loop that keeps allocating >> memory until it crahes. It this is the case, you won't get it >> through allocating more memory. >> >> Patrice Garbe schrieb am D

Re: 2008 : MySQL client run out of memory

2001-08-09 Thread Patrice Garbe
memory_limit", "16M"); > > in your script. Otherwise, it may be a loop that keeps allocating > memory until it crahes. It this is the case, you won't get it > through allocating more memory. > > Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42: > >

Re: 2008 : MySQL client run out of memory

2001-08-09 Thread Werner Stuerenburg
ag, 9. August 2001, 12:43:42: > Hello, > I have this error (2008 : MySQL client run out of memory) performing > a request in a PHP script. > However that request works perfectly under phpMyAdmin ! > I tried to do a lot of mysql_free_result() in my script (because there are a >

2008 : MySQL client run out of memory

2001-08-09 Thread Patrice Garbe
Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think