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

ID: 7079 Updated by: cynic Reported By: jan@jan-dittberner.de Old-Status: Feedback Status: Closed Bug Type: MySQL related Assigned To: Comments: user feedback: 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) Previous Comments: --------------------------------------------------------------------------- [2001-01-13 00:23:00] cynic@php.net have you experienced this error with newer versions of PHP? --------------------------------------------------------------------------- [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