I'm seeing a similar issue with mysql 5.0.51. I have a rails 1.2.6 app
deployed on a webhost agains mysql 5.0.27 and it works fine. however
on two different linux boxes, both running mysql 5.0.51, I get the
following error:
Mysql::Error: Column 'title' cannot be null: INSERT INTO boats
(`updated_at`, `kind`, `title`, `length_string`, `description`,
`length`, `hulltype`, `make`, `year`, `published_at`, `user_id`,
`builder`, `description_uses_textile`, `image_id`, `model`,
`specifications`, `created_at`, `state`, `style`) VALUES('2008-10-03
16:24:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4,
NULL, 0, NULL, NULL, '[]', '2008-10-03 16:24:28', 'new', NULL);
Think this is the same issue?
Thanks, I'm at my wits end with this, I can't figure out why it works
on the web host with the SAME sql from AR, but not on a dev box.
Thanks!
On Sep 14, 7:14 am, Frederick Cheung <[EMAIL PROTECTED]>
wrote:
> On 9 Sep 2008, at 18:09, Frederick Cheung wrote:
>
>
>
> > On 9 Sep 2008, at 17:58, Jeremy Kemper wrote:
>
> >>> Does this sound reasonable? Have others run into this ?
>
> >> Yes, sounds good. We do our best to 'just work' with MySQL and this
> >> quirk shouldn't be an exception.
>
> > Cool. I'll patchify it when I'm satisfied that this fix doesn't
> > screw anything up
>
> http://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/10...
>
> One existing test conflicted with the new behaviour, but I do very
> much believe that changing the behaviour is right - mysql is just
> weird in this particular case. Tests pass with mysql/sqlite3/postgres
>
> Fred
>
>
>
> >> Ideally we'd omit unassigned not-null attributes from the INSERT in
> >> the first place.
>
> > Fred
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Core" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---
