Hi Nacho, Great! It's my pleasure to help you guys.
On Tue, Dec 30, 2008 at 4:09 AM, nacho <na...@yestoall.com> wrote: > thank you > > now works ok > i make the migrations online and then add all the data via yaml and works > perfect > > > On Mon, Dec 29, 2008 at 3:24 PM, Arjay Orcasitas <jaythre...@gmail.com>wrote: > >> hi nacho, >> >> SQLite3 has a different way of making data.yml. Your developing your >> application in your local machine am I right? So you're using SQLite3. Can >> you please change it to postgreSQL? You can still use your schema, just >> change the database.yml into postgre format. Heroku is using postgre. I >> tried deploying my applications in both postgre and SQLite before but the >> SQLite had some errors. I have a screencast on how I deployed my application >> in heroku. you can see it here <http://arjayorcasitas.com/?p=1>. >> >> Arjay "Jaythree03" <http://arjayorcasitas.com> Orcasitas >> Please update >> >> On Mon, Dec 29, 2008 at 6:29 PM, nacho <na...@yestoall.com> wrote: >> >>> i can't load my schema >>> i also have an error with *rake db:schema:load* >>> >>> --- >>> >>> db:schema:load(in /mnt/home/userapps/51587) >>> -- create_table("citas", {:force=>true}) >>> rake aborted! >>> PGError: ERROR: syntax error at or near "(" >>> LINE 1: ...ABLE "citas" ("id" serial primary key, "text" text(512) >>> DEFA... >>> ^ >>> : CREATE TABLE "citas" ("id" serial primary key, "text" text(512) DEFAULT >>> E'', "author" character varying(255), "created_at" timestamp, "updated_at" >>> timestamp, "user_id" integer DEFAULT 0) >>> >>> (See full trace by running task with --trace) >>> >>> --- >>> >>> this schema works perfectly locally in my mac with sqlite3 >>> >>> any idea what's wrong? >>> >>> >>> On Mon, Dec 29, 2008 at 6:25 AM, Alfonso <aadrias...@gmail.com> 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 <na...@yestoall.com> 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" <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." >>>> >>>> >>> >>> >>> -- >>> // nacho >>> // sigo con mi terapia en http://cache.yestoall.com >>> >>> >>> >>> >> >> >> > > > -- > // nacho > // sigo con mi terapia en http://cache.yestoall.com > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---