On 22/07/06, Daniel N <[EMAIL PROTECTED]> wrote:
On 7/22/06, Chris Mear <[EMAIL PROTECTED]> wrote: > On 22 Jul 2006, at 7:58 am, Daniel N wrote: > > > ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field 'type' > > doesn't have a default value: INSERT INTO projects (`name`, `id`) > > VALUES ('Active Record', 1) #with different insert statements > > Are you running MySQL 5? > > Someone else reported a similar-sounding problem last year: > > http://lists.rubyonrails.org/pipermail/rails-core/2005-November/ > 000305.html > > Chris > > > _______________________________________________ > Rails-core mailing list > [email protected] > http://lists.rubyonrails.org/mailman/listinfo/rails-coreYes. 5.0.15. I applied the fix suggested on the wordpress site, and It worked. Well except 1 failure that I'll go and track down. Thanx very much for you help :)
It seems to me this isn't really a fix. The columns should either allow nulls, have a default value or have a value in the fixtures. Turning off strict mode to get around a valid constraint in the schema seems a strange thing to have to do. I'll look into changing the mysql test schema to see if it can be fixed to work in strict mode, unless anyone vehemently objects. Tom _______________________________________________ Rails-core mailing list [email protected] http://lists.rubyonrails.org/mailman/listinfo/rails-core
