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