ID: 35536 User updated by: nevis2us at infoline dot su Reported By: nevis2us at infoline dot su -Status: Bogus +Status: Open Bug Type: MySQL related Operating System: Linux Gentoo PHP Version: 4.4.1 New Comment:
MySQL 5.0 Reference Manual -> 2.10.2. Upgrading from Version 4.1 to 5.0 -> C API Changes: Incompatible change: ... This error occurs because the 4.1 client libraries do not support the new MYSQL_TYPE_NEWDECIMAL type value added in 5.0 ... I do not see you handle either MYSQL_TYPE_NEWDECIMAL or FIELD_TYPE_NEWDECIMAL anywhere in php-4.1.1 source. mysqli extension in php-5.0.5 seems to be aware of this new type. But wasn't it obvious the problem reported is about mysql extension? Did you even bother to try? Previous Comments: ------------------------------------------------------------------------ [2005-12-04 22:42:32] [EMAIL PROTECTED] I can't think of a way that makes the same code work for me and makes it fail for you, and I'm sure your PHP receives wrong data from the client library, so it's definitely NOT PHP issue. ------------------------------------------------------------------------ [2005-12-04 22:36:41] nevis2us at infoline dot su I've read the upgrading guide. Thanks. The problem is I've tried it on fresh install of 5.0.16 after rebuilding related PHP modules. So this is not client incompatibility issue. Unfortunately. I'm using an apache 2 module. Does it make any difference? ------------------------------------------------------------------------ [2005-12-04 22:14:32] [EMAIL PROTECTED] Still can't reproduce it and your SQL code doesn't add any value. There is a known incompatibility between MySQL 4.1 client and 5.0 server, so please report that to MySQL AB. ------------------------------------------------------------------------ [2005-12-04 22:03:56] nevis2us at infoline dot su Actually the first thing I did. The Client API version is 5.0.16 (mysql_get_client_info) The server is 5.0.16-log (mysql_get_server_info) ------------------------------------------------------------------------ [2005-12-04 21:39:27] [EMAIL PROTECTED] Round 2: please check the version number of mysqlclient used with PHP. ------------------------------------------------------------------------ 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/35536 -- Edit this bug report at http://bugs.php.net/?id=35536&edit=1