2009/7/4 Rajendra Bayana <[email protected]>: > > hi , i used the folllwing command to scaffold, > > G:\my\webblog>ruby script/generate scaffold webblog id:integer > title:string body > :text created_at:datetime > > after when i migrate with the follwing command > > rake db:migrate > > i got the error as > > (in G:/my/webblog) > == 1 CreateWebblogs: migrating > ================================================ > -- create_table(:webblogs) > rake aborted! > Mysql::Error: You have an error in your SQL syntax; check the manual > that corres > ponds to your MySQL server version for the right syntax to use near > '(11), `titl > e` varchar(255) DEFAULT NULL, `body` text DEFAULT NULL, `created_at` ' > at line 1 > : CREATE TABLE `webblogs` (`id` int(11) DEFAULT NULL auto_increment > PRIMARY KEY( > 11), `title` varchar(255) DEFAULT NULL, `body` text DEFAULT NULL, > `created_at` d > atetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL) ENGINE=InnoDB > > (See full trace by running task with --trace) > > > i got this error, can anyone help me?? > what can i do ,pls suggest me. i am using mysql 5.2 and rails 2.0.2 and > ruby 1.8.6. > --
I am not sure if either of these will fix the problem but: First I would upgrade to the latest rails (2.3.2) Second it is not necessary to specify id in the scaffold command. Colin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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-talk?hl=en -~----------~----~----~----~------~----~------~--~---
