Sample yaml.db attached. db:load successfully creates the schema from schema.rb, but whenever it gets to the db:data:load portion of that rake task it pukes with the PGError below.
Thanks, :Mark On Sun, Dec 28, 2008 at 1:03 PM, Mark Holton <[email protected]> wrote: > When I run "db:data:load" from the Rake console I get: > > >> db:data:load > (in /mnt/home/userapps/51510) > rake aborted! > PGError: ERROR: current transaction is aborted, commands ignored until end > of transaction block > : DELETE FROM development > > (See full trace by running task with --trace) > > > :Mark > > > On Sun, Dec 28, 2008 at 1:00 PM, Holts <[email protected]> wrote: > >> Hi Guys, >> >> I am trying out an account at golfapp.heroku.com. I was able to >> upload my app, and also upload test data via data.yml per your >> instructions (pasted below). >> >> I can download that file from the web ui and see that the data has >> been posted, but it doesn't make it into the database. Whenever I run >> db:data:load via the online console I get the following error: >> >> >> db:data:load >> SyntaxError: compile error >> /home/heroku_rack/lib/init.rb:1: syntax error, unexpected ':', >> expecting $end >> db:data:load >> ^ >> >> >> Any help is greatly appreciated, >> :Mark Holton >> >> >> >> "Data Import >> >> After you've imported your app's code and schema via the method above, >> run your migrations, then follow the instructions below to import your >> data. >> >> Install the YamlDB plugin into your local app: >> script/plugin install git://github.com/adamwiggins/yaml_db.git >> Run >> rake db:data:dump >> Edit your Heroku app and open the context menu for the db directory. >> Select Upload, and upload db/data.yml from your local filesystem. >> *** Use the gear menu to open a rake console, and type >> db:data:load *** >> Go to the Data tab to confirm your data loaded correctly." >> >> >> > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
data.yml
Description: Binary data
