Hi Arjay, I have tried both from the rake console. Neither of them work:
>>* db:data:load* (in /mnt/home/userapps/51517) rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM clubs (See full trace by running task with --trace) > *rake db:data:load* (in /mnt/home/userapps/51517) rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM clubs (See full trace by running task with --trace) On Sun, Dec 28, 2008 at 5:59 PM, Arjay Orcasitas <[email protected]>wrote: > 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 <[email protected]> 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 <[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 -~----------~----~----~----~------~----~------~--~---
