Install/upgrade Error: BLOB/TEXT column 'alt_body'

[HerrClauseman]

Hello,

I'm running:
Server Software Microsoft-IIS/6.0
MySQL version 5.0.27
PHP-version 5.2.0

I am the server's admin, so I have direct access to everything. A new
virtual server (web site) was created in IIS and the mySQL DB was copied
to test the upgrade without messing with my active photoblog.

I was attempting to upgrade from 1.5 to 1.6 and received the following
error after pressing the 'upgrade' button:

Error: BLOB/TEXT column 'alt_body' can't have a default value

After receiving the above error, I wanted to see if a new install of 1.6
would go through successfully. When attempting a clean install I received
the following, but notice the same error at the end.

Remember your data:
Username: *****
Password: *****

# Automatic creation of tables

# Table pixelpost_config created ...
# Table pixelpost_categories created ...
# Table pixelpost_pixelpost created ...
# Table pixelpost_comments created ...
# Table pixelpost_visitors created ...
# Table pixelpost_config populated ...
# Table pixelpost_version created ...
# Table pixelpost_catassoc created ...
# Added timezone support ...
# Added customizable category links support ...
# Added HTML notification email support ...
# Added email in comments support ...
# Longer name field in comments support ...
# Longer url field in comments support ...
# Added indexes to pixelpost_config ...
# Added indexes to pixelpost_categories ...
# Added indexes to pixelpost_comments ...
# Added indexes to pixelpost_pixelpost ...
# Added indexes to pixelpost_visitors ...
# Comment moderation feature is added ...
# Addon ON/OFF switchs are added ...
# Switch ON/OFF for time stamps is added ...
# Switch ON/OFF for visitor booking is added ...
# Table pixelpost_version updated to 1.5Beta.
Error: BLOB/TEXT column 'alt_body' can't have a default value
--------------

After this I wanted to see if a 1.5 install would still work in the new virtual
server and db and it did, just fine. I'm not a coder or anything, but this has
got to be a bug in the 1.6 install. I'll try to assist in any possible...

Regards,
Jason

[Dennis]

Hi there, this is a problem with certain MySQL versions under windows.

The fix:
includes/create_tables.php, line 501
<- ADD `alt_body` TEXT DEFAULT '' NOT NULL ") or die("Error: ". mysql_error());
-> ADD `alt_body` TEXT NOT NULL ") or die("Error: ". mysql_error());

[Dennis]

-> ADD `alt_body` TEXT NOT NULL ") or die("Error: ". mysql_error());

It might be better to remove the NOT NULL part in this case too.