Hello.
I didn't find any similar problem in bugs.mysql.com and bugs.php.net. To exclude inconsistence with Apache compile PHP as a command line program and check your queries. May be you should turn to PHP developers. >I recently upgraded the MySQL server from 4.0.15 to 4.1.7, without >significant problems. But I continued to use PHP-4.3.9 linked against >the old MySQL 4.0.15 on the webservers for some time. Everything went >ok, up until the point when I tried linking PHP-4.3.9 against >MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows >'/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a >whole lot of Segmentation Faults in the Apache error log. Also, I >have noticed in the PHP error log that a lot of MySQL queries aren't >succesfully made (usually the error message is 'unable to save result >set'). "Lindsay" <[EMAIL PROTECTED]> wrote: >unning those queries by hand, in a mysql console yields a valid >row(s), but the table header is completely messed up. Traced the >problem to those queries being cached, so I ran a 'reset query >cache'. Then those queries executed successfully, but I'm still >getting Apache segmentation faults. >Here are some details: >On the MySQL server I have FreeBSD 4.10-STABLE running. MySQL 4.1.7 >was compiled from ports with the command line: > >make DB_DIR=/db/mysql WITH_LINUXTHREADS=yes OVERWRITE_DB=no >BUILD_OPTIMIZED=yes BUILD_STATIC=yes >The webservers are running FreeBSD 4.10-STABLE as well, Apache/1.3.33 >having PHP-4.3.9 compiled as a static module. PHP's configure line >is: > ./configure --prefix=/usr/local/php --enable-track-vars >--enable-trans-sid --disable-path-info-check --enable-memory-limit >--without-pear --with-apache=../apache_1.3.33 >--with-config-file-path=/usr/local/apache/conf/ --enable-safe-mode >--with-curl --with-mysql=/usr/local/mysql-4.1.7 >--with-jpeg-dir=/usr/local/jpeg-6b/ >--with-png-dir=/usr/local/libpng-1.2.5/ >--with-ttf --with-pdflib --with-gd --enable-gd-native-ttf >--with-zlib-dir=/usr > >Any idea what could lead to this incompatibility between PHP using >the 4.1.7 MySQL library and the MySQL 4.1.7 server, incompatibility >which doesn't exist between the same MySQL 4.1.7 server and PHP >linked against MySQL 4.0.15 library? >Thanks, >>bogdan -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
