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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
