Yes, I noticed that on one of my projects when I pushed it to the server. Not patch yet. I think this is a bug in the rails MySQL adapter for not treating "key" as a reserved word. I think.

-Alex
http://beautifulpixel.com

On Jun 25, 2008, at 12:08 PM, Jim Gay wrote:

I'm trying to use the radiant-settings extension and having a problem in MySQL 5.0.27: ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key' at line 1: SELECT * FROM `config` ORDER BY key):
http://pastie.org/222044

Works fine in SQLite.

-Jim
_______________________________________________
Radiant mailing list
Post:   Radiant@radiantcms.org
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

_______________________________________________
Radiant mailing list
Post:   Radiant@radiantcms.org
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

Reply via email to