I'm having trouble pushing a local MySQL database to Heroku:
$ heroku db:push
Auto-detected local database: mysql://root:[email protected]/wscript?encoding=utf8
Sending schema
Sending data
22 tables, 184 records
!!! Caught Server Exception | ETA:
--:--:--
Taps Server Error: PGError ERROR: relation "added_permissions" does
not exist
I have the following gems installed:
rails (2.3.5, 2.3.3, 2.2.2, 2.1.0, 2.0.2, 1.2.6)
heroku (1.7.0, 1.4, 1.3.0)
taps (0.2.24, 0.2.23)
The beginning of my schema.db looks like this:
ActiveRecord::Schema.define(:version => 20100120135931) do
create_table "added_permissions", :id => false, :force => true do |
t|
t.integer "ID", :null => false
t.integer "item_id", :null => false
t.string "item_type", :default => "", :null => false
t.integer "area", :null => false
end
(the schema is from a non-Rails app, hence the upper case ID)
Note that 'rake db:schema:load' runs fine without an errors, so it
seems the table is being created correctly.
Any suggestions for what the problem is, or how to diagnose it?
Andy
--
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.
