[Rails-core] Re: Mysql and non null text columns

2008-10-29 Thread Jeff
This turned out to be a change in behaviour in MySQL. Downgrading from 5.0.51a to 5.0.27 solved the problem but that left me unsatisified. I had moved the database from production to the dev box via mysqldump, letting it handle the schema creation. That was the issue. On the production box, I dum

[Rails-core] Re: Mysql and non null text columns

2008-10-04 Thread Frederick Cheung
On 4 Oct 2008, at 03:39, Jeff wrote: > > 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

[Rails-core] Re: Mysql and non null text columns

2008-10-04 Thread Michael Koziarski
Jeff wrote: > 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: INSE

[Rails-core] Re: Mysql and non null text columns

2008-10-04 Thread Jeff
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_

[Rails-core] Re: Mysql and non null text columns

2008-09-14 Thread Frederick Cheung
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 p

[Rails-core] Re: Mysql and non null text columns

2008-09-09 Thread Frederick Cheung
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 anyt

[Rails-core] Re: Mysql and non null text columns

2008-09-09 Thread Jeremy Kemper
On Tue, Sep 9, 2008 at 9:47 AM, Frederick Cheung <[EMAIL PROTECTED]> wrote: > We've been having some problems with mysql 5 and not null text columns > (versions 5.0.67, 5.0.51a and 5.0.51b) > > Mysql reports the columns as having a default of null (the column is > actually a not null) which causes