from:"Arjay Orcasitas"

Re: db:data:load error

2008-12-29 Thread Arjay Orcasitas

Hi Nacho,

Great! It's my pleasure to help you guys.

On Tue, Dec 30, 2008 at 4:09 AM, nacho  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 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  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  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  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"  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  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
-~--~~~~--~~--~--~---

Re: db:data:load error

2008-12-29 Thread Arjay Orcasitas

hi mark,

As I've said to mr. Nacho, you have to change the mySQL format to postgre
since heroku uses postgre.

Arjay "Jaythree03" <http://arjayorcasitas.com> Orcasitas


On Tue, Dec 30, 2008 at 2:42 AM, Mark Holton  wrote:

> Hi Arjay,
>
> To answer your questions:
> This is a MySQL database.
> I did indeed install the yaml_db rails plugin.
> editing application on local machine (Mac Book Pro)
>
> Hope that helps clarify.  Any suggestions?
> :Mark
>
>
>
> On Mon, Dec 29, 2008 at 1:57 AM, Arjay Orcasitas wrote:
>
>> 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  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  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  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"  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  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 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
-~--~~~~--~~--~--~---

Re: db:data:load error

2008-12-29 Thread Arjay Orcasitas

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 .

Arjay "Jaythree03"  Orcasitas
Please update

On Mon, Dec 29, 2008 at 6:29 PM, nacho  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  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  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"  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  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
-~--~~~~--~~--~--~---

Re: Request invitation

2008-12-29 Thread Arjay Orcasitas

hi vincent,

I'll invite you.

Arjay "Jaythree03"  Orcasitas

On Mon, Dec 29, 2008 at 5:39 PM, Vicent Gozalbes  wrote:

>
> Please, could someone invite me??
>
> Thanks a lot in advance.
> >
>

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

Re: db:data:load error

2008-12-29 Thread Arjay Orcasitas

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
Spreeapplication before because I can't load
the data but it's fine now.

Please update us again on your deployment.

Arjay "Jaythree03"  Orcasitas

On Mon, Dec 29, 2008 at 2:48 PM, Mark Holton  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  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  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"  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  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 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
-~--~~~~--~~--~--~---

Re: db:data:load error

2008-12-28 Thread Arjay Orcasitas

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

Re: Permission denied on git clone on Windows XP machine

2008-12-19 Thread Arjay Orcasitas

On Sat, Dec 20, 2008 at 6:24 AM, Arjay Orcasitas wrote:

> Hi Dave,
>
> Please try this one. ssh-keygen -t rsa. Now it should be running by now.
>
>
> On Sat, Dec 20, 2008 at 5:12 AM, Dave Roberts wrote:
>
>>
>> Basically the same problem outlined here:
>>
>> http://groups.google.com/group/heroku/browse_thread/thread/5d07360b0301c9b/bbffdabf2d21bf0b?lnk=gst&q=xp+clone+Permission+denied+publickey#bbffdabf2d21bf0b
>>
>> I am getting a permission denied on cloning a newly created project.
>> My id_rsa.pub matches my heroku key.  I am running on Windows XP.  I
>> can "heroku list" just fine.  "heroku keys" matches matches my
>> id_rsa.pub key.
>> >>
>>
>

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

Re: Permission denied on git clone on Windows XP machine

2008-12-19 Thread Arjay Orcasitas

Hi Dave,

Please try this one. ssh-keygen -t rsa. Now it should be

On Sat, Dec 20, 2008 at 5:12 AM, Dave Roberts wrote:

>
> Basically the same problem outlined here:
>
> http://groups.google.com/group/heroku/browse_thread/thread/5d07360b0301c9b/bbffdabf2d21bf0b?lnk=gst&q=xp+clone+Permission+denied+publickey#bbffdabf2d21bf0b
>
> I am getting a permission denied on cloning a newly created project.
> My id_rsa.pub matches my heroku key.  I am running on Windows XP.  I
> can "heroku list" just fine.  "heroku keys" matches matches my
> id_rsa.pub key.
> >
>

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

Re: db:data:load error

Re: db:data:load error

Re: db:data:load error

Re: Request invitation

Re: db:data:load error

Re: db:data:load error

Re: Permission denied on git clone on Windows XP machine

Re: Permission denied on git clone on Windows XP machine

8 matches

Site Navigation

Mail list logo

Footer information