php 5.3.1 and PDO

Question

I am getting PDO::__construct(): OK packet 6 bytes shorter than expected in latest PHP 5.3.1, any idea or fixes?

Answer 1

I'm assuming you're using MySQL since this error usually occurs with in. This indicates some sort of incompatibility between PHP and MySQL. Without knowing the exact situation (version numbers, upgrades done, etc.) it's hard to diagnose.

I really shouldn't say this, but in many cases downgrading to PHP 5.2.x will fix the problem instantly.

Answer 2

If you are using the new mysqlnd driver (which is often the case with PHP 5.3, as it's one of the new stuff introduced with 5.3), you cannot connect to a MySQL database using the old-passwords system.

See, for instance :

• Resolving the "OK packet 6 bytes shorter than expected"
• MySQL PHP incompatibility.
• Backward Incompatible Changes

Not sure it's what is causing the problem in your case, but that's one common MySQL related thing, with PHP 5.3...