So, i just upgraded to PHP 5.2.5, and I thought I'd get the latest mysql too. Big mistake.
Now I have mysql5 and PHP5, but the php-mysql package is compiled against mysql 4 client libraries.
WAIT! You've heard this before!?
What I don't get is why does nobody have any errors with this setup? Am I the only one who gets these?
Warning: mysqli::prepare() [function.mysqli-prepare]: All data must be fetched before a new statement prepare takes place
and
Warning: mysqli_stmt::bind_result() [function.mysqli-stmt-bind-result]: Server returned unknown type 246. Probably your client library is incompatible with the server version you use!
I haven't dug deep enough to figure out the exact reason why, but I believe there is a documented mysql bug when connecting to a 5 server with 4.1 client libraries.
So, can I have php-mysql package compiled against mysql 5, or the source rpm, or mysql 4.1 server in the ART repositories? Or instructions on how to backport to mysql 4.1?
http://bugs.mysql.com/bug.php?id=9491
"Due to fact that 4.1 client library does not support MYSQL_TYPE_NEWDECIMAL added in 5.0, and there is no way to disable new DECIMAL type on server side the only possible solution to avoid reported problem will be relink application that uses PS C API with the client library from 5.0 server distribution."
Sorry if I missed a FAQ or something, but *every* hit I find is just people freaking out about the different version numbers w/o any actual errors and nobody offers a real solution other than, shut up it's okay to mix 4.1 and 5.0.
