El Tuesday 12 May 2009 20:12:15 JannaB escribió:
> This is very peculiar -- I don't know if it is AS-specific with MySQL
> or not, or, a version of MySQL I am using (I am using MySQL 5.0.27-
> community) If I create a table wit hthe 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 in AS.

When you get a 500 error you must look at your log file (log/development.log in 
development environment, log/production.log in production environment). At the 
end of that file you will see a backtrace and the raised exception.

>
> I am using the latest version of Rails, Ruby and AS. Has anyone
> experienced anything like this trying to use a large text field in
> AS ? thank you, Janna B
> 

-- 
Sergio Cambra .:: entreCables S.L. ::.
Nicolás Guillén 6, locales 2 y 3. 50.018 Zaragoza
T) 902 021 404 F) 976 52 98 07 E) [email protected]


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to