hi mark, I think there's a problem during the rake db:bootstrap method. What SQL Server are you using? is it postgreSQL? if it's postgreSQL, then you shouldn't have any problem at all when you do the db:data:load. One more thing, did you install the YAML_DB plugin? where are you editing your application? is it in your local machine? I suggest that you do it first in your local machine. I also had a hard time deploying Schof's Spree<http://spree6.heroku.com>application before because I can't load the data but it's fine now.
Please update us again on your deployment. Arjay "Jaythree03" <http://arjayorcasitas.com> Orcasitas On Mon, Dec 29, 2008 at 2:48 PM, Mark Holton <[email protected]> wrote: > It's a good point I will look into in more details. I'll start small with > a couple tables in the schema and work out from there. > Thanks, > :Mark > > > > > On Sun, Dec 28, 2008 at 9:25 PM, Alfonso <[email protected]> wrote: > >> >> Have you checked your schema is completely loaded? If migrations went >> skewed the data load sometimes is not very clear on what's going on. >> even if the schema migration checks look at your tables closely. >> missing columns in particular >> >> On Dec 28, 6:02 pm, nacho <[email protected]> wrote: >> > i have the same problems >> > i totally imposible for me upload my data and make my applications >> > works :( >> > >> > On Dec 28, 10: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 -~----------~----~----~----~------~----~------~--~---
