Re: PHP 4.0 Bug #7079 Updated: mysql_query() and mysql_affected_rows() always return false

the problem was caused by another apache module (mod_auth_mysql) which was linked against an older version of mysql client libraries I resolved the problem by recompiling this module. I don't have the problem now (tested with php-4.0.3pl1) Sorry I forgot to report that ... Regards, Jan Dittberner Bug Database schrieb: > > ID: 7079 > Updated by: cynic > Reported By: jan@jan-dittberner.de > Old-Status: Open > Status: Feedback > Bug Type: MySQL related > Assigned To: > Comments: > > have you experienced this error with newer versions of PHP? > > Previous Comments: > --------------------------------------------------------------------------- > > [2000-10-07 12:12:41] jan@jan-dittberner.de > I use the current php-4.0.2-4mdk RPM package from Mandrakesoft (maintainer Jean-Michel Dault > <jmdault@mandrake.com>). > > If I do an INSERT or UPDATE in an opened database, mysql_query() always return 0 (false) even > if the transaction was successful and the correct values are stored in the db. > > The same problem for mysql_affected_rows(), it return 0 even if there are > 1 or more rows altered in the database. > > Apache is 1.3.12 > MySQL is 3.23.23 > > I use the ZendOptimizer for php 4.0.2 > > --------------------------------------------------------------------------- > > Full Bug description available at: http://bugs.php.net/?id=7079