Patrice Garbe schrieb am Donnerstag, 9. August 2001, 14:20:04:
> 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.
So look at the difference between phpMyAdmin and your script. I
assume that you put your query into phpMyAdmin and that's it.
In your script, you will obtain the same result when you do the
same, as phpMyAdmin does nothing else than call the usual php
functions.
Therefore, I assume that you will do some other sort of things in
your script, like a huge while loop which eats up memory. It
isn't hard to construct such a thing. You didn't provide your
code, did you?
> 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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
