Re: [Myexperiment-discuss] Problem installing MyExperiment on Windows XP...

[Danius Michaelides]

On Wed, 29 Jul 2009, Martin Chilvers wrote:

> Could it be a MySQL versioning issue? I have version 5.1.36 since I couldn't 
> find the recommended 5.0.51a in the archives (for Windows at least)...

http://dev.mysql.com/downloads/mysql/5.0.html#win32

?

> == CreateComments: migrating 
> ==================================================
> -- create_table("comments", {:force=>true})
> rake aborted!
> Mysql::Error: #42000BLOB/TEXT column 'comment' can't have a default value: 
> CREATE TABLE comments (`id` int(11) DEFAULT NULL auto_increment P
> RIMARY KEY, `title` varchar(50) DEFAULT '', `comment` text DEFAULT '', 
> `created_at` datetime NOT NULL, `commentable_id` int(11) DEFAULT 0 NO
> T NULL, `commentable_type` varchar(15) DEFAULT '' NOT NULL, `user_id` int(11) 
> DEFAULT 0 NOT NULL) ENGINE=InnoDB
>
> (See full trace by running task with --trace)

you might have to do this:

1. find your mysql server's ini file, will be "MySQL\MySQL Server 5.0\my.ini" 
in default.
2. locate this line:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
3. add a "#" to the head:
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
4. restart mysql server
5. run rake db:migrate, it should succeed this time
6. change the my.ini file back and restart mysql server

(From:

http://www.redmine.org/issues/771

)

I dont develop on windows but maybe other myexperiment developers who've
used windows ran into this?

Danius