PHP reports MySQL client API lags behind MySQL server version

[knc]

Server information for my account indicates:

PHP Version: 5.2.2
MySQL Version: 5.0.45

The information returned from phpinfo() indicates the MySQL client API version is 4.1.11.

The MySQL developer site (http://dev.mysql.com/downloads/connector/php/) is clear about minimizing problems by matching the client API to the server version. We recommend to use the MySQL Client API version that matches the MySQL Server version. For the MySQL Server 5.0.27 you should use the MySQL Client API 5.0.27 (mysql.com download) but not 4.1.7 (php.net download). For example, mysqli_stmt_bind_param() will fail when you try to access a DECIMAL column on a MySQL 5.0.27 server if you use old versions of the MySQL Client API, like the php.net downloads do.

Will PowWeb be doing an update to correct this?

[dmacminn]

Probably nothing new at present -- we are maintaining support for both MySQL 4 and MySQL 5 (although only MySQL 5 is currently available on Powweb) in our environment -- the versions we provide are tested to work across our platform -- the versions are reviewed periodically.

[spamjim]

Would it not make sense that if Powweb is fully migrated from MySQL 4, it should update the API for PHP? Why are you supporting something that is not currently available on Powweb?

[dmacminn]

That would assume that the system that supports Powweb is fully migrated from MySQL 4 ... just because it isn't currently available for new accounts and you aren't hosted on a server that has MySQL 4 at this point doesn't mean that its completely gone from the system ...

AS I noted, it will not likely happen immediately, CGI/MySQL upgrades generally happen once a year, and if memory serves that happened in late March/April of this year for CGI and began in June/July for MySQL hardware and Version 5 introduction... and it was no picnic...

Since support for MySQL4 is likely to be discontinued by the MySQL team at that point, and presumably all other webhosts will migrate to MySQL 5 over the next year (for those that are still operating MySQL 4), support for MySQL 4 is most likely to disappear some time next year...

Until then, we'll likely continue to use the existing versions/interfaces ...