ID: 38841 Updated by: [EMAIL PROTECTED] Reported By: albertbrian at gmail dot com -Status: Assigned +Status: Bogus Bug Type: MySQLi related Operating System: OpenSuSE 10.0 PHP Version: 5.1.6 Assigned To: georg New Comment:
Not a PHP problem. Don't mix different versions. Previous Comments: ------------------------------------------------------------------------ [2006-10-04 03:10:25] albertbrian at gmail dot com Okay I think I've figured out a clue to solve this problem. a) For MySQL 5.0.x: libmysqlclient.so.15 is required b) For PHP 5.1.x rpm package (OSS 10.0) was compiled to "decide" by itself: libmysqlclient.so.14 "has to" be used >From MySQL.Com, you can download "Shared compatibility libraries (4.x, 5.x libs in same package)" which contains many version of libmysqlclient.so. Think of it, if MySQL 5.0.x use libmysqlclient.so.15 but PHP 5.1.x was compiled to request libmysqlclient.so.14 only, it would make many troubles. My English is not very well, I hope everyone could understand what I mean. To solve this, just re-compile PHP 5.1.x rpm package (which is for OSS 10.0) to use libmysqlclient.so.15, or use the version as same as MySQL (in case users can choose diff MySQL version) ------------------------------------------------------------------------ [2006-09-27 13:37:46] [EMAIL PROTECTED] mysql_set_character_set is a symbol defined in all MySQL 4.1 and 5.0 client libraries on my system (and i have quite a few). It is nothing that is only conditionally compiled in either (afaict.) My educated guess on this would be: some other apache module uses an older (<= 4.0) mysql client library? What happens if you try to run the PHP CLI binary and try to load ext/mysqli into that? ------------------------------------------------------------------------ [2006-09-17 07:56:59] [EMAIL PROTECTED] Please leave the status as it is, I'd like MySQL people to take a look at it. The question is why mysql_set_character_set() is not exported in libmysqlclient.so, while it's expected to be. ------------------------------------------------------------------------ [2006-09-16 00:44:35] albertbrian at gmail dot com Temporarily close this to do more investigation. ------------------------------------------------------------------------ [2006-09-16 00:37:32] albertbrian at gmail dot com Thank Judas. My bad, I do not really understand meaning of "what you are supposed to be using if you choose the server_apache_SuSE_Linux_10.0 repository". Can you please make it more clear ? Thanks. Currently, I temporarily uninstall mysqli extension. ------------------------------------------------------------------------ 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/38841 -- Edit this bug report at http://bugs.php.net/?id=38841&edit=1