Then It is not a memory problem for "ini_set()" didn't work.
It always crashes at the same point.

Mysql doc says :
ERROR 2008: MySQL client ran out of memory

note that the error refers to the MySQL client mysql. The reason for this
error is simply that the client does not have enough memory to store the
whole result. 

But as I said the query works with phpMyAdmin and is performed several
times in the script with free_results() after each performing.

Patrice

Le jeu, 09 aoû 2001, vous avez écrit :
> If it is a memory problem, try for example
>
> 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 Donnerstag, 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 lot of requests) but I doesn't work and I think It is useless.
> >
> > I looked on the PHP site to see if there's not a bug but I didn't
> > configured my PHP with the --enable-memory-limit option.
> > I have the version 4.0.6 with the mysql built-in support. Note that I
> > first compiled PHP with the external mysql support and I had the same
> > error.
> >
> > What's the problem ? How to find the cause ?
> > I tried a debugger called Body but It is so slow that I could die before.
> >
> > Thank you
> >
> > Patrice
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to