Installation problem


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
exists and is chmod 0666. The log level has been
raised to WARN and the output directed to STDERR until
the problem is fixed.

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})
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 (idint(11) DEFAULT NULL auto_increment PRIMARY KEY,keyvarchar(40) DEFA ULT '' NOT NULL,valuevarchar(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:inexecu
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
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’
method_missing' from script/setup_database:104:in create_tables’
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

On Jul 6, 2006, at 12:26 PM, Greenbeard wrote:

`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

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