php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #7079 mysql_query() and mysql_affected_rows() always return false
Submitted: 2000-10-07 12:12 UTC Modified: 2001-01-13 09:41 UTC
From: jan at jan-dittberner dot de Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.2 OS: Linux-Mandrake 7.2 cooker
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jan at jan-dittberner dot de
New email:
PHP Version: OS:

 

 [2000-10-07 12:12 UTC] jan at jan-dittberner dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-13 00:23 UTC] cynic@php.net 
have you experienced this error with newer versions of PHP?
 [2001-01-13 09:41 UTC] cynic@php.net 
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)
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri Jul 04 14:01:35 2025 UTC