hi, please try "rake db:data:load" this should solve your problem. Please update me if it answers your question.
On Mon, Dec 29, 2008 at 5:15 AM, Mark Holton <holto...@gmail.com> wrote: > 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 <holto...@gmail.com> 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 <holto...@gmail.com> 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 heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---