Re: [PHP-DB] 2008 : MySQL client run out of memory
I thought I was an answer to my question...I'm disappointed. Anyway did you try make clean before make ? But theses parse errors are strange. You should check (if you not already did so) your gcc version and if all the gcc components are installed. I had the same problem compiling linuxthreads and It was because my system wasn't completely installed. Le jeu, 09 aoû 2001, vous avez écrit : I am trying to install PHP 4.0.5 on previous version of php 4.01 on cobalt raq 4server. we are getting following error cut and paste from linux terminal __ Making all in mysql make[2]: Entering directory `/home/src/php-4.0.5/ext/mysql' Making all in libmysql make[3]: Entering directory `/home/src/php-4.0.5/ext/mysql/libmysql' make[4]: Entering directory `/home/src/php-4.0.5/ext/mysql/libmysql' /bin/sh /home/src/php-4.0.5/libtool --silent --mode=compile gcc -I. -I/home/src/php-4.0.5/ext/mysql/libmysql -I/home/src/php-4.0.5/main -I/home/src/php-4.0.5 -I/usr/include/apache -I/home/src/php-4.0.5/Zend -I/u sr/include/freetype -I/usr/include/imap -I/usr/interbase/include -I/home/src /php-4.0.5/ext/mysql/libmysql -I/home/src/php-4.0.5/ext/xml/expat/xmltok -I/ home/src/php-4.0.5/ext/xml/expat/xmlparse -I/home/src/php-4.0.5/TSRM -DLINU X=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool=char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 -DXML_BYTE_ORDER=12 -g -O2 -c libmysql.c In file included from libmysql.c:9: global.h:240: warning: redefinition of `uint' /usr/include/sys/types.h:131: warning: `uint' previously declared here global.h:241: warning: redefinition of `ushort' /usr/include/sys/types.h:130: warning: `ushort' previously declared here In file included from libmysql.c:12: m_string.h:180: parse error before `__extension__' m_string.h:180: parse error before `' make[4]: *** [libmysql.lo] Error 1 make[4]: Leaving directory `/home/src/php-4.0.5/ext/mysql/libmysql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/home/src/php-4.0.5/ext/mysql/libmysql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/home/src/php-4.0.5/ext/mysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/src/php-4.0.5/ext' make: *** [all-recursive] Error 1 __ This is the copy of debug.php CONFIGURE: './configure' '--prefix=/usr' '--with-apxs=/usr/sbin/apxs' '--with-gd' '--enable-safe-mode' '--with-config-file-path=/etc/httpd' '--with-mysql' '--with-exec-dir=/usr/bin' '--enable-magic-quotes' '--with-regex=system' '--with-ttf=/usr/lib/libttf.so' '--enable-track-vars' '--enable-xml' '--disable-debug' '--with-interbase=shared' '--with-pgsql=shared' '--with-ldap' '--with-imap' '--enable-sockets' CC: gcc CFLAGS: -g -O2 CPPFLAGS:-DLINUX=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool=cha r -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 CXX: CXXFLAGS: INCLUDES:-I/usr/include/apache -I$(top_builddir)/Zend -I/usr/include/fr eetype -I/usr/include/imap -I/usr/interbase/include -I/home/src/php-4.0.5/ex t/mysql/libmysql LDFLAGS: LIBS: -lldap -llber -lttf -lgd -lresolv -lm -ldl -lcrypt -lnsl -lreso lv DLIBS: -lc-client SAPI: apache PHP_RPATHS: uname -a: Linux www.hikanoo.com 2.2.14C11 #2 Wed Jun 28 00:55:51 PDT 2000 i586 unknown gcc -o conftest -g -O2 -DLINUX=2 -DMOD_SSL=206104 -DMOD_PERL -DUSE_PERL_SSI -Dbool =char -DHAS_BOOL -DEAPI -DBIG_SECURITY_HOLE -DCOBALT_RAQ_LED -DSUPPORT_UTF8 conftest.c -lldap -llber -lttf -lgd -lresolv -lm -ldl -lcrypt -lnsl -lresol v 15 /usr/bin/ld: cannot find -lgd collect2: ld returned 1 exit status === regards, sandeep Indianic Infotech Limited 91-79-6404208/09/10 -- PHP Database 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]
Re: [PHP-DB] 2008 : MySQL client run out of memory
Not at all. The exact error is : 2008 : MySQL client run out of memory On the mysql online support they say It may happen when a query returns to much rows. But It's not the case. Moreover the query works with phpMyAdmin, which gives me a bit of hope... That's all. Le jeu, 09 aoû 2001, vous avez écrit : hello patrice, please cut paste exact error here.. is this related to script timeout bye sandeep - Original Message - From: Patrice Garbe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:53 PM Subject: [PHP-DB] 2008 : MySQL client run out of memory Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a 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 -- PHP Database 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] -- PHP Database 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]
Re: [PHP-DB] 2008 : MySQL client run out of memory
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 unbuffered so there's no problem with mysql_num_rows(). Le jeu, 09 aoû 2001, vous avez écrit : guess: try mysql_unbuffered_query . . . also im assuming you arent doing a limit on the query where phpmyadmin is . . . -- PHP Database 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]
