ID: 11832
Updated by: derick
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: *General Issues
Operating system:
PHP Version: 4.0.6
Assigned To:
Comments:
This does look like a normal thing. Your script simply uses too mch memory.
Can you increase the memory_limit to a higher value:
memory_limit = 16M
This should solve the problem if you are fetching too much rows.
Derick
Previous Comments:
---------------------------------------------------------------------------
[2001-07-02 06:20:46] [EMAIL PROTECTED]
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 9 bytes) in
[somewhere]/mysql.php on line 8
Apache 1.3.19, PHP 4.0.6 configured with:
./configure --prefix=/opt/php4 --with-apxs=/opt/apache/bin/apxs
--with-pgsql=/opt/pgsql --with-mysql=/opt/mysql/ --with-openssl=/usr/local/ssl/
--with-imap=/opt/imap --with-gettext --with-zlib --with-dom --with-gd
--enable-gd-imgstrttf --enable-inline-optimization --with-xml --with-ttf --with-gdbm
--with-mm --enable-versioning --enable-trans-sid --enable-magic-quotes
--enable-safe-mode --enable-sockets --enable-sysvsem --enable-sysvshm --enable-shmop
--enable-calendar --enable-exif --enable-memory-limit
Might "--enable-memory-limit" be the culprit?
(It's a production system and I can not play much with it)
mysql.php worked correctly with php 4.0.5
mysql.php:
<?php
function getData($query)
{
global $host, $user, $password, $db;
//echo $query."<br>";
$conn = mysql_connect ($host, $user, $password);
$result = mysql_db_query($db, $query);
while($row = mysql_fetch_array($result))
$aux[] = $row;
mysql_free_result($result);
return $aux;
};
function putData($query)
{
global $host, $user, $password, $db;
$conn = mysql_connect ($host, $user, $password);
$result = mysql_db_query($db, $query);
return $query;
};
?>
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=11832&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
