# Rails 1.2.3 MySQL 3.23.58 incompatible?

**URL:** <https://www.ruby-forum.com/t/rails-1-2-3-mysql-3-23-58-incompatible/111067>\
**Category:** Rails\
**Created:** [August 2, 2007, 11:01am UTC](https://www.ruby-forum.com/t/rails-1-2-3-mysql-3-23-58-incompatible/111067 "2007-08-02T11:01:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![abon](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@abon](https://www.ruby-forum.com/u/abon)\
**Post date:** [August 2, 2007, 11:01am UTC](https://www.ruby-forum.com/t/rails-1-2-3-mysql-3-23-58-incompatible/111067/1 "2007-08-02T11:01:50Z")

</div>

Hi,

## I was trying to create a table via action record by this file

class CreateTasks \< ActiveRecord::Migration  
def self.up  
create\_table :tasks do |t|  
t.column :action, :string  
t.column :issuer, :integer  
t.column :receiver, :integer  
t.column :created\_at, :datetime  
t.column :expected\_time, :datetime  
t.column :closed\_time, :datetime

```
end

```

end

def self.down  
drop\_table :tasks  
end  
end  
~  
while I’m doing rake:migrate

I got syntax error message like this

Mysql::Error: You have an error in your SQL syntax near ‘ENGINE=InnoDB’  
at line 1: CREATE TABLE tasks (`id` int(11) DEFAULT NULL auto\_increment  
PRIMARY KEY, `action` varchar(255) DEFAULT NULL, `issuer` int(11)  
DEFAULT NULL, `receiver` int(11) DEFAULT NULL, `created_at` datetime  
DEFAULT NULL, `expected_time` datetime DEFAULT NULL, `closed_time`  
datetime DEFAULT NULL) ENGINE=InnoDB  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract\_adapter.rb:128:in  
`log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in`execute’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/schema\_statements.rb:104:in  
`create_table' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:353:in`create\_table’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:275:in  
`send' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:275:in`method\_missing’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:259:in  
`say_with_time' /usr/local/lib/ruby/1.8/benchmark.rb:293:in`measure’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:259:in  
`say_with_time' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:273:in`method\_missing’  
./db/migrate//001\_create\_tasks.rb:3:in `real_up' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:212:in`send’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:212:in  
`migrate' /usr/local/lib/ruby/1.8/benchmark.rb:293:in`measure’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:212:in  
`migrate' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:335:in`migrate’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:330:in  
`each' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:330:in`migrate’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/migration.rb:297:in  
`up' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/migration.rb:288:in`migrate’  
/usr/local/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/tasks/databases.rake:4  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in`execute’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in`execute’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke' /usr/local/lib/ruby/1.8/thread.rb:135:in`synchronize’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in`top\_level’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in`top\_level’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in  
`standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in`top\_level’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in`standard\_exception\_handling’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7 /usr/local/bin/rake:16:in`load’  
/usr/local/bin/rake:16

Anyone ran into this kind of problem before?  
Many thanks.

---

<div class="post-metadata">

**Author:** ![abon](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@abon](https://www.ruby-forum.com/u/abon)\
**Post date:** [August 2, 2007, 2:54pm UTC](https://www.ruby-forum.com/t/rails-1-2-3-mysql-3-23-58-incompatible/111067/2 "2007-08-02T14:54:00Z")

</div>

On Aug 2, 2007, at 5:01 AM, Bontina C. wrote:

> ```
> t.column :receiver, :integer
> 
> ```
> 
> end  
> DEFAULT NULL, `receiver` int(11) DEFAULT NULL, `created_at` datetime  
> DEFAULT NULL, `expected_time` datetime DEFAULT NULL, `closed_time`  
> datetime DEFAULT NULL) ENGINE=InnoDB
> 
> ## Anyone ran into this kind of problem before? Many thanks.

I think in 3.23 you need to have “TYPE=InnoDB”

```
  create_table :tasks, :options => 'TYPE=InnoDB' do |t|

```

See if that works for you, but I’d suggest updating to a more modern  
MySQL!

-Rob

Rob B. [http://agileconsultingllc.com](http://agileconsultingllc.com)  
removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![abon](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/45deac/32.png) [@abon](https://www.ruby-forum.com/u/abon)\
**Post date:** [August 3, 2007, 3:13am UTC](https://www.ruby-forum.com/t/rails-1-2-3-mysql-3-23-58-incompatible/111067/3 "2007-08-03T03:13:53Z")

</div>

It worked!!!

Thanks a lot.

Rob B. wrote:

> On Aug 2, 2007, at 5:01 AM, Bontina C. wrote:
> 
> > ```
> > t.column :receiver, :integer
> > 
> > ```
> > 
> > end  
> > DEFAULT NULL, `receiver` int(11) DEFAULT NULL, `created_at` datetime  
> > DEFAULT NULL, `expected_time` datetime DEFAULT NULL, `closed_time`  
> > datetime DEFAULT NULL) ENGINE=InnoDB
> > 
> > ## Anyone ran into this kind of problem before? Many thanks.
> 
> I think in 3.23 you need to have “TYPE=InnoDB”
> 
> ```
> create_table :tasks, :options => 'TYPE=InnoDB' do |t|
> 
> ```
> 
> See if that works for you, but I’d suggest updating to a more modern  
> MySQL!
> 
> -Rob
> 
> Rob B. [http://agileconsultingllc.com](http://agileconsultingllc.com)  
> removed\_email\_address@domain.invalid