Hi,
I followed all the instructions at
http://api.rails-engines.org/login_engine/ and successfully installed
and used the Login_Engine with a local MySQL database instance.
However, when I did exactly the same (slightly different app, but same
mods and all–using the same instructions), but with a remote MySQL
instance, I receive the following error when attempting to do the
migration:
Migrating engine ‘login_engine’
rake aborted!
Mysql::Error: You have an error in your SQL syntax near ‘ENGINE=InnoDB’
at line 1: CREATE TABLE users (id
int(11) DEFAULT NULL auto_increment
PRIMARY KEY, login
varchar(80) DEFAULT ‘’ NOT NULL, salted_password
varchar(40) DEFAULT ‘’ NOT NULL, email
varchar(60) DEFAULT ‘’ NOT
NULL, firstname
varchar(40), lastname
varchar(40), salt
varchar(40) DEFAULT ‘’ NOT NULL, verified
int(11) DEFAULT 0, role
varchar(40), security_token
varchar(40), token_expiry
datetime,
created_at
datetime, updated_at
datetime, logged_in_at
datetime,
deleted
int(11) DEFAULT 0, delete_after
datetime) ENGINE=InnoDB
Anyone have any ideas / clues as to what is wrong?
Thank you very much!
~ Brad