Arch Linux

maksut

Member

Registered: 2009-02-01

Posts: 3

mysql upgrade problem [SOLVED]

A system upgrade a few days ago broke my php tests. Then I realized that broken tests are all about db (mysql).
The symptom was really weird: prepared statements were not working they supposed to be.

eg. A statement like below, runs without errors but while inserting it changed $foo3's data somehow ( in my case it inserted '1012' instead of '259200' ).
Althought the normal mysqli::query method worked fine.

$stmt->bind_param('iii', $foo1, $foo2, $foo3);

if (!$stmt->execute()) {
    var_dump($stmt->error);
}

I've tried to drop the dabase and create new one, it didn't change anything. Then I've downgraded to these packages and it works
libmysqlclient-5.1.33-1-x86_64.pkg.tar.gz
mysql-5.1.33-1-x86_64.pkg.tar.gz
mysql-clients-5.1.33-1-x86_64.pkg.tar.gz

I writing this to save other people's time (by assuming that this is not a local problem of mine. It wasted my 4 hours).

Cheers,

maksut

Last edited by maksut (2009-06-18 06:46:08)