# Installation problem **URL:** \ **Category:** Radiant CMS\ **Created:** [July 6, 2006, 7:28pm UTC](https://www.ruby-forum.com/t/installation-problem/97385 "2006-07-06T19:28:04Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Greenbeard](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/839c29/32.png) [@Greenbeard](https://www.ruby-forum.com/u/Greenbeard)\ **Post date:** [July 6, 2006, 7:28pm UTC](https://www.ruby-forum.com/t/installation-problem/97385/1 "2006-07-06T19:28:04Z")
Hello, I wanted to give radiant a whirl. I downloaded it via gem (with dependencies), created the mysql database, updated database.yml and ran: ruby script/server production I get the following output: Run `setup_database --help` for information on additional options. Loading production environment…Rails Error: Unable to access log file. Please ensure that ./script/…/config/…/log/production.log exists and is chmod 0666. The log level has been raised to WARN and the output directed to STDERR until the problem is fixed. OK WARNING! This script will overwrite information currently stored in the database “radiant\_live”. Are you sure you want to continue? [Yn] y Creating tables… – drop\_table(“config”) – create\_table(“config”, {:force=\>true}) FAILED c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:120:in `log': Mysql::Er ror: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to u se near 'ENGINE=InnoDB' at line 1: CREATE TABLE config (`id`int(11) DEFAULT NULL auto_increment PRIMARY KEY,`key`varchar(40) DEFA ULT '' NOT NULL,`value`varchar(255) DEFAULT '') ENGINE=InnoDB (ActiveRecord::StatementInvalid) from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in`execu te’ from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/connection\_adapters/abstract/schema\_statements.rb: 104:in `create_table' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:298:in `creat e\_table’ from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/migration.rb:272:in `method_missing' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/migration.rb:256:in `say\_with\_time’ from c:/ruby/lib/ruby/1.8/benchmark.rb:293:in `measure' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/migration.rb:256:in `say\_with\_time’ from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/migration.rb:270:in `method_missing' from script/setup_database:104:in `create\_tables’ from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/schema.rb:43:in `define' from script/setup_database:101:in `create\_tables’ from script/setup\_database:258:in `announce' from script/setup_database:99:in `create\_tables’ from script/setup\_database:19:in `run' from script/setup_database:9:in `run’ from script/setup\_database:297 This is Windows XP with MySQL 4.0.17, rails 1.1.2 Any ideas? Thank you. * * * Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around > **[Yahoo Mail - Organized Email](https://mail.yahoo.com)** > > It's time to get stuff done with Yahoo Mail. Just add your Gmail, Outlook, AOL or Yahoo Mail to get going. We automatically organize all the things life throws at you, like receipts and attachments, so you can find what you need fast. Plus, we've got... ---
**Author:** ![Greenbeard](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/839c29/32.png) [@Greenbeard](https://www.ruby-forum.com/u/Greenbeard)\ **Post date:** [July 6, 2006, 10:04pm UTC](https://www.ruby-forum.com/t/installation-problem/97385/2 "2006-07-06T22:04:45Z")
On Jul 6, 2006, at 12:26 PM, Greenbeard wrote: > abstract\_adapter.rb:120:in > `log’: Mysql::Er > ror: You have an error in your SQL syntax…near ‘ENGINE=InnoDB’ > … > > This is Windows XP with MySQL 4.0.17, rails 1.1.2 I can’t confirm this, but that early version of MySQL 4.0 might not have had InnoDB in. I did see a mention of InnoDB support for one platform not going in till 4.0.25, don’t know if that was for all platforms, but it might well have been. I’d try upgrading my MySQL. – Ryan P. Senior Developer, SubscriberMail, LLC 3333 Warrenville Rd. Suite 530 Lisle, IL 60532 (630) 303-5072 Not Just Email…SubscriberMail > **[subscribermail.com domain name is for sale. Inquire now.](https://www.subscribermail.com/)** > > subscribermail.com is available for purchase. Get in touch to discuss the possibilities! This message (including attachments) contains proprietary information which may not be disclosed or used beyond the purposes of this message without the written consent of SubscriberMail, LLC. If you receive this message in error, notify the sender and destroy this message and all attachments immediately. Thank you. SubscriberMail is covered under US PATENT 6,769,002