[Oscailt] Problems with Oscailt+Windows

[Anthony]

>     * adding stories table - BLOB/TEXT column 'story_content' can't have
> a default value 1101

Hi Spleen,

I'm no expert in installing PHP / MySQL applications but I was curious
about your error as I had successfully installed Oscailt 3 on a Win2k
machine without the above errors. I did a little research and found the
following MySQL bug report: http://bugs.mysql.com/bug.php?id=19498

I upgraded MySQL to the most recent free production version for Windows
(5.0.37-community-nt) and I was able to duplicate your errors.

I was able to get around this problem by making a few small edits to the
objects/installdatabase.inc file: For each field with a data type of
text (or mediumtext), I removed the default value when the table was
being created. e.g in line 108 I changed it from
story_summary text NOT NULL default ''
to
story_summary text NOT NULL

>From what I've read in the bug report above, this should be safe enough
but I'm no expert on Oscailt and I don't have time to test these edits
and can't offer any guarantees that this won't cause further problems.
However some of the PHP coders on this list will probably know more
about this.

-- 
Anthony
(One of the Indymedia Ireland Internet Collective)