|
|
Posted by Anonymous on 01/10/08 18:14
"Robin S." wrote:
>
> I've used phpinfo() to confirm settings for mySQL on our host server,
> and it's not returning accurate info.
>
> phpinfo() returns a mySQL client API version of 3.23.54 (uselss for
> me), where as a SELECT VERSION() query on the mySQL database returns
> version 5.0.27 (exactly what we need). I think there's something wrong
> with the mySQL library in PHP.
Does your provider still use PHP4? Then this API version should be
expected. IIRC that version was statically linked into PHP. At least in
the windows version of PHP, I don't know about Linux/Unix versions.
But that shouldn't be a big problem, even this stoneage API is still
compatible with the latest MySQL. You just have to remember to use the
old-passwords option on the server or you will get the 'Client does not
support authentication protocol' error when connecting to the database,
but that doesn't seem to be your problem.
And of course you can't use any of the new MySQL features (transactions,
prepared statements, etc.) but you couldn't use these with the mysql API
anyway, you would have to update to PHP5 and use the mysqli API instead
to use all the new and cool features. If your host hasn't updated to
PHP5 yet tell them to do so, PHP4 is considered deprecated and is
unsupported as of 1.1.2008. If they are already using PHP5 they must
have a stoneage extension or client library somewhere in their search
path that gets loaded instead of the up to date one.
It looks to me like a configuration problem on your hosts side.
P.S.: You can connect to the MySQL server of your host from your local
computer? That's a security nightmare! You should consider switching
hosts in any case.
Bye!
Navigation:
[Reply to this message]
|