I don't have a specific answer for you, but in general I would suggest using postgres locally, to make it easier to debug issues like this.
That way you can rule out 'postgres' issues vs 'heroku postgres'. You'll see in other threads some various tips when migrating from mysql to postgresql, and you'll find it a lot easier to go through that stuff and being able to verify it locally. On Sun, Feb 7, 2010 at 7:16 AM, Andy Waite <[email protected]> wrote: > 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]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > > -- -John -- 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.
