Rajendra Bayana | 4 Jul 12:16

scaffolding


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.
--

-- 
Posted via http://www.ruby-forum.com/.


Gmane