ID: 4759
Comment by: no at email dot com
Reported By: cnewbill at onewest dot net
Status: Closed
Bug Type: MySQL related
Operating System: Redhat Linux 6.2
PHP Version: 4.0.0 Release
New Comment:
cnewbill at onewest dot net said
> First, when configuring your build for PHP4
> you MUST specify a MySQL directory
Would you guys PLEASE be so kind to update the INSTALL file shipped
with php to include this information? That would help about 1000 hours
of useless bitching.
Previous Comments:
------------------------------------------------------------------------
[2000-06-11 03:48:29] cnewbill at onewest dot net
Bingo!
I am using mod_auth_mysql as well. I didn't think that the folks over
at MySQL qould have a blunder like that, we have used MySQL for long
time and are very pleased with it and PHP. Keep up the good work.
------------------------------------------------------------------------
[2000-06-10 18:52:39] zeev at cvs dot php dot net
The solution you found is most probably accurate; The reason for it is
not that PHP's MySQL support is incompatible with your server, but that
you most probably have at least one other Apache module that uses MySQL
(e.g., mod_auth_mysql or PHP 3.0), which is linked against the local
MySQL client library. PHP 4.0 being linked to its bundlied MySQL
client library in the same process as another module linked with the
local MySQL client library would result in various problems, such as
this.
------------------------------------------------------------------------
[2000-06-03 20:06:08] rasmus at cvs dot php dot net
This bundled libmysql code should be completely backward compatible
with older versions of MySQL. If you have found a compatibility
issue,
please report it to the MySQL folks.
------------------------------------------------------------------------
[2000-06-03 07:54:14] cnewbill at onewest dot net
Okay here is the skinny on what I found out. First, when configuring
your build for PHP4 you MUST specify a MySQL directory. This is where
the problem is generated. If you do not the configure script assumes
that it can use its libmysql, which is included with the PHP4 source in
ext/mysql/libmysql. The version of MySQL it is using is 3.23.10-alpha
which is NOT the version I am running. There-in lies the goof up.
------------------------------------------------------------------------
[2000-06-01 18:51:10] cnewbill at onewest dot net
Forgot two important details, the query still executes properly and it
does not happen when doing a SELECT statement only when using UPDATE
and DELETE and probably anything else that doesn't actually return a
result set.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/4759
--
Edit this bug report at http://bugs.php.net/?id=4759&edit=1