ID: 30409 Comment by: fscii at yahoo dot com Reported By: david at inspiredthinking dot co dot uk Status: Open Bug Type: MySQLi related Operating System: Windows XP SP2 PHP Version: 5CVS-2004-10-12 (dev) New Comment:
My case is that I am only trying to use php_mysqli.dll to interface with MySql 5.x (using php 5.02). I was under the impression you do not require to use both php_mysqli.dll AND php_mysql.dll - I am of the opinion you use either one or the other. I get the message: Fatal error: Call to undefined function mysql_connect()) When I attempt to use php_mysql.dll I get the EXPECTED error of: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" (which is the entire reason PHP suggests php_mysqli.dll). I have no intention of converting the MySQL 5 passwords to the old method of storage and php is of no use to me if it does not work with MySQL. Please advise! Previous Comments: ------------------------------------------------------------------------ [2004-10-23 16:16:43] atiara at covad dot net I stand corrected. I rechecked my php.ini and discovered that I had not disabled to the loading of php_mysqli.dll. Upon disabling that particular module I was able to resume normal execution. Therefore, my case is no different from that originally reported by david. ------------------------------------------------------------------------ [2004-10-23 16:03:22] atiara at covad dot net I have encountered difficulties which I believe are related to this bug as it is reported herein. I am trying to install PHP 5.0.02 on a Windows 2k/IIS 5.x Server. Prior to this installation the target environment was executing with PHP 4.xxx. In this pre-installation environment I was also executing MySQL 4.0.18-nt, the same version that I am now having problems with in the context of PHP 5.0.02. I am failing when I reach the point of making a mysql_connect(...) call. I am fairly certain that I have caused this to fail by simply attempting to load with only the mysql library (i.e. sans mysqli). I hope this has been of some use to you. Good luck with your efforts to get this particular version of php up and running with MySQL. In my own particular case, PHP is of no use to me unless it will interface with my MySQL database. ------------------------------------------------------------------------ [2004-10-12 14:34:46] david at inspiredthinking dot co dot uk Description: ------------ Loading both MySQL & MySQLi using extension= causes loss of MySQL functions (Fatal error: Call to undefined function mysql_connect()). When the MySQLi entry is removed - the MySQL functions are defined. Reproduce code: --------------- PHP.INI extension=php_mysql.dll extension=php_mysqli.dll This fails with the above: $dblink = mysql_connect($db_host, $db_user, $db_pass); PHP.INI extension=php_mysql.dll ;extension=php_mysqli.dll Success: $dblink = mysql_connect($db_host, $db_user, $db_pass); Expected result: ---------------- Described above. Actual result: -------------- Fatal error: Call to undefined function mysql_connect() ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30409&edit=1
