#30409 [Opn->Fbk]: MySQLi Loaded with MySQL Causes loss of MySQL Functions

ID: 30409 Updated by: edink@php.net Reported By: david at inspiredthinking dot co dot uk -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Windows XP SP2 PHP Version: 5CVS-2004-10-12 (dev) New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2004-10-28 23:56:03] fscii at yahoo dot com I would like to add that a call to phpinfo() shows that php_mysqli.dll is actually being loaded - no clue why its totally ineffective!? MysqlI Support enabled Client API version 4.1.3-beta MYSQLI_SOCKET /tmp/mysql.sock Directive Local Value Master Value mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.reconnect Off Off ------------------------------------------------------------------------ [2004-10-28 23:46:42] fscii at yahoo dot com 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! ------------------------------------------------------------------------ [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