Forum: Ruby on Rails MySQL Text type failure

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
9f4a65c520a69cd357d830661e172272?d=identicon&s=25 JannaB (Guest)
on 2009-05-12 21:10
(Received via mailing list)
This is very peculiar --  I am using (I am using MySQL 5.0.27-
community) If I create a table with the following schema.....

CREATE TABLE `associates` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(16) NOT NULL default '',
 ...
 ...
  `tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

things in AS work swimmingly. However, if I add a column (anywhere in
the table, here I am just putting at the end) that is a text type,
call it   `notes` (or even make, say varchar(500) ) as follows:

CREATE TABLE `associates` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(16) NOT NULL default '',
 ...
 ...
  `tstamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
  `notes` text NOT NULL,
  PRIMARY KEY  (`id`),
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

When I go to do an edit on the table, regardless of whether I add any
data to the notes field or not, and I save it, It won't come back up
when I go to edit it again (I get a 500 error). It saves the values
into the db correctly when I go directly into the db and look at the
changes -- but it wont come back up when I go to edit it without
generating
a 500 error.

I am using the latest version of Rails (2.3) , Ruby and
ActiveScaffold. Has anyone
experienced anything like this trying to use a large text field with
MySQL ?
thank you, Janna B
6883e5ef03484d4fcef507d7b4f1d243?d=identicon&s=25 Matt Jones (Guest)
on 2009-05-13 19:13
(Received via mailing list)
Never heard of that happening - can you post a stack track from the
log where it gets the 500?

--Matt Jones
This topic is locked and can not be replied to.