Re: db:data:load error
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 Spreehttp://spree6.heroku.comapplication 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 holto...@gmail.com 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 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. --~--~-~--~~~---~--~~ 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
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 --~--~-~--~~~---~--~~ 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
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 jaythre...@gmail.comwrote: 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 Spreehttp://spree6.heroku.comapplication 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 holto...@gmail.com 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 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. --~--~-~--~~~---~--~~ 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
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.comwrote: 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 -~--~~~~--~~--~--~---
Re: db:data:load error
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. --~--~-~--~~~---~--~~ 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
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 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. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~--- data.yml Description: Binary data
Re: db:data:load error
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. --~--~-~--~~~---~--~~ 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
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. --~--~-~--~~~---~--~~ 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
Hi Arjay, I have tried both from the rake console. Neither of them work: * db:data:load* (in /mnt/home/userapps/51517) rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM clubs (See full trace by running task with --trace) *rake db:data:load* (in /mnt/home/userapps/51517) rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM clubs (See full trace by running task with --trace) On Sun, Dec 28, 2008 at 5:59 PM, Arjay Orcasitas jaythre...@gmail.comwrote: 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 holto...@gmail.com 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 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. --~--~-~--~~~---~--~~ 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
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 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. --~--~-~--~~~---~--~~ 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: rake aborted! = Re: db:data:load error
Maybe it was installed as recommended on the heroku blog (http:// blog.heroku.com/archives/2007/11/23/ yamldb_for_databaseindependent_data_dumps/) script/plugin install http://opensource.heroku.com/svn/rails_plugins/yaml_db Seems it would be good to remove the old version or synch it somehow. Facebooker had the same issue when they moved the repository and forgot about all of the dependencies. It took a post to the tutorial before it was revealed that the version that worked was on github. Maybe the thing to do is modify plugin so that a forward can be recognized, even if only so a message stating where the new code is located can be presented. Useful plugin though. Thanks for making it available On Aug 18, 1:39 pm, Morten Bagai [EMAIL PROTECTED] wrote: Hey, Looks like you are be running an outdated version of YAMLDb. Did you install from the Github repo at git://github.com/adamwiggins/ yaml_db.git? Best, /Morten On Aug 18, 2008, at 3:24 AM, Adinda Praditya wrote: Here's the complete error (with --trace) db:data:load --trace (in /mnt/home/userapps/31282) ** Invoke db:data:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:data:load rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM schema_info /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract_adapter.rb:147:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/postgresql_adapter.rb:446:in `execute' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:145:in `truncate_table' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:151:in `load_table' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:135:in `load' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:133:in `each' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:133:in `load' /usr/lib/ruby/1.8/yaml.rb:217:in `call' /usr/lib/ruby/1.8/yaml.rb:217:in `load_documents' /usr/lib/ruby/1.8/yaml.rb:217:in `each_document' /usr/lib/ruby/1.8/yaml.rb:232:in `load_documents' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:132:in `load' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/database_statements.rb:66:in `transaction' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:131:in `load' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:15:in `load' /home/userapps_plugins/preload/yaml_db/tasks/yaml_db_tasks.rake:20 /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke_with_call_chain' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 /usr/bin/rake:19:in `load' /usr/bin/rake:19 Please help. Thanks, Dida On Sun, Aug 17, 2008 at 7:31 PM, Adinda Praditya [EMAIL PROTECTED] wrote: I don't know it has anything to do with this thread or not. I just installed the YamlDB plugin, and uploaded the db dump, and finally ran db:data:load from the rake console, then i got this error: PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM schema_info Has anyone solved this problem? Please help Thanks, Dida --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: rake aborted! = Re: db:data:load error
Here's the complete error (with --trace) db:data:load --trace (in /mnt/home/userapps/31282) ** Invoke db:data:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:data:load rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM schema_info /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract_adapter.rb:147:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/postgresql_adapter.rb:446:in `execute' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:145:in `truncate_table' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:151:in `load_table' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:135:in `load' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:133:in `each' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:133:in `load' /usr/lib/ruby/1.8/yaml.rb:217:in `call' /usr/lib/ruby/1.8/yaml.rb:217:in `load_documents' /usr/lib/ruby/1.8/yaml.rb:217:in `each_document' /usr/lib/ruby/1.8/yaml.rb:232:in `load_documents' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:132:in `load' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:131:in `load' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:15:in `load' /home/userapps_plugins/preload/yaml_db/tasks/yaml_db_tasks.rake:20 /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke_with_call_chain' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 /usr/bin/rake:19:in `load' /usr/bin/rake:19 Please help. Thanks, Dida On Sun, Aug 17, 2008 at 7:31 PM, Adinda Praditya [EMAIL PROTECTED]wrote: I don't know it has anything to do with this thread or not. I just installed the YamlDB plugin, and uploaded the db dump, and finally ran db:data:load from the rake console, then i got this error: PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM schema_info Has anyone solved this problem? Please help Thanks, Dida --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---
Re: rake aborted! = Re: db:data:load error
Hey, Looks like you are be running an outdated version of YAMLDb. Did you install from the Github repo at git://github.com/adamwiggins/ yaml_db.git? Best, /Morten On Aug 18, 2008, at 3:24 AM, Adinda Praditya wrote: Here's the complete error (with --trace) db:data:load --trace (in /mnt/home/userapps/31282) ** Invoke db:data:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:data:load rake aborted! PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM schema_info /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract_adapter.rb:147:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/postgresql_adapter.rb:446:in `execute' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:145:in `truncate_table' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:151:in `load_table' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:135:in `load' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:133:in `each' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:133:in `load' /usr/lib/ruby/1.8/yaml.rb:217:in `call' /usr/lib/ruby/1.8/yaml.rb:217:in `load_documents' /usr/lib/ruby/1.8/yaml.rb:217:in `each_document' /usr/lib/ruby/1.8/yaml.rb:232:in `load_documents' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:132:in `load' /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ connection_adapters/abstract/database_statements.rb:66:in `transaction' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:131:in `load' /home/userapps_plugins/preload/yaml_db/lib/yaml_db.rb:15:in `load' /home/userapps_plugins/preload/yaml_db/tasks/yaml_db_tasks.rake:20 /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke_with_call_chain' /usr/lib/ruby/1.8/thread.rb:135:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 /usr/bin/rake:19:in `load' /usr/bin/rake:19 Please help. Thanks, Dida On Sun, Aug 17, 2008 at 7:31 PM, Adinda Praditya [EMAIL PROTECTED] wrote: I don't know it has anything to do with this thread or not. I just installed the YamlDB plugin, and uploaded the db dump, and finally ran db:data:load from the rake console, then i got this error: PGError: ERROR: current transaction is aborted, commands ignored until end of transaction block : DELETE FROM schema_info Has anyone solved this problem? Please help Thanks, Dida --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~--~~~~--~~--~--~---