[Oscailt] Problems with Oscailt+Windows

[chekov]

spleen wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> chekov ha scritto:
>> Hi Spleen,
>>
>> You need to edit php.ini to set the following php variable:
>> short_open_tag = 1
>> http://ie.php.net/manual/en/ini.core.php#ini.short-open-tag
> 
> Thank you very much chekov :D it was on "Off" and now the installation
> has started.
> 
> But now I can't run the db installation because it has this problem:
> 
> ///start///
> 2. Database Installation Failed
> 
>     * adding topics table
>     * adding regions table
>     * adding types table
>     * adding languages table
>     * adding stories table - BLOB/TEXT column 'story_content' can't have
> a default value 1101
>     * Operation failed
> ///end///
> 
> And naturally if i edit install.php in this way:
> $quit_on_fail = true; --> $quit_on_fail = false;
> then appear a lot of warning messages.
> 
> 
> But really at first time I've tried (after putting short_open_tag = 1)
> the installation shut down itself in another moment (i think I've put on
> "false" the $quit_on_fail, but I'm not sure). After this:
> 
> ///start///
> *DataBase Installation*
> 
>     * adding topics table
>     * adding regions table
>     * adding types table
>     * adding languages table
>     * adding stories table - BLOB/TEXT column 'story_content' can't have
> a default value 1101
>     * adding comments table - BLOB/TEXT column 'comment_content' can't
> have a default value 1101

Hi Spleen,

This is an issue when mysql5 is used as its default setting is to enforce strict
sql.

You can either turn strict sql off - recommended: the easiest way to do this is
to add the line:
sql-mode=""
to your my.ini file.  More on sql modes here: see how to here
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html)

Or else you can edit the file objects/installdatabase.inc and wherever you see
the following:
story_content mediumtext NOT NULL default '',

just remove the bit "default ''" - do this for each line where you get an error
message (just search for the column name from your error message).

Chekov