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

[Martin Chilvers]

G'day,

I've searched the archives but can't find any reference to this - 
forgive me if I missed it!

I am installing MyExperiment on Windows XP (service pack 3) for the VRIC 
project, and I've managed to get everything together, until, that is, I 
try to create the database tables with rake.

rake db:migrate

gives the error shown below...

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)...

Any ideas?

Martin

L:\Documents and Settings\mc5\My 
Documents\Repositories\MyExperiment\trunk>rake db:migrate
(in L:/Documents and Settings/mc5/My 
Documents/Repositories/MyExperiment/trunk)
L:/Documents and Settings/mc5/My 
Documents/Repositories/MyExperiment/trunk/config/boot.rb:20:Warning: 
Gem::SourceIndex#search support for St
ring patterns is deprecated, use #find_name
== CreateUsers: migrating 
=====================================================
-- create_table(:users)
   -> 0.0000s
== CreateUsers: migrated (0.0000s) 
============================================

== CreateProfiles: migrating 
==================================================
-- create_table(:profiles)
   -> 0.0160s
== CreateProfiles: migrated (0.0160s) 
=========================================

== CreatePictures: migrating 
==================================================
-- create_table(:pictures)
   -> 0.0000s
-- execute("ALTER TABLE `pictures` MODIFY `data` MEDIUMBLOB")
   -> 0.0150s
== CreatePictures: migrated (0.0150s) 
=========================================

== CreateFriendships: migrating 
===============================================
-- create_table(:friendships)
   -> 0.0160s
== CreateFriendships: migrated (0.0160s) 
======================================

== CreateMemberships: migrating 
===============================================
-- create_table(:memberships)
   -> 0.0000s
== CreateMemberships: migrated (0.0000s) 
======================================

== CreateRelationships: migrating 
=============================================
-- create_table(:relationships)
   -> 0.0000s
== CreateRelationships: migrated (0.0000s) 
====================================

== CreateNetworks: migrating 
==================================================
-- create_table(:networks)
   -> 0.0000s
== CreateNetworks: migrated (0.0000s) 
=========================================

== CreateMessages: migrating 
==================================================
-- create_table(:messages)
   -> 0.0000s
== CreateMessages: migrated (0.0000s) 
=========================================

== CreateContributions: migrating 
=============================================
-- create_table(:contributions)
   -> 0.0150s
== CreateContributions: migrated (0.0150s) 
====================================

== CreatePolicies: migrating 
==================================================
-- create_table(:policies)
   -> 0.0000s
== CreatePolicies: migrated (0.0000s) 
=========================================

== CreatePermissions: migrating 
===============================================
-- create_table(:permissions)
   -> 0.0160s
== CreatePermissions: migrated (0.0160s) 
======================================

== CreateBlobs: migrating 
=====================================================
-- create_table(:blobs)
   -> 0.0000s
== CreateBlobs: migrated (0.0000s) 
============================================

== CreateWorkflows: migrating 
=================================================
-- create_table(:workflows)
   -> 0.0160s
== CreateWorkflows: migrated (0.4060s) 
========================================

== CreateBookmarks: migrating 
=================================================
-- create_table("bookmarks", {:force=>true})
   -> 0.0000s
-- add_index("bookmarks", ["user_id"], {:name=>"fk_bookmarks_user"})
   -> 0.0160s
== CreateBookmarks: migrated (0.0160s) 
========================================

== CreateRatings: migrating 
===================================================
-- create_table("ratings", {:force=>true})
   -> 0.0160s
-- add_index("ratings", ["user_id"], {:name=>"fk_ratings_user"})
   -> 0.0150s
== CreateRatings: migrated (0.0310s) 
==========================================

== 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)