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?

score 3 · Accepted Answer · edited May 23 '17 at 12:30

3

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 :

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

edited May 23 '17 at 12:30

Community

1
1

answered Dec 08 '09 at 05:16

Pascal MARTIN

395,085
80
655
663

yes this worked SET PASSWORD FOR 'username'@'hostmask' = PASSWORD('thepassword') – user217631 Dec 08 '09 at 06:02
Great news ;-) ;; And nice to see more and more questions about PHP 5.3 ! Have fun ! – Pascal MARTIN Dec 08 '09 at 06:12

score 0 · Answer 2 · answered Dec 08 '09 at 05:04

0

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.

answered Dec 08 '09 at 05:04

Dumb Guy

3,336
21
23

my php app requires a function from 5.3, this is great – user217631 Dec 08 '09 at 05:40

php 5.3.1 and PDO

2 Answers2