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 =
PhpMyAdmin writes : 3.23.40-log
Why -log, don't know ?...
Le jeu, 09 aoû 2001, vous avez écrit :
> What version of Mysql is it?
>
> > -Opprinnelig melding-
> > Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]]
> > Sendt: 9. august 2001 19:45
> > Til:
Normally the size can be 2G, 4G or more...
You can check the maximum table size for a table with the myisamchk -dv
table_name or table_file if It doesn't work.
You should have run myisamchk or mysqlcheck (whick worked better for me)
to check your table.
Le jeu, 09 aoû 2001, vous avez écrit :
> H
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
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 use
