Last week my blog was down with some bugs. Here are fixes and some resolutions for those bugs.
The main issue was all about incompatibility between WP 1.5.2 and MySql 5.0.1 on IIS 6. My blog being on windows server with IIS 6 and the server was on move, I had a bit of headache moving around my nameservers and this bug fixing. Hopefully those are the last bug to fix and my blog seem working fine now. Anyway I compiled the following notes for whoever faces the same kind of bugs would fix theirs easily.

Version 1.5.2 is incompatible with mysql version 5.0.15 when installed on a server runing IIS 6.0. This appears to be related to variable type mis-matches that are more strictly enforced by mysql 5 than 4.1.

Error: 1 (The whole blog down with only that message)

Fatal error: Only variables can be passed by reference in …/home/blog/wp-includes/gettext.php on line 66

Fix: Error on function array_shift
search function readint()
Replace line 66 from:

return array_shift(unpack('V', $this->STREAM->read(4)));

to the following:

$tmp = unpack('V', $this->STREAM->read(4));
return array_shift($tmp);

and on in other functions array_shift

Ref: http://wordpress.org/support/topic/39279
http://wordpress.org/support/topic/48398

Error: 2 (Categories down with this message)

Fatal error: Only variables can be passed by reference in …/wp-includes/classes.php on line 629

Fix: Changing line 629 from:

$category = &get_category($this->get('cat'));

to something like:

$crom = $this->get('cat');
$category = &get_category($crom);

Ref: http://trac.wordpress.org/ticket/1614
http://trac.wordpress.org/ticket/1808

Error: 3 (Cannot add comment if you’re not login)

WordPress database error: [Out of range value adjusted for column 'user_id' at row 1]

Fix: Remove STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION from the sql_mode of my.ini

Ref: http://wordpress.org/support/topic/48933
http://wordpress.org/support/topic/48940
forums.eqdkp.com
http://forums.mysql.com/read.php?100,51432,51523
http://moodle.org/mod/forum/discuss.php?d=32071
http://bugs.mysql.com/bug.php?id=14256