[jifty-devel] jifty beginner problem

[xu zhou]

HI
I just followed the Jifty::Manual::Tutorial and when I went to

jifty schema --setup

I got such messages:


WARN - Prototype mismatch: sub Jifty::View::Declare::Helpers::wrapper
($$) vs none at
/usr/local/share/perl/5.8.8/Jifty/View/Declare/Helpers.pm line 368.
WARN - Subroutine wrapper redefined at
/usr/local/share/perl/5.8.8/Jifty/View/Declare/Helpers.pm line 332.
WARN - Application schema has no version in the database.
WARN - Automatically creating your database.
INFO - Generating SQL for application Mywebblog...
INFO - Using Mywebblog::Model::Post, as it appears to be new.
WARN - DBD::mysql::st execute failed: BLOB/TEXT column 'title' can't
have a default value at
/usr/local/share/perl/5.8.8/Jifty/DBI/Handle.pm line 554.
WARN - Mywebblog::Handle=HASH(0x9f5abbc) couldn't execute the query
'CREATE TABLE posts (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  title text NULL DEFAULT 'Untitled post' ,
  body text NULL  ,
  PRIMARY KEY (id)
)
' at /usr/local/share/perl/5.8.8/Jifty/DBI/Handle.pm line 578.
error creating table Mywebblog::Model::Post: Couldn't execute the
query 'CREATE TABLE posts (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  title text NULL DEFAULT 'Untitled post' ,
  body text NULL  ,
  PRIMARY KEY (id)
)
'BLOB/TEXT column 'title' can't have a default value at
/usr/local/share/perl/5.8.8/Jifty/Record.pm line 699.

No tables were created in the database mywebblog
Dose anybody know what is the problem?