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 <[email protected]>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 <[email protected]> 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 <[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." >>> >>> >> >> >> -- >> // 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 [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 -~----------~----~----~----~------~----~------~--~---
