[jifty-devel] Jifty fails to work with MySQL 4.1?

[Henry Baragar]

Agent,

I believe that SQLite does not fully implement the SQL standard, where mysql 
(and others) do.  Hence, the pain you are experiencing.

The problem is that 'key' is a reserved word in SQL and may not be used as a 
column name.

Regards,
Henry

On Saturday, December 09 2006 10:22 pm, Agent Zhang wrote:
> Hello,
>
> The SQL statements generated by Jifty is not compatible with MySQL 4.1?
>
> My models worked fine with SQLite, but when I switched to MySQL, it
> really really hurt:
>
>     E:\agent\projects\Qooqle>jifty schema --setup
>     INFO - Generating SQL for application Qooqle...
>     INFO - Using Qooqle::Model::QQUser
>     INFO - Using Qooqle::Model::Message
>     INFO - Using Qooqle::Model::Session
>     INFO - Using Jifty::Model::Session
>     INFO - Using Jifty::Model::Metadata
>     WARN - Use of uninitialized value in concatenation (.) or string
> at E:/Perl/site
>     /lib/IPC/PubSub/Cache/JiftyDBI/Stash.pm line 11.
>     WARN - DBD::mysql::st execute failed: You have an error in your
> SQL syntax; chec
>     k the manual that corresponds to your MySQL server version for the
> right syntax
>     to use near 'NULL  ,
>       val blob NULL  ,
>       expiry int NULL  ,
>       PRIMARY KEY (id)
>     )' at line 3 at E:/Perl/site/lib/Jifty/DBI/Handle.pm line 485.
>     WARN - Jifty::DBI::Handle::mysql=HASH(0x3be27c4) couldn't execute
> the query 'CRE
>     ATE TABLE _jifty_pubsub_items (
>       id INTEGER NOT NULL  AUTO_INCREMENT,
>       key text NULL  ,
>       val blob NULL  ,
>       expiry int NULL  ,
>       PRIMARY KEY (id)
>     )
>     ' at E:/Perl/site/lib/Jifty/DBI/Handle.pm line 501.
>     INFO - Set up version v0.0.1, jifty version 0.611230_100
>
> I think I'm already at the svn head of Jifty and Jifty::DBI.
>
> Thank you in advance. :)
>
> Cheers,
> Agent
> _______________________________________________
> jifty-devel mailing list
> jifty-devel at lists.jifty.org
> http://lists.jifty.org/cgi-bin/mailman/listinfo/jifty-devel