# Schema dump corrupts date defaults in mysql

**URL:** <https://www.ruby-forum.com/t/schema-dump-corrupts-date-defaults-in-mysql/56239>\
**Category:** Rails\
**Created:** [March 29, 2006, 5:43pm UTC](https://www.ruby-forum.com/t/schema-dump-corrupts-date-defaults-in-mysql/56239 "2006-03-29T17:43:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![matthewmurcia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/7cd45c/32.png) [@matthewmurcia](https://www.ruby-forum.com/u/matthewmurcia)\
**Post date:** [March 29, 2006, 5:43pm UTC](https://www.ruby-forum.com/t/schema-dump-corrupts-date-defaults-in-mysql/56239/1 "2006-03-29T17:43:33Z")

</div>

Hey, looks pretty messy out here the last two days…so please let me  
know  
if this is known, or if you can confirm.

Just upped to Rails 1.1. When I run `rake test` I get:

rake aborted!  
./db/schema.rb:17: parse error, unexpected kEND  
./db/schema.rb:21: parse error, unexpected $, expecting kEND

(See full trace by running task with --trace)

Uggly. In schema.rb:  
t.column “valid\_until”, :date, :default =\> #\<Date: 4976867/2,0,2299161\>

Whoa, an object ID? that can’t be right…and if I change schema.rb to  
a  
string, rake re-writes the damn thing before running the tests anyway.  
Is  
this confirmed/disprooved? Is it something I may be doing wrong?

The rake --trace follows, thank all.

–  
Matthew B. :: 607 227 0871  
Resume & Portfolio @ [http://madhatted.com](http://madhatted.com)

\*\* Invoke test (first\_time)  
\*\* Execute test  
\*\* Invoke test:units (first\_time)  
\*\* Invoke db:test:prepare (first\_time)  
\*\* Invoke environment (first\_time)  
\*\* Execute environment  
\*\* Execute db:test:prepare  
\*\* Invoke db:test:clone (first\_time)  
\*\* Invoke db:schema:dump (first\_time)  
\*\* Invoke environment  
\*\* Execute db:schema:dump  
\*\* Execute db:test:clone  
\*\* Invoke db:schema:load (first\_time)  
\*\* Invoke environment  
\*\* Execute db:schema:load  
rake aborted!  
./db/schema.rb:17: parse error, unexpected kEND  
./db/schema.rb:21: parse error, unexpected $, expecting kEND  
/usr/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active\_support/dependencies.rb:129:in  
`load' /usr/lib/ruby/gems/1.8/gems/activesupport-1.3.0/lib/active_support/dependencies.rb:129:in `load’  
/usr/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/tasks/databases.rake:31  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:202:in `invoke' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:195:in `invoke' /usr/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/tasks/databases.rake:71 /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:202:in `invoke’  
/usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:195:in `invoke’  
/usr/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/tasks/databases.rake:138  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:202:in `invoke' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:195:in `invoke' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:209:in `invoke\_prerequisites’/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:844:in  
`each' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:208:in `invoke\_prerequisites’/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:201:in  
`invoke' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:195:in `invoke' /usr/lib/ruby/gems/1.8/gems/rails-1.1.0/lib/tasks/testing.rake:28 /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:232:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:202:in `invoke’  
/usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:195:in `invoke’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:1719:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.7.0/lib/rake.rb:1719:in `run’  
/usr/lib/ruby/gems/1.8/gems/rake-0.7.0/bin/rake:7  
/usr/bin/rake:18

---

<div class="post-metadata">

**Author:** ![matthewmurcia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/7cd45c/32.png) [@matthewmurcia](https://www.ruby-forum.com/u/matthewmurcia)\
**Post date:** [March 29, 2006, 9:14pm UTC](https://www.ruby-forum.com/t/schema-dump-corrupts-date-defaults-in-mysql/56239/2 "2006-03-29T21:14:05Z")

</div>

I’m having simular issuse with the generation of `schema.rb`. for me it  
is changing double columns to floats.