Deploying to Heroku - Says Successful but no App

[Barbara Donnini]

Hi Spree Group,

I have struggled with this issue for an extremely long time - I can't get my site to deploy to Heroku. I tried starting over from scratch even to debug but still couldn't get it to deploy. Here are the logs and what I believe are relevant files for the site I am trying to deploy:

https://gist.github.com/bdonnini9055/9cec94e099a43dbd2db0

I included the Amazon pieces because that may be where I'm going wrong. 

It says it deploys successfully but the page says "An error occurred in the application and your page could not be served. Please try again in a few moments. If you are the application owner, check your logs for details."

Please let me know if I can provide any additional information/code! 

Thank you,
Barbara

[Brendan Murtagh]

Morning. My take on the error is that you’re missing the bluepay gem based off of:

2016-03-02T03:23:09.076890+00:00 app[web.1]: /app/app/models/bluepay.rb:29:in `<top (required)>': uninitialized constant BluePay (NameError)

I also looked at your Gemfile and I don’t see bluepay mentioned. What happens once that gem is included & installed?

-Brendan

[Barbara Donnini]

Hi Brendan,

Thanks! We aren't using BluePay anymore, so I removed the entire bluepay.rb file. That got rid of that error, but now there is a new error in the logs:

ActionController::RoutingError (No route matches [GET] "/"):

Could this be because I changed the Spree store page to /shop and how our /root is the "welcome to ruby" page?

Here are the updated logs:

https://gist.github.com/bdonnini9055/d3d30bff6538218388df

Thank you,

Barbara

[Barbara Donnini]

I don't know if this helps with the above post, but I'm also getting this error when I'm running it on a the local Cloud9 server:

@bucket or raise ArgumentError, "missing required :bucket option"

[Barbara Donnini]

Is anyone able to help with this?

[Jason Fleetwood-Boldt]

Barbara-

the GIST you attached to this email does actually show the fullback trace-- you need to tail the Heroku logs in a terminal window and leave that window open as you generate the error, then copy & paste the complete logs showing the raised exception.

Usually :bucket options have to do with Amazon S3 or cloud storage, or a FOG setup. Without seeing the exact line it crashes on I can't really tell you any more than that.

-Jason

----

Jason Fleetwood-Boldt

te...@datatravels.com

http://www.jasonfleetwoodboldt.com/writing

If you'd like to reply by encrypted email you can find my public key on jasonfleetwoodboldt.com (more about setting GPG: https://gpgtools.org) 

[Shel Tebbs]

IIRC, the "welcome to ruby" page is not served in production. You
expected to have something for the root route. If you want to redirect
to '/shop/' you could add this to your `config/routes.rb` file:

get '/', to: redirect('/shop/')

On 03/02/2016 06:26 AM, Barbara Donnini wrote:
> Hi Brendan,
>
> Thanks! We aren't using BluePay anymore, so I removed the entire
> bluepay.rb file. That got rid of that error, but now there is a new
> error in the logs:
>
> ActionController::RoutingError (No route matches [GET] "/"):
>
> Could this be because I changed the Spree store page to /shop and how
> our /root is the "welcome to ruby" page?
>
> Here are the updated logs:
> https://gist.github.com/bdonnini9055/d3d30bff6538218388df
>
> Thank you,
> Barbara
>
> On Wednesday, March 2, 2016 at 8:40:06 AM UTC-5, Brendan Murtagh wrote:
>
> Morning. My take on the error is that you’re missing the bluepay gem
> based off of:
>

> /2016-03-02T03:23:09.076890+00:00 app[web.1]:

> /app/app/models/bluepay.rb:29:in `<top (required)>': uninitialized

> constant BluePay (NameError)/
> /
> /

> I also looked at your Gemfile and I don’t see bluepay mentioned.
> What happens once that gem is included & installed?
>
>
> -Brendan
>
> On March 1, 2016 at 10:30:08 PM, Barbara Donnini

> (barb.d...@gmail.com <javascript:>) wrote:
>
>> Hi Spree Group,
>>
>> I have struggled with this issue for an extremely long time - I
>> can't get my site to deploy to Heroku. I tried starting over from
>> scratch even to debug but still couldn't get it to deploy. Here
>> are the logs and what I believe are relevant files for the site I
>> am trying to deploy:
>>
>> https://gist.github.com/bdonnini9055/9cec94e099a43dbd2db0
>> <https://gist.github.com/bdonnini9055/9cec94e099a43dbd2db0>
>>
>> I included the Amazon pieces because that may be where I'm going
>> wrong.
>>
>> It says it deploys successfully but the page says "An error
>> occurred in the application and your page could not be served.
>> Please try again in a few moments. If you are the application
>> owner, check your logs for details."
>>
>> Please let me know if I can provide any additional information/code!
>>
>> Thank you,
>> Barbara
>

--
→∞+⇈

[Barbara Donnini]

Hi Jason,

I think I did it correctly this time - is this right?

https://gist.github.com/bdonnini9055/a9300fcfe0a0a1dc2c64

Yes I agree I think it has something to do with Amazon. I followed the instructions on the spree site to get Amazon all set up as it said was needed for heroku and something is still wrong. However, I can't figure out which file the line is in... here's what the screen shows:

I know this is two issues at once sorry! I have been working on both for a very long time though and I imagine they might be related but that's just a guess. I literally have everything else with spree set up except this deploying thing. The rest of my site works by the way, it's just when I go to any spree routes that I get this error (like /shop). The static pages are fine.

Barb

[Barbara Donnini]

Hi Shel,

I'm sorry if I was confusing, I wasn't asking how to get rid of that page, I was just letting you both know that I changed the "homepage" for Spree in case it was causing the other error with Heroku/Amazon/deployment. I already have this in my routes file:

  mount Spree::Core::Engine, :at => '/shop'

Thanks,

Barb

[Jason Fleetwood-Boldt]

Barbara--

still can't see the top of the trace. 

however, I can tell since the logs say "State changed from up to down" that your app is probably crashing on boot (so you can't actually boot anything)

Here's what you should do: 

open 1 terminal window, run:

heroku logs -t -a yourappname

keep this window open while you open a 2nd terminal window

In the 2nd terminal window, restart your Heroku app with (I presume since your Heroku app is crashing you don't mind restarting it)

heroku restart -a yourappname

Then switch back to your first window and watch your logs. (actually watch them). You should see it say things like "state changed from crash to starting..." etc. Then you will see the full crash backtrace there. By tailing in window 1 before you restart the app in the other terminal window, you will be able to capture the full log.

What you are trying to figure out is exactly what line of code is producing the "missing :bucket" error --- it is almost certainly something you haven't configured. 

If in fact the app is not crashing when it boots, do the same as the steps above but instead of Terminal window #2, hit the app in your browser directly (by just typing in the URL) -- the thing about starting the tail in Terminal window #1 still applies to that -- be sure that the tail is running as you actually produce the error. 

What you are doing now is producing the error and then running heroku logs, but since logplex (yes, it's actually called logplex, I didn't just make that up) doesn't save a full history it only shows you a certain number of lines back.

We use the Heroku Add-on called "Papertrail" which saves your logs for your for a 7 day period. (They *might* have a free version for you?  -- you can check on the Heroku Add Ons page). It's the same information you see in the heroku logs it just captures it for you to be able to go back and look at the logs at a later time.

-Jason

On Mar 4, 2016, at 3:24 PM, Barbara Donnini <barb.d...@gmail.com> wrote:

Hi Jason,

I think I did it correctly this time - is this right?

https://gist.github.com/bdonnini9055/a9300fcfe0a0a1dc2c64

Yes I agree I think it has something to do with Amazon. I followed the instructions on the spree site to get Amazon all set up as it said was needed for heroku and something is still wrong. However, I can't figure out which file the line is in... here's what the screen shows:

[Jason Fleetwood-Boldt]

I think sh...@vetco.net wrote that because your logs say:

ActionController::RoutingError (No route matches [GET] "/"):

which means that someone (not sure who, might be javascript or something you aren't aware of) is trying to hit the root of the domain ('/'), and that's causing those crashes in the logs. Could be unrelated to the other problems you are debugging

[Barbara Donnini]

Hi Jason,

Okay I think I royally messed things up for this one... I told you it was going to be a doozy! Here's what happened - I went to run your command and realized I never established an app name because I copied and pasted the files. So, I started a new workspace in Cloud9 IDE, this time actually declared an app with rails new sfapp and THEN copied the files over. I initialized the git repository, added my bitbucket, created a new heroku and pushed to heroku.

Then I did your first instruction heroku logs -t -a sfapp.

It said this:

 !    You do not have access to the app sfapp.

Yikes... what did I do?? I'm so sorry!

Barb

[Barbara Donnini]

Hi again Jason,

I think I figured out what the problem was - I had another app named the same thing. So, I went back and re-did everything again and this time I'm getting the error "App not found" when I try your first command. 

To make sure it wasn't the files, I created yet another project and this time did not copy my old files - I literally just followed up to "git push heroku master" in Michael Hartl's tutorial book chapter 3 here: https://www.railstutorial.org/book/static_pages

and it still said the same thing...

Barb

[Jason Fleetwood-Boldt]

First, make sure you installed Heroku Command Line Interface (download from their website)

heroku auth:whoami


You should see that you are logged in as your primary Heroku email account (this is the same email you use to log into Heroku on the website)

If you are not logged in, type

heroku auth:login

That will prompt you to log in on the command line. After that, type

heroku apps

Then you should see a list of the apps you have access to (that should include both your 1st app and maybe your 2nd?)

-Jason

> On Mar 4, 2016, at 4:51 PM, Barbara Donnini <barb.d...@gmail.com> wrote:
>
> Hi Jason,
>
> Okay I think I royally messed things up for this one... I told you it was going to be a doozy! Here's what happened - I went to run your command and realized I never established an app name because I copied and pasted the files. So, I started a new workspace in Cloud9 IDE, this time actually declared an app with rails new sfapp and THEN copied the files over. I initialized the git repository, added my bitbucket, created a new heroku and pushed to heroku.
>
> Then I did your first instruction heroku logs -t -a sfapp.
>
> It said this:
>
> ! You do not have access to the app sfapp.
>
> Yikes... what did I do?? I'm so sorry!
>
> Barb
>

[Barbara Donnini]

Hi Jason,

Oh my goodness I am so embarrassed I made a silly mistake I was typing the name of the app as my folder name not as the Heroku assigned name. Thank you for giving that process, it made me realize that!

So, I went back to your original process and ran the first command with my app name and it said this:

bld2104:~/workspace/sfapp (master) $ heroku logs -t -a shielded-chamber-85604

2016-03-04T21:45:41.493825+00:00 heroku[api]: Enable Logplex by bld####@gmail.com

2016-03-04T21:45:41.493825+00:00 heroku[api]: Release v2 created by bld####@gmail.com

2016-03-04T21:47:37.457659+00:00 heroku[slug-compiler]: Slug compilation started

2016-03-04T21:47:37.457665+00:00 heroku[slug-compiler]: Slug compilation failed: failed to compile Ruby app

2016-03-07T02:01:39.962938+00:00 heroku[slug-compiler]: Slug compilation started

2016-03-07T02:01:39.962948+00:00 heroku[slug-compiler]: Slug compilation failed: failed to compile Ruby app

then I opened the second terminal window and restarted my app and nothing happened in the first window. The second window (where I ran the restart) said "Restarting dynos... done"

I even tried it a second time and it did the same thing.

I installed Papertrail and it says I need a procfile. I am planning on installing Puma (as recommended in that tutorial book) and getting that up and running but I was going to fix this before I break anything else... unless you think I need to do that first...

Barb

[Jason Fleetwood-Boldt]

Your slug compilation is failing — that’s the part where you app’s code is compiled into a single “disk” (-like) thing and deployed to the cloud. Without getting through slug compilation successfully nothing else will work for you (and my previous instructions won’t be helpful)

When you just push your repository to Heroku (following the Heroku deploy process), do you see the Slug compilation errors?

If so, that’s where you should start. Make sure you can do a full deploy first.

One piece of advice— I’d recommend you actually step back and build yourself a simple “Hello World” Rails app — not on Spree — just to get comfortable with Heroku. You’ll want to learn how to push a deploy, tail your logs, restart your dynos, etc, before getting into pushing up a Spree app. 

-Jason

[Barbara Donnini]

Hi Jason,

I have gotten several apps to deploy successfully to Heroku without Spree (using Michael Hartl's tutorial book). As soon as I added Spree everything broke. I've heard of all those things before you mentioned them (tailing, restarting, etc.) and have done them, but admittedly it's just because I saw it on Stack Overflow not because I have a good sense of what's going on. I've never had that slug issue before, I'm not even sure what a slug is!

Do you have advice on where to go from here? The errors seem very vague. Is there a website you recommend for explaining slugs and what I can do with this issue? I've even tried backing up and ONLY installing spree and no customizations and I still can't get it to deploy...

but maybe that's where I should go back to? Because the HTML customizations are easy, I can always upload my HTML pages and CSS right? Maybe I should start a new app with literally none of my original content, just a spree site, and give you the error that I am encountering when I try to deploy that (which will definitely be different). Then once we have that deployed, I can add my unique content like the HTML and CSS.

Does that sound like a good plan? I really appreciate all of your help on this, we're a nonprofit and we can't afford to hire a developer and our organic farm is starting in a month and I'm freaking out!

Thank you again,

Barb

[Jason Fleetwood-Boldt]

Copy & paste the deployment (what you see when you deploy) into a Gist — it should say where the slug compilation is failing. 

On Mar 7, 2016, at 11:45 AM, Barbara Donnini <barb.d...@gmail.com> wrote:

Hi Jason,

[Barbara Donnini]

Ahh okay gotcha, here it is!

https://gist.github.com/bdonnini9055/42b794998497ec077437

[Jason Fleetwood-Boldt]

remote: An error occurred while installing sqlite3 (1.3.11), and Bundler cannot
remote: continue.
remote: Make sure that `gem install sqlite3 -v '1.3.11'` succeeds before bundling.

You probably don’t need sqlite — that’s a cheap (free) disk-based database that is typically used in development. Assuming you are using PostgreSQL (default on Heorku), just take sqlite out of your gemfile and run bundle install.

I’d recommend you use the same database on Heroku as you do in development. (Personally I’m partial to MySQL, which takes extra setup on Heroku,— the popular choice these days is PostgreSQL, pronounced ‘postgres’)

-Jason

[Shel Tebbs]

Heroku doesn't support SQLite, which is the default database engine used
in rails, and hence it is what you are trying to use right now.

See here: https://simonecarletti.com/blog/2016/01/post-heroku-sqlite/

On 03/07/2016 09:12 AM, Barbara Donnini wrote:
> Ahh okay gotcha, here it is!
>
> https://gist.github.com/bdonnini9055/42b794998497ec077437
>
> On Monday, March 7, 2016 at 11:58:53 AM UTC-5, Jason FB wrote:
>
> Copy & paste the deployment (what you see when you deploy) into a
> Gist — it should say where the slug compilation is failing.
>
>
>
>
>> On Mar 7, 2016, at 11:45 AM, Barbara Donnini <barb.d...@gmail.com

--
→∞+⇈

[Barbara Donnini]

Hi Jason,

I'm so sorry again I had changed this but when I copied the files because I thought it was a duplicate app I forgot to change it again. I went back in and fixed this and the bluepay issue we had before and re-ran it. It deployed but is back to the thing where it doesn't actually show when you go to the URL. So I went back to your original instructions with the two terminal windows and this is what happened:

https://gist.github.com/bdonnini9055/a17d59b91c958d4b483e

I broke the files down by the deployment, the logs before restarting, and the logs after restarting. I hope I did it right this time! I'm sorry for my extreme confusion and disorganization over this I have tried so many things and copied it so many times I got lost (which is my fault, I'm going through and deleting old copies now so I don't get confused again, I will ONLY use this one from now on)

Barb

[Barbara Donnini]

Oh also I got this error from Cloud9:

[Jason Fleetwood-Boldt]

Hmm…. 

looks like your app is booting OK now, when I hit https://floating-tundra-40461.herokuapp.com I get 404 “Page Not found” (which is expected, since you previously told us you mounted Spree at /shop)

When I hit https://floating-tundra-40461.herokuapp.com/shop I get a 500 error ("We're sorry, but something went wrong.”) — tail the logs as you hit the 500 Error in your browser and send us that log output. The tail you sent shows the app booting and then someone trying to hit / and getting a 404.

You can do Command-K in terminal to clear out the log output just before you hit /shop in your web browser, then you will be looking at only the error generated by hitting /shop

-Jason  

[Barbara Donnini]

Phew we're making progress! I think this is what you are looking for:

2016-03-07T18:30:09.835672+00:00 heroku[router]: at=info method=GET path="/shop" host=floating-tundra-40461.herokuapp.com request_id=ce3075ac-c592-4583-9b9c-190c44fe18f2 fwd="100.14.176.16" dyno=web.1 connect=0ms service=9ms status=500 bytes=1754

2016-03-07T18:30:09.829242+00:00 app[web.1]: Started GET "/shop" for 100.14.176.16 at 2016-03-07 18:30:09 +0000

2016-03-07T18:30:09.830627+00:00 app[web.1]: Processing by Spree::HomeController#index as HTML

2016-03-07T18:30:09.833662+00:00 app[web.1]: PG::UndefinedTable: ERROR:  relation "spree_products" does not exist

2016-03-07T18:30:09.833668+00:00 app[web.1]: LINE 5:                WHERE a.attrelid = '"spree_products"'::regcla...

2016-03-07T18:30:09.833669+00:00 app[web.1]:                                           ^

2016-03-07T18:30:09.833670+00:00 app[web.1]: :               SELECT a.attname, format_type(a.atttypid, a.atttypmod),

2016-03-07T18:30:09.833672+00:00 app[web.1]:                      pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod

2016-03-07T18:30:09.833673+00:00 app[web.1]:                 FROM pg_attribute a LEFT JOIN pg_attrdef d

2016-03-07T18:30:09.833673+00:00 app[web.1]:                   ON a.attrelid = d.adrelid AND a.attnum = d.adnum

2016-03-07T18:30:09.833674+00:00 app[web.1]:                WHERE a.attrelid = '"spree_products"'::regclass

2016-03-07T18:30:09.833674+00:00 app[web.1]:                  AND a.attnum > 0 AND NOT a.attisdropped

2016-03-07T18:30:09.833675+00:00 app[web.1]:                ORDER BY a.attnum

2016-03-07T18:30:09.833675+00:00 app[web.1]: 

2016-03-07T18:30:09.833843+00:00 app[web.1]: Completed 500 Internal Server Error in 3ms (ActiveRecord: 0.9ms)

2016-03-07T18:30:09.835436+00:00 app[web.1]: 

2016-03-07T18:30:09.835445+00:00 app[web.1]: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR:  relation "spree_products" does not exist

2016-03-07T18:30:09.835445+00:00 app[web.1]: LINE 5:                WHERE a.attrelid = '"spree_products"'::regcla...

2016-03-07T18:30:09.835446+00:00 app[web.1]:                                           ^

2016-03-07T18:30:09.835446+00:00 app[web.1]: :               SELECT a.attname, format_type(a.atttypid, a.atttypmod),

2016-03-07T18:30:09.835447+00:00 app[web.1]:                      pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod

2016-03-07T18:30:09.835447+00:00 app[web.1]:                 FROM pg_attribute a LEFT JOIN pg_attrdef d

2016-03-07T18:30:09.835448+00:00 app[web.1]:                   ON a.attrelid = d.adrelid AND a.attnum = d.adnum

2016-03-07T18:30:09.835448+00:00 app[web.1]:                WHERE a.attrelid = '"spree_products"'::regclass

2016-03-07T18:30:09.835449+00:00 app[web.1]:                  AND a.attnum > 0 AND NOT a.attisdropped

2016-03-07T18:30:09.835449+00:00 app[web.1]:                ORDER BY a.attnum

2016-03-07T18:30:09.835450+00:00 app[web.1]: ):

2016-03-07T18:30:09.835450+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'

2016-03-07T18:30:09.835451+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'

2016-03-07T18:30:09.835452+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:473:in `block in log'

2016-03-07T18:30:09.835452+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

2016-03-07T18:30:09.835453+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:467:in `log'

2016-03-07T18:30:09.835453+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'

2016-03-07T18:30:09.835454+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'

2016-03-07T18:30:09.835454+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'

2016-03-07T18:30:09.835454+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:733:in `column_definitions'

2016-03-07T18:30:09.835455+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/postgresql/schema_statements.rb:186:in `columns'

2016-03-07T18:30:09.835455+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/schema_cache.rb:43:in `columns'

2016-03-07T18:30:09.835456+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/attributes.rb:93:in `columns'

2016-03-07T18:30:09.835456+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/attributes.rb:98:in `columns_hash'

2016-03-07T18:30:09.835456+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:970:in `block in create_binds'

2016-03-07T18:30:09.835457+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:967:in `each'

2016-03-07T18:30:09.835457+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:967:in `partition'

2016-03-07T18:30:09.835458+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:967:in `create_binds'

2016-03-07T18:30:09.835458+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:954:in `build_where'

2016-03-07T18:30:09.835458+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:584:in `where!'

2016-03-07T18:30:09.835459+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/relation/query_methods.rb:574:in `where'

2016-03-07T18:30:09.835459+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/spree_core-3.0.5/lib/spree/core/search/base.rb:20:in `retrieve_products'

2016-03-07T18:30:09.835459+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/spree_frontend-3.0.5/app/controllers/spree/home_controller.rb:8:in `index'

2016-03-07T18:30:09.835460+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/implicit_render.rb:4:in `send_action'

2016-03-07T18:30:09.835460+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/abstract_controller/base.rb:198:in `process_action'

2016-03-07T18:30:09.835460+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/rendering.rb:10:in `process_action'

2016-03-07T18:30:09.835461+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/abstract_controller/callbacks.rb:20:in `block in process_action'

2016-03-07T18:30:09.835461+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:117:in `call'

2016-03-07T18:30:09.835461+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:117:in `call'

2016-03-07T18:30:09.835464+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:555:in `block (2 levels) in compile'

2016-03-07T18:30:09.835464+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:505:in `call'

2016-03-07T18:30:09.835464+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:505:in `call'

2016-03-07T18:30:09.835465+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:92:in `_run_callbacks'

2016-03-07T18:30:09.835465+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:776:in `_run_process_action_callbacks'

2016-03-07T18:30:09.835465+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:81:in `run_callbacks'

2016-03-07T18:30:09.835466+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/abstract_controller/callbacks.rb:19:in `process_action'

2016-03-07T18:30:09.835466+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/rescue.rb:29:in `process_action'

2016-03-07T18:30:09.835466+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'

2016-03-07T18:30:09.835467+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/notifications.rb:164:in `block in instrument'

2016-03-07T18:30:09.835467+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'

2016-03-07T18:30:09.835467+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/notifications.rb:164:in `instrument'

2016-03-07T18:30:09.835468+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/instrumentation.rb:30:in `process_action'

2016-03-07T18:30:09.835468+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/params_wrapper.rb:250:in `process_action'

2016-03-07T18:30:09.835469+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/railties/controller_runtime.rb:18:in `process_action'

2016-03-07T18:30:09.835469+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/abstract_controller/base.rb:137:in `process'

2016-03-07T18:30:09.835486+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionview-4.2.2/lib/action_view/rendering.rb:30:in `process'

2016-03-07T18:30:09.835487+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal.rb:196:in `dispatch'

2016-03-07T18:30:09.835504+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal/rack_delegation.rb:13:in `dispatch'

2016-03-07T18:30:09.835505+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_controller/metal.rb:237:in `block in action'

2016-03-07T18:30:09.835506+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/routing/route_set.rb:74:in `call'

2016-03-07T18:30:09.835506+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/routing/route_set.rb:74:in `dispatch'

2016-03-07T18:30:09.835507+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/routing/route_set.rb:43:in `serve'

2016-03-07T18:30:09.835507+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/journey/router.rb:43:in `block in serve'

2016-03-07T18:30:09.835508+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/journey/router.rb:30:in `each'

2016-03-07T18:30:09.835509+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/journey/router.rb:30:in `serve'

2016-03-07T18:30:09.835510+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/routing/route_set.rb:819:in `call'

2016-03-07T18:30:09.835510+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/engine.rb:518:in `call'

2016-03-07T18:30:09.835511+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/railtie.rb:194:in `public_send'

2016-03-07T18:30:09.835511+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/railtie.rb:194:in `method_missing'

2016-03-07T18:30:09.835512+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/routing/mapper.rb:51:in `serve'

2016-03-07T18:30:09.835513+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/journey/router.rb:43:in `block in serve'

2016-03-07T18:30:09.835514+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/journey/router.rb:30:in `each'

2016-03-07T18:30:09.835514+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/journey/router.rb:30:in `serve'

2016-03-07T18:30:09.835515+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/routing/route_set.rb:819:in `call'

2016-03-07T18:30:09.835516+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/warden-1.2.6/lib/warden/manager.rb:35:in `block in call'

2016-03-07T18:30:09.835516+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/warden-1.2.6/lib/warden/manager.rb:34:in `catch'

2016-03-07T18:30:09.835517+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/warden-1.2.6/lib/warden/manager.rb:34:in `call'

2016-03-07T18:30:09.835518+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/etag.rb:24:in `call'

2016-03-07T18:30:09.835522+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/conditionalget.rb:25:in `call'

2016-03-07T18:30:09.835523+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/head.rb:13:in `call'

2016-03-07T18:30:09.835523+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/params_parser.rb:27:in `call'

2016-03-07T18:30:09.835524+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/flash.rb:260:in `call'

2016-03-07T18:30:09.835525+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/session/abstract/id.rb:225:in `context'

2016-03-07T18:30:09.835525+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/session/abstract/id.rb:220:in `call'

2016-03-07T18:30:09.835526+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/cookies.rb:560:in `call'

2016-03-07T18:30:09.835526+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/query_cache.rb:36:in `call'

2016-03-07T18:30:09.835527+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activerecord-4.2.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:649:in `call'

2016-03-07T18:30:09.835528+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'

2016-03-07T18:30:09.835528+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:88:in `call'

2016-03-07T18:30:09.835529+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:88:in `_run_callbacks'

2016-03-07T18:30:09.835530+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:776:in `_run_call_callbacks'

2016-03-07T18:30:09.835530+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/callbacks.rb:81:in `run_callbacks'

2016-03-07T18:30:09.835531+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/callbacks.rb:27:in `call'

2016-03-07T18:30:09.835531+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/remote_ip.rb:78:in `call'

2016-03-07T18:30:09.835532+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'

2016-03-07T18:30:09.835532+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'

2016-03-07T18:30:09.835533+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/rack/logger.rb:38:in `call_app'

2016-03-07T18:30:09.835534+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/rack/logger.rb:20:in `block in call'

2016-03-07T18:30:09.835534+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/tagged_logging.rb:68:in `block in tagged'

2016-03-07T18:30:09.835535+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/tagged_logging.rb:26:in `tagged'

2016-03-07T18:30:09.835535+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/tagged_logging.rb:68:in `tagged'

2016-03-07T18:30:09.835536+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/rack/logger.rb:20:in `call'

2016-03-07T18:30:09.835537+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/request_id.rb:21:in `call'

2016-03-07T18:30:09.835537+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/methodoverride.rb:22:in `call'

2016-03-07T18:30:09.835538+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/runtime.rb:18:in `call'

2016-03-07T18:30:09.835538+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/activesupport-4.2.2/lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call'

2016-03-07T18:30:09.835539+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/actionpack-4.2.2/lib/action_dispatch/middleware/static.rb:113:in `call'

2016-03-07T18:30:09.835540+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/sendfile.rb:113:in `call'

2016-03-07T18:30:09.835540+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/engine.rb:518:in `call'

2016-03-07T18:30:09.835541+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/railties-4.2.2/lib/rails/application.rb:164:in `call'

2016-03-07T18:30:09.835578+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/lock.rb:17:in `call'

2016-03-07T18:30:09.835579+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/content_length.rb:15:in `call'

2016-03-07T18:30:09.835580+00:00 app[web.1]:   vendor/bundle/ruby/2.2.0/gems/rack-1.6.4/lib/rack/handler/webrick.rb:88:in `service'

2016-03-07T18:30:09.835580+00:00 app[web.1]:   vendor/ruby-2.2.4/lib/ruby/2.2.0/webrick/httpserver.rb:138:in `service'

2016-03-07T18:30:09.835581+00:00 app[web.1]:   vendor/ruby-2.2.4/lib/ruby/2.2.0/webrick/httpserver.rb:94:in `run'

2016-03-07T18:30:09.835582+00:00 app[web.1]:   vendor/ruby-2.2.4/lib/ruby/2.2.0/webrick/server.rb:294:in `block in start_thread'

2016-03-07T18:30:09.835582+00:00 app[web.1]: 

2016-03-07T18:30:09.835583+00:00 app[web.1]: 

[Jason Fleetwood-Boldt]

Did you run rake db:migrate after you deployed?

heroku run rake db:migrate -a floating-tundra-40461

?

[Barbara Donnini]

OMG that worked! Some of the pictures aren't showing up and the products are deleted but let me try to get them back on my own and if I have trouble will post here again!

THANK YOU SO SO SO SO MUCH!

Barb

[Barbara Donnini]

Okay I got the images to appear (I had that problem previously so knew what to do). But, the products still aren't showing up. They show up on the local server but not the heroku app. The heroku app just says "no products found." If I login through /shop/admin on the local server it works. I tried logging in through the Heroku app and it doesn't recognize my username and password. I found this SO article:

http://stackoverflow.com/questions/20131009/broken-spree-fancy-layout-on-heroku/21803071#21803071

but am afraid to implement in in case I mess something up! Do those instructions look right to you?

Thanks so much,

Barb

[Jason Fleetwood-Boldt]

You probably migrated an empty database, so it doesn't have any data in it (at all) or any users.

You can either 1) run the Spree demo setup on Heroku directly (spree install --auto-accept) or 2) copy your development database and upload it to Heroku

The Spree demo setup creates a default user sp...@example.com with password spree123 -- it also creates several 'dummy' product for you. You would only have this in your database if you had run spree install (setting up the dummy data)

If you don't want that, then I would go with option #2 above.

Assuming you are using PosgreSQL, this tutorial should help you out getting your local data uploaded to your Heroku instance

https://devcenter.heroku.com/articles/heroku-postgres-import-export

[Barbara Donnini]

Cool, I tried the first way by running:

heroku addons:add heroku-postgresql

then

heroku run rake spree_auth:admin:create

and it seems to have worked! I was able to login from the Heroku app and re-create the products. We're making progress! Of course something else went wrong... I added a product to the cart, clicked "Checkout" and when it got to /shop/checkout/address it said "sorry something went wrong" and the app crashed. I did what you taught me and ran the tail logs thing and then watched as I opened the page and this is what happened:

https://gist.github.com/bdonnini9055/bc8ffece7d9d836cff8d

it looks like it's having an issue with the "states" for the address page?

[Shel]

Spree needs data like which states belong to which countries, which is what it was trying to load there.

If you don't want test products and test orders, run

rake db:seed

which loads the needed data into the database which can later be modified if you so desire

If you'd like to reply by encrypted email you can find my public key on jasonfleetwoodboldt.com (more about setting GPG: <a href="https://gpgtools.org" target="_blank" rel="nofollow" onmousedown="this.href='https://www.google.com/url?q\75https%3A%2F%2Fgpgtools.org\46sa\75D\46sntz\0751\46usg\75AFQjCNHndH9tmbP6n6vEQOQUZHmsUsYe9g';return true;" onclick="this.href='https://www.google.com/url?q\75https%3A%2F%2Fgpgtools.org\46sa\75D\46sntz\0751\46usg\75AFQjCNHndH9tmbP6n6vEQOQ

[Barbara Donnini]

Hi Shel,

I just tried that and it did not work, it deleted the images for my products (which I re-uploaded) and when I looked at the logs it still has the same error. I found a few articles about this error but am very nervous to implement them in case I mess things up further...

https://github.com/spree/spree/issues/1142

https://github.com/spree/spree/issues/1100

Barb

If you'd like to reply by encrypted email you can find my public key on <a href="http://jasonfleetwoodboldt.com" rel="nofollow" target="_blan

[Barbara Donnini]

Also, besides the states error mentioned above, the pictures for my products keep disappearing. The products are showing up on the shop page but the pictures don't (maybe every time I push they disappear?)

Thanks,

Barb

<a href="http://www.jasonfleetwoodboldt.com/writing" rel="nofollow" target="_blank" onmousedown="this.href='http://www.google.com/url?q\75http%3A%2F%2Fwww.jasonfleetwoodboldt.com%2Fwriting\46sa\75

[Shel Tebbs]

Yes, every time you push the product images dissapear. This is because
spree stores images locally on the hard drive, and heroku clears the
hard drive every time you push, or any time the dyno restarts. You can
either add the images before pushing, and remove the appropriate line
from .gitignore to include the images along with the push. However, any
images you add from the web interface may seem to work at first but
won't "stick".

The other option is to use amazon s3 to store images, see here:
https://guides.spreecommerce.com/developer/s3_storage.html

On 03/08/2016 08:27 AM, Barbara Donnini wrote:
> Also, besides the states error mentioned above, the pictures for my
> products keep disappearing. The products are showing up on the shop page
> but the pictures don't (maybe every time I push they disappear?)
>
> Thanks,
> Barb
>
> On Monday, March 7, 2016 at 5:18:00 PM UTC-5, Barbara Donnini wrote:
>
> Hi Shel,
>
> I just tried that and it did not work, it deleted the images for my
> products (which I re-uploaded) and when I looked at the logs it
> still has the same error. I found a few articles about this error
> but am very nervous to implement them in case I mess things up
> further...
>
> https://github.com/spree/spree/issues/1142

> <https://github.com/spree/spree/issues/1142>
> https://github.com/spree/spree/issues/1100

> <http://floating-tundra-40461.herokuapp.com>

> https://gist.github.com/bdonnini9055/a17d59b91c958d4b483e <https://gist.github.com/bdonnini9055/a17d59b91c958d4b483e>

> https://gist.github.com/bdonnini9055/42b794998497ec077437 <https://gist.github.com/bdonnini9055/42b794998497ec077437>

> <http://www.google.com/url?q%5C75http%3A%2F%2Fwww.jasonfleetwoodboldt.com%2Fwriting%5C46sa%5C75>
>

--
→∞+⇈

[Barbara Donnini]

Hi Shel,

Thanks for the reminder, I had Amazon s3 installed on a previous version of the site I was working on but  not this one. I followed those instructions (and added the variables by using commands like "heroku config:set AWS_SECRET_ACCESS_KEY=your_secret_access_key". I went to /shop/admin and tried to add an image to one of the products and the app failed. Here's a gist of the logs (doing it the way Jason taught before) and my spree.rb file:

https://gist.github.com/bdonnini9055/967288d9bc7d5349914e

Also, I have a feeling I didn't do Jason's suggestion properly - when he said "1) run the Spree demo setup on Heroku directly (spree install --auto-accept) " - I already ran spree install --auto-accept so I wasn't sure how to do that "on heroku" so instead googled it and that's why I wound up creating the new user.

The finish line is in sight! I just need to get over this "state" error and the pictures and hopefully that will be it!

Thanks,

Barbara

[Jason Fleetwood-Boldt]

check for both 'paperclip' and 'fog' in your Gemfile

You'll need to make sure to tell Paperclip to use S3 -- the example at https://guides.spreecommerce.com/developer/s3_storage.html shows one way to do that -- did you create the file config/intializers/spree.rb ? 

You should be able to test these bugs locally, incidentally, because you can also set up S3 to work for your local dev environment. 

----

Jason Fleetwood-Boldt

te...@datatravels.com

http://www.jasonfleetwoodboldt.com/writing

If you'd like to reply by encrypted email you can find my public key on jasonfleetwoodboldt.com (more about setting GPG: https://gpgtools.org) 

[Shel Tebbs]

Make sure

gem 'aws-sdk'

is in your Gemfile

On 03/08/2016 05:41 PM, Barbara Donnini wrote:
> Hi Shel,
>

> > <http://floating-tundra-40461.herokuapp.com

--
→∞+⇈

[Barbara Donnini]

Hi Jason and Shel,

Thanks for getting back to me. aws-sdk was installed, paperclip and fog were not, I added them. It's still not working though, it crashes now when I go to add an image. I did the log tail thing and copied my spree.rb file into another gist:

https://gist.github.com/bdonnini9055/55858c818eea94bf659e

The checkout also still doesn't work :( 

Barb

[Barbara Donnini]

I wanted to let you both know I tried a few more things - I tried rake db:migrate, rails g spree:install and heroku run rake db:migrate -a sweetfields in that order but it didn't work. Both issues (not being able to add pictures and not being able to check out) still exist :( :(

This is my error but none of the answers are working 

https://github.com/spree/spree/issues/1142

well, I didn't know how to do the one that talks about setting Spree::Config[:default_country_id] because I don't know what file that is in.

Barb

[Jason Fleetwood-Boldt]

You can set that manually on the console (heroku run console)

then type:

Spree::Config.set(:default_country_id, 214)

On Mar 9, 2016, at 9:51 PM, Barbara Donnini <barb.d...@gmail.com> wrote:

well, I didn't know how to do the one that talks about setting Spree::Config[:default_country_id] because I don't know what file that is in.

----

Jason Fleetwood-Boldt

te...@datatravels.com

http://www.jasonfleetwoodboldt.com/writing

If you'd like to reply by encrypted email you can find my public key on jasonfleetwoodboldt.com (more about setting GPG: https://gpgtools.org) 

[Barbara Donnini]

Hi Jason,

Oh no! I did that and now it won't push to heroku at all! Here is the error and the logs in a gist:

https://gist.github.com/bdonnini9055/ce65e851617b2c32ebab

[Barbara Donnini]

by the way this is what it said when I ran that command in case you need it:

bld2104:~/workspace/sfunique2 (master) $ heroku run console

Running console on sweetfields... up, run.7714

DEPRECATION WARNING: The configuration option `config.serve_static_assets` has been renamed to `config.serve_static_files` to clarify its role (it merely enables serving everything in the `public` folder and is unrelated to the asset pipeline). The `serve_static_assets` alias will be removed in Rails 5.0. Please migrate your configuration files accordingly. (called from block in <top (required)> at /app/config/environments/production.rb:79)

[WARNING] You are not setting Devise.secret_key within your application!

You must set this in config/initializers/devise.rb. Here's an example:

 

Devise.secret_key = "885c8c01484382cd91cfd9cf0cd36a94223fee719e5aee507501bd52c5dd416660d9d23fb068ce81c727c32b7af4d45d4a47"

  Spree::Preference Load (2.9ms)  SELECT  "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1 LIMIT 1  [["key", "spree/app_configuration/currency"]]

Loading production environment (Rails 4.2.2)

irb(main):001:0> Spree::Config.set(:default_country_id, 214)

  Spree::Preference Load (3.8ms)  SELECT  "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1  ORDER BY "spree_preferences"."id" ASC LIMIT 1  [["key", "spree/app_configuration/default_country_id"]]

  Spree::Preference Load (3.8ms)  SELECT  "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1  ORDER BY "spree_preferences"."id" ASC LIMIT 1  [["key", "spree/app_configuration/default_country_id"]]

   (6.6ms)  BEGIN

   (6.6ms)  BEGIN

  Spree::Preference Exists (2.2ms)  SELECT  1 AS one FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/app_configuration/default_country_id' LIMIT 1

  Spree::Preference Exists (2.2ms)  SELECT  1 AS one FROM "spree_preferences" WHERE "spree_preferences"."key" = 'spree/app_configuration/default_country_id' LIMIT 1

  SQL (563.4ms)  INSERT INTO "spree_preferences" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"  [["key", "spree/app_configuration/default_country_id"], ["value", "--- 214\n...\n"], ["created_at", "2016-03-10 13:58:20.124358"], ["updated_at", "2016-03-10 13:58:20.124358"]]

  SQL (563.4ms)  INSERT INTO "spree_preferences" ("key", "value", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id"  [["key", "spree/app_configuration/default_country_id"], ["value", "--- 214\n...\n"], ["created_at", "2016-03-10 13:58:20.124358"], ["updated_at", "2016-03-10 13:58:20.124358"]]

   (6.2ms)  COMMIT

   (6.2ms)  COMMIT

=> nil 

[Jason Fleetwood-Boldt]

I believe your error is this:

ArgumentError: Invalid route name, already in use: ‘spree'

So your problem there is likely in your routes file (I doubt that is related to setting the config, but to rule that out, log back into Heroku console and unset the config variable)

You can debug asset compilation locally, before you push, using

$ RAILS_ENV=production bin/rake assets:precompile

However, after you do this, you must not check-in the public/assets/ directory (you’ll recognize this directory because it was created by the asset pre compilation above). You should also remember to delete this directory soon — or else you will see strange behavior in development.


these two articles explain the Asset Pipeline

http://guides.rubyonrails.org/asset_pipeline.html#in-production
https://devcenter.heroku.com/articles/rails-4-asset-pipeline

Just remember that on Heroku, you should not actually compile the assets locally & check them in, you should let them be compiled when you push to heroku (You know they are being compiled because you see “ Running: rake assets:precompile”).

The advice above about compiling them locally is for debugging purposes, so you can figure out why you’re getting the error "ArgumentError: Invalid route name, already in use: ‘spree'"

[Barbara Donnini]

Hi Jason,

Okay I think I did this correctly... I googled how to undo the setting of the variable and it said to do "heroku rollback" so I did that. Then I pushed to make sure the rollback actually worked. It still said assets were failing so I'm not sure if it did, but you said the setting of the variable probably wasn't the problem anyway so I forged ahead.

I read the two articles you sent. I think I get what's going on, Heroku is adding text to make it work in production... I wish there was an in-person Ruby course available near me I would take it immediately! I know I have a poor understanding of this.

I ran: $ RAILS_ENV=production bin/rake assets:precompile 

Here is the output:

https://gist.github.com/bdonnini9055/97b91a75c011864912cb

It looks like I don't have a public/assets folder:

I tried my usual git add-A, git commit -m "text", git push, and git push heroku master after this and it didn't work the result is in the above gist 

[Shel Tebbs]

What's in your config/routes.rb file?

Also as the error says, you need to set "Devise.secret_key". This is a
separate, but still important problem.

On 03/10/2016 09:36 AM, Barbara Donnini wrote:
> Hi Jason,
>
> Okay I think I did this correctly... I googled how to undo the setting
> of the variable and it said to do "heroku rollback" so I did that. Then
> I pushed to make sure the rollback actually worked. It still said assets
> were failing so I'm not sure if it did, but you said the setting of the
> variable probably wasn't the problem anyway so I forged ahead.
>
> I read the two articles you sent. I think I get what's going on, Heroku
> is adding text to make it work in production... I wish there was an
> in-person Ruby course available near me I would take it immediately! I
> know I have a poor understanding of this.
>
> I ran: $ RAILS_ENV=production bin/rake assets:precompile
>
> Here is the output:
>
> https://gist.github.com/bdonnini9055/97b91a75c011864912cb
>
> It looks like I don't have a public/assets folder:
>

> <https://lh3.googleusercontent.com/-aWRFwzvYdPM/VuGwSTyyDTI/AAAAAAAAIl4/Vcbv5FBMQ2M/s1600/no-public-assets.png>

>
>
>
> I tried my usual git add-A, git commit -m "text", git push, and git push
> heroku master after this and it didn't work the result is in the above gist
>
> On Thursday, March 10, 2016 at 12:09:07 PM UTC-5, Jason FB wrote:
>
>
> I believe your error is this:
>
> ArgumentError: Invalid route name, already in use: ‘spree'
>
> So your problem there is likely in your routes file (I doubt that is
> related to setting the config, but to rule that out, log back into
> Heroku console and unset the config variable)
>
> You can debug asset compilation locally, before you push, using
>
> $ RAILS_ENV=production bin/rake assets:precompile
>
> However, after you do this, you must not check-in the public/assets/
> directory (you’ll recognize this directory because it was created by
> the asset pre compilation above). You should also remember to delete
> this directory soon — or else you will see strange behavior in
> development.
>
>
> these two articles explain the Asset Pipeline
>
> http://guides.rubyonrails.org/asset_pipeline.html#in-production

> <http://www.google.com/url?q=http%3A%2F%2Fguides.rubyonrails.org%2Fasset_pipeline.html%23in-production&sa=D&sntz=1&usg=AFQjCNESUNbBjZjDoe5hxKk-_rSDK1lJHw>
>
> https://devcenter.heroku.com/articles/rails-4-asset-pipeline
> <https://www.google.com/url?q=https%3A%2F%2Fdevcenter.heroku.com%2Farticles%2Frails-4-asset-pipeline&sa=D&sntz=1&usg=AFQjCNHv1n2nMz6Xtq91XvjfAcXir-EqBg>

>
>
> Just remember that on Heroku, you should not actually compile the
> assets locally & check them in, you should let them be compiled when
> you push to heroku (You know they are being compiled because you see
> “ Running: rake assets:precompile”).
>
> The advice above about compiling them locally is for debugging
> purposes, so you can figure out why you’re getting the error
> "ArgumentError: Invalid route name, already in use: ‘spree'"
>
>
>
>
> > On Mar 10, 2016, at 9:34 AM, Barbara Donnini <barb.d...@gmail.com

> <javascript:>> wrote:
> >
> > Hi Jason,
> >
> > Oh no! I did that and now it won't push to heroku at all! Here is
> the error and the logs in a gist:
> >
> > https://gist.github.com/bdonnini9055/ce65e851617b2c32ebab
> <https://gist.github.com/bdonnini9055/ce65e851617b2c32ebab>
> >
> > On Thursday, March 10, 2016 at 7:19:33 AM UTC-5, Jason FB wrote:
> >
> > You can set that manually on the console (heroku run console)
> >
> > then type:
> >
> > Spree::Config.set(:default_country_id, 214)
> >
> >
> >
> >
> >> On Mar 9, 2016, at 9:51 PM, Barbara Donnini <barb.d...@gmail.com>
> wrote:
> >>
> >> well, I didn't know how to do the one that talks about setting
> Spree::Config[:default_country_id] because I don't know what file
> that is in.
> >
> > ----
> >
> > Jason Fleetwood-Boldt
> > te...@datatravels.com
> > http://www.jasonfleetwoodboldt.com/writing
> <http://www.jasonfleetwoodboldt.com/writing>
> >
> > If you'd like to reply by encrypted email you can find my public

> key on jasonfleetwoodboldt.com <http://jasonfleetwoodboldt.com>

> (more about setting GPG: https://gpgtools.org)
> >
>

--
→∞+⇈

[Barbara Donnini]

Hi Shel,

Here it is!

Rails.application.routes.draw do

  # This line mounts Spree's routes at the root of your application.

  # This means, any requests to URLs such as /products, will go to Spree::ProductsController.

  # If you would like to change where this engine is mounted, simply change the :at option to something different.

  #

  # We ask that you don't use the :as option here, as Spree relies on it being the default of "spree"

  mount Spree::Core::Engine, :at => '/'

        

  # This line mounts Spree's routes at the root of your application.

  # This means, any requests to URLs such as /products, will go to Spree::ProductsController.

  # If you would like to change where this engine is mounted, simply change the :at option to something different.

  #

  # We ask that you don't use the :as option here, as Spree relies on it being the default of "spree"

  mount Spree::Core::Engine, :at => '/shop'

          # The priority is based upon order of creation: first created -> highest priority.

  # See how all your routes lay out with "rake routes".

  # You can have the root of your site routed with "root"

 get 'index' =>'static_pages#index'

  get 'contact'    => 'static_pages#contact'

  get 'about'   => 'static_pages#about'

  get 'partners' => 'static_pages#partners'

    get 'inkinddonations' => 'static_pages#in-kind-donations'

      get 'sponsors' => 'static_pages#sponsors'

        get 'supporters' => 'static_pages#supporters'

        get 'shop' => 'static_pages#shop'

        get 'events' => 'static_pages#events'

        get 'specialthanks' => 'static_pages#special-thanks'

        get 'why' => 'static_pages#why'

        get 'getinvolved' => 'static_pages#getinvolved'

        get 'volunteer' => 'static_pages#volunteer'

        get 'donate' => 'static_pages#donate'

        get 'workshares' => 'static_pages#workshares'

        get 'corporatematch' => 'static_pages#corporatematch'

        get 'waystogive' => 'static_pages#waystogive'

        get 'wishlist' => 'static_pages#wishlist'

        get 'secure' => 'static_pages#secure'

        get 'privacy' => 'static_pages#privacy'

        get 'rules' => 'static_pages#rules'

        get 'faq' => 'static_pages#faq'

        get 'profile' => 'static_pages#profile'

        get 'seeusers' => 'static_pages#seeusers'

        get 'farmingmethods' => 'static_pages#farmingmethods'

        get 'farm' => 'static_pages#farm'

        get 'csa' => 'static_pages#csa'

        get 'pickyourown' => 'static_pages#pickyourown'

        get 'schools' => 'static_pages#schools'

        get 'kids' => 'static_pages#kids'

        get 'classes' => 'static_pages#classes'

        get 'tours' => 'static_pages#tours'

        get 'nfprules' => 'static_pages#nfprules'

  # Example of regular route:

  #   get 'products/:id' => 'catalog#view'

  # Example of named route that can be invoked with purchase_url(id: product.id)

  #   get 'products/:id/purchase' => 'catalog#purchase', as: :purchase

  # Example resource route (maps HTTP verbs to controller actions automatically):

  #   resources :products

  # Example resource route with options:

  #   resources :products do

  #     member do

  #       get 'short'

  #       post 'toggle'

  #     end

  #

  #     collection do

  #       get 'sold'

  #     end

  #   end

  # Example resource route with sub-resources:

  #   resources :products do

  #     resources :comments, :sales

  #     resource :seller

  #   end

  # Example resource route with more complex sub-resources:

  #   resources :products do

  #     resources :comments

  #     resources :sales do

  #       get 'recent', on: :collection

  #     end

  #   end

  # Example resource route with concerns:

  #   concern :toggleable do

  #     post 'toggle'

  #   end

  #   resources :posts, concerns: :toggleable

  #   resources :photos, concerns: :toggleable

  # Example resource route within a namespace:

  #   namespace :admin do

  #     # Directs /admin/products/* to Admin::ProductsController

  #     # (app/controllers/admin/products_controller.rb)

  #     resources :products

  #   end

end

 

[Jason Fleetwood-Boldt]

Running asset precompile locally just gives you the same error you saw when you pushed to Heroku. Keep in mind the only point of that is for you to debug locally, and see that you can reproduce this same error locally out of the context of Heroku. Just remember to trash the public/assets/ folder it generates (do not confuse with the app/asset/ folder — that’s part of your app that you won’t want to trash)

as you see from the error:

remote: ArgumentError: Invalid route name, already in use: 'spree'
	remote: You may have defined two routes with the same name using the `:as` option, or you may be overriding a route already defined by a resource with the same naming. For the latter, you can restrict the routes created with `resources` as explained here:

And, if you look closely at your routes file, you have indeed mounted Spree twice:

mount Spree::Core::Engine, :at => '/

and then again a few lines down:

mount Spree::Core::Engine, :at => '/shop’

You can only mount Spree once, so decide if you want it at / or /shop and remove the other one.

-Jason

[Jason Fleetwood-Boldt]

Heroku rollback will indeed roll you back to the previously launched Heroku version. However, because the Spree config settings operate in the database (and also, confusingly, in a cache mechanism), rolling back your Heroku deploy won’t affect the Spree config setting.

if you want to clear out that setting, log into the heroku console (heroku run console -a yourappname) and run this:

Spree::Config.set(:default_country_id, nil)

But assuming you have the default countries in your database, you’ll almost certainly want Spree::Config.set(:default_country_id, 214) — assuming you are running a store in the U.S., as 214 is the record id for the United States.

-Jason

[Barbara Donnini]

Hi Jason,

Great news it deployed successfully again! That was the issue (the routes thing). 

I am still not seeing a public/assets folder to delete. Hopefully that's a good thing.

So, I tried the cart again. It's interesting, if I'm *not* logged in, clicking the cart just refreshes the /shop page. If I *am* logged in the app still crashes, and here are the logs (below).

I even tried setting it again and still same error. I wonder what it doesn't like?

I'm learning a lot though from this, I understand your explanation about why rolling back wouldn't do anything now.

Barb

2016-03-10T22:17:59.603409+00:00 app[web.1]: Started PATCH "/shop/cart" for 100.14.176.16 at 2016-03-10 22:17:59 +0000

2016-03-10T22:17:59.606164+00:00 app[web.1]: Processing by Spree::OrdersController#update as HTML

2016-03-10T22:17:59.606267+00:00 app[web.1]:   Parameters: {"utf8"=>"✓", "authenticity_token"=>"ixp4G4AU6/SCWb6Pqd7t4k7wNib+2YYa2FdaE4jLE7kem5IEuQd4li9ig+nO0t5xtqNTfBriu3J+DZlWcnFPfA==", "order"=>{"line_items_attributes"=>{"0"=>{"quantity"=>"1", "id"=>"1"}, "1"=>{"quantity"=>"1", "id"=>"2"}}}, "checkout"=>""}

2016-03-10T22:17:59.610508+00:00 app[web.1]:   Spree::Preference Load (2.8ms)  SELECT  "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1 LIMIT 1  [["key", "spree/frontend_configuration/locale"]]

2016-03-10T22:17:59.614534+00:00 app[web.1]:   Spree::User Load (2.2ms)  SELECT  "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."id" = $1  ORDER BY "spree_users"."id" ASC LIMIT 1  [["id", 1]]

2016-03-10T22:17:59.618957+00:00 app[web.1]:   Spree::Store Load (2.2ms)  SELECT  "spree_stores".* FROM "spree_stores" WHERE (url like '%sweetfields.herokuapp.com%')  ORDER BY "spree_stores"."id" ASC LIMIT 1

2016-03-10T22:17:59.621774+00:00 app[web.1]:   Spree::Store Load (2.0ms)  SELECT  "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = 't'  ORDER BY "spree_stores"."id" ASC LIMIT 1

2016-03-10T22:17:59.625280+00:00 app[web.1]:   Spree::Order Load (1.9ms)  SELECT  "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = $1 AND "spree_orders"."guest_token" = $2 AND "spree_orders"."store_id" = $3 AND "spree_orders"."user_id" = $4 LIMIT 1  [["currency", "USD"], ["guest_token", "5SpFgeset__xI3zwfaruvg"], ["store_id", 1], ["user_id", 1]]

2016-03-10T22:17:59.629457+00:00 app[web.1]:   Spree::Adjustment Load (2.1ms)  SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."adjustable_id" IN (1)  ORDER BY spree_adjustments.created_at ASC

2016-03-10T22:17:59.633701+00:00 app[web.1]:   Spree::Order Load (1.7ms)  SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."completed_at" IS NULL AND (id != 1)  [["user_id", 1]]

2016-03-10T22:17:59.636870+00:00 app[web.1]:   Spree::Order Load (2.0ms)  SELECT  "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."number" IS NULL LIMIT 1

2016-03-10T22:17:59.641592+00:00 app[web.1]:    (2.3ms)  SELECT COUNT(*) FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = $1 AND "spree_roles"."name" = $2  [["user_id", 1], ["name", "admin"]]

2016-03-10T22:17:59.645603+00:00 app[web.1]:    (1.8ms)  SELECT "spree_line_items"."id" FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  ORDER BY spree_line_items.created_at ASC  [["order_id", 1]]

2016-03-10T22:17:59.647373+00:00 app[web.1]:    (1.6ms)  BEGIN

2016-03-10T22:17:59.649793+00:00 app[web.1]:   Spree::LineItem Load (1.7ms)  SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1 AND "spree_line_items"."id" IN (1, 2)  ORDER BY spree_line_items.created_at ASC  [["order_id", 1]]

2016-03-10T22:17:59.653318+00:00 app[web.1]:   Spree::Order Exists (1.8ms)  SELECT  1 AS one FROM "spree_orders" WHERE ("spree_orders"."number" = 'R107374170' AND "spree_orders"."id" != 1) LIMIT 1

2016-03-10T22:17:59.657860+00:00 app[web.1]:   Spree::Payment Load (1.7ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.661396+00:00 app[web.1]:    (1.6ms)  COMMIT

2016-03-10T22:17:59.663913+00:00 app[web.1]:   Spree::LineItem Load (1.7ms)  SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  ORDER BY spree_line_items.created_at ASC  [["order_id", 1]]

2016-03-10T22:17:59.668934+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.672102+00:00 app[web.1]:   Spree::Payment Load (1.8ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND "spree_payments"."state" = $2  ORDER BY spree_payments.created_at  [["order_id", 1], ["state", "completed"]]

2016-03-10T22:17:59.674982+00:00 app[web.1]:    (1.7ms)  SELECT SUM(price * quantity) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.678276+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_shipments"."cost") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.681055+00:00 app[web.1]:   Spree::Adjustment Load (1.7ms)  SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.683518+00:00 app[web.1]:    (1.6ms)  SELECT SUM("spree_line_items"."adjustment_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.685976+00:00 app[web.1]:    (1.6ms)  SELECT SUM("spree_shipments"."adjustment_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.689126+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_adjustments"."amount") FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = $1 AND "spree_adjustments"."adjustable_type" = $2 AND "spree_adjustments"."eligible" = 't'  [["adjustable_id", 1], ["adjustable_type", "Spree::Order"]]

2016-03-10T22:17:59.691510+00:00 app[web.1]:    (1.6ms)  SELECT SUM("spree_line_items"."included_tax_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.693999+00:00 app[web.1]:    (1.6ms)  SELECT SUM("spree_shipments"."included_tax_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.696470+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."additional_tax_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.698952+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_shipments"."additional_tax_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.701410+00:00 app[web.1]:    (1.8ms)  SELECT SUM("spree_line_items"."promo_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.703773+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_shipments"."promo_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.706252+00:00 app[web.1]:    (1.6ms)  SELECT SUM("spree_adjustments"."amount") FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = $1 AND "spree_adjustments"."adjustable_type" = $2 AND "spree_adjustments"."source_type" = $3 AND "spree_adjustments"."eligible" = 't'  [["adjustable_id", 1], ["adjustable_type", "Spree::Order"], ["source_type", "Spree::PromotionAction"]]

2016-03-10T22:17:59.711226+00:00 app[web.1]:   SQL (2.4ms)  UPDATE "spree_orders" SET "payment_state" = NULL, "shipment_state" = NULL, "item_total" = 849.98, "item_count" = 2, "adjustment_total" = 0.0, "included_tax_total" = 0.0, "additional_tax_total" = 0.0, "payment_total" = 0.0, "shipment_total" = 0.0, "promo_total" = 0.0, "total" = 849.98, "updated_at" = '2016-03-10 22:17:59.706516' WHERE "spree_orders"."id" = $1  [["id", 1]]

2016-03-10T22:17:59.721469+00:00 app[web.1]:   Spree::Promotion Load (2.2ms)  SELECT * FROM ( SELECT "spree_promotions".* FROM "spree_promotions" INNER JOIN "spree_orders_promotions" ON "spree_promotions"."id" = "spree_orders_promotions"."promotion_id" WHERE "spree_orders_promotions"."order_id" = $1 AND (spree_promotions.starts_at IS NULL OR spree_promotions.starts_at < '2016-03-10 22:17:59.712094') AND (spree_promotions.expires_at IS NULL OR spree_promotions.expires_at > '2016-03-10 22:17:59.712279') UNION SELECT "spree_promotions".* FROM "spree_promotions" WHERE (spree_promotions.starts_at IS NULL OR spree_promotions.starts_at < '2016-03-10 22:17:59.712410') AND (spree_promotions.expires_at IS NULL OR spree_promotions.expires_at > '2016-03-10 22:17:59.712559') AND "spree_promotions"."code" IS NULL AND "spree_promotions"."path" IS NULL ) "spree_promotions"  [["order_id", 1]]

2016-03-10T22:17:59.724391+00:00 app[web.1]:   Spree::Shipment Exists (1.7ms)  SELECT  1 AS one FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1 LIMIT 1  [["order_id", 1]]

2016-03-10T22:17:59.727083+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."quantity") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.729990+00:00 app[web.1]:   Spree::Payment Load (1.6ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND "spree_payments"."state" = $2  ORDER BY spree_payments.created_at  [["order_id", 1], ["state", "completed"]]

2016-03-10T22:17:59.732394+00:00 app[web.1]:    (1.7ms)  SELECT SUM(price * quantity) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.735229+00:00 app[web.1]:    (1.6ms)  SELECT SUM("spree_shipments"."cost") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.738017+00:00 app[web.1]:   Spree::Adjustment Load (1.7ms)  SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.740993+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."adjustment_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.744181+00:00 app[web.1]:    (2.2ms)  SELECT SUM("spree_shipments"."adjustment_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.747433+00:00 app[web.1]:    (1.8ms)  SELECT SUM("spree_adjustments"."amount") FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = $1 AND "spree_adjustments"."adjustable_type" = $2 AND "spree_adjustments"."eligible" = 't'  [["adjustable_id", 1], ["adjustable_type", "Spree::Order"]]

2016-03-10T22:17:59.749921+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."included_tax_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.753177+00:00 app[web.1]:    (2.5ms)  SELECT SUM("spree_shipments"."included_tax_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.755724+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."additional_tax_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.758170+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_shipments"."additional_tax_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.760716+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_line_items"."promo_total") FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.763233+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_shipments"."promo_total") FROM "spree_shipments" WHERE "spree_shipments"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.766293+00:00 app[web.1]:    (1.7ms)  SELECT SUM("spree_adjustments"."amount") FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_id" = $1 AND "spree_adjustments"."adjustable_type" = $2 AND "spree_adjustments"."source_type" = $3 AND "spree_adjustments"."eligible" = 't'  [["adjustable_id", 1], ["adjustable_type", "Spree::Order"], ["source_type", "Spree::PromotionAction"]]

2016-03-10T22:17:59.771770+00:00 app[web.1]:   SQL (2.5ms)  UPDATE "spree_orders" SET "payment_state" = NULL, "shipment_state" = NULL, "item_total" = 849.98, "item_count" = 2, "adjustment_total" = 0.0, "included_tax_total" = 0.0, "additional_tax_total" = 0.0, "payment_total" = 0.0, "shipment_total" = 0.0, "promo_total" = 0.0, "total" = 849.98, "updated_at" = '2016-03-10 22:17:59.766637' WHERE "spree_orders"."id" = $1  [["id", 1]]

2016-03-10T22:17:59.775464+00:00 app[web.1]:   Spree::Payment Load (1.7ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.776345+00:00 app[web.1]: Redirected to https://sweetfields.herokuapp.com/shop/checkout/address

2016-03-10T22:17:59.776543+00:00 app[web.1]: Completed 302 Found in 170ms (ActiveRecord: 93.6ms)

2016-03-10T22:17:59.804826+00:00 app[web.1]: Started GET "/shop/checkout/address" for 100.14.176.16 at 2016-03-10 22:17:59 +0000

2016-03-10T22:17:59.807680+00:00 app[web.1]: Processing by Spree::CheckoutController#edit as HTML

2016-03-10T22:17:59.807702+00:00 app[web.1]:   Parameters: {"state"=>"address"}

2016-03-10T22:17:59.810478+00:00 app[web.1]:   Spree::Preference Load (1.6ms)  SELECT  "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1 LIMIT 1  [["key", "spree/frontend_configuration/locale"]]

2016-03-10T22:17:59.813903+00:00 app[web.1]:   Spree::User Load (1.8ms)  SELECT  "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."id" = $1  ORDER BY "spree_users"."id" ASC LIMIT 1  [["id", 1]]

2016-03-10T22:17:59.817323+00:00 app[web.1]:   Spree::Store Load (1.9ms)  SELECT  "spree_stores".* FROM "spree_stores" WHERE (url like '%sweetfields.herokuapp.com%')  ORDER BY "spree_stores"."id" ASC LIMIT 1

2016-03-10T22:17:59.819878+00:00 app[web.1]:   Spree::Store Load (1.8ms)  SELECT  "spree_stores".* FROM "spree_stores" WHERE "spree_stores"."default" = 't'  ORDER BY "spree_stores"."id" ASC LIMIT 1

2016-03-10T22:17:59.822691+00:00 app[web.1]:   Spree::Order Load (1.8ms)  SELECT  "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" IS NULL AND "spree_orders"."currency" = $1 AND "spree_orders"."guest_token" = $2 AND "spree_orders"."store_id" = $3 AND "spree_orders"."user_id" = $4 LIMIT 1  [["currency", "USD"], ["guest_token", "5SpFgeset__xI3zwfaruvg"], ["store_id", 1], ["user_id", 1]]

2016-03-10T22:17:59.826962+00:00 app[web.1]:   Spree::Adjustment Load (1.8ms)  SELECT "spree_adjustments".* FROM "spree_adjustments" WHERE "spree_adjustments"."adjustable_type" = 'Spree::Order' AND "spree_adjustments"."adjustable_id" IN (1)  ORDER BY spree_adjustments.created_at ASC

2016-03-10T22:17:59.830889+00:00 app[web.1]:   Spree::Order Load (1.8ms)  SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."user_id" = $1 AND "spree_orders"."completed_at" IS NULL AND (id != 1)  [["user_id", 1]]

2016-03-10T22:17:59.835197+00:00 app[web.1]:   Spree::Payment Load (1.7ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.836484+00:00 app[web.1]:   CACHE (0.0ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.837757+00:00 app[web.1]:   CACHE (0.0ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.838999+00:00 app[web.1]:   CACHE (0.0ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.842106+00:00 app[web.1]:    (1.7ms)  SELECT COUNT(*) FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  [["order_id", 1]]

2016-03-10T22:17:59.844483+00:00 app[web.1]:   Spree::LineItem Load (1.7ms)  SELECT "spree_line_items".* FROM "spree_line_items" WHERE "spree_line_items"."order_id" = $1  ORDER BY spree_line_items.created_at ASC  [["order_id", 1]]

2016-03-10T22:17:59.847586+00:00 app[web.1]:   Spree::Variant Load (1.7ms)  SELECT  "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = $1 LIMIT 1  [["id", 3]]

2016-03-10T22:17:59.852431+00:00 app[web.1]:    (1.9ms)  SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 3 AND "spree_stock_locations"."active" = 't'

2016-03-10T22:17:59.792822+00:00 heroku[router]: at=info method=POST path="/shop/cart" host=sweetfields.herokuapp.com request_id=ba5ede07-9b1d-414c-977a-1612dbd770ab fwd="100.14.176.16" dyno=web.1 connect=1ms service=181ms status=302 bytes=1057

2016-03-10T22:17:59.921245+00:00 heroku[router]: at=info method=GET path="/shop/checkout/address" host=sweetfields.herokuapp.com request_id=2edcac0b-4104-42b6-b6e9-7a0522fa1e6b fwd="100.14.176.16" dyno=web.1 connect=1ms service=106ms status=500 bytes=1754

2016-03-10T22:17:59.857196+00:00 app[web.1]:   Spree::StockItem Load (4.1ms)  SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 3 AND "spree_stock_locations"."active" = 't'

2016-03-10T22:17:59.859906+00:00 app[web.1]:   Spree::Variant Load (1.7ms)  SELECT  "spree_variants".* FROM "spree_variants" WHERE "spree_variants"."id" = $1 LIMIT 1  [["id", 2]]

2016-03-10T22:17:59.863164+00:00 app[web.1]:    (1.9ms)  SELECT SUM("spree_stock_items"."count_on_hand") FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 2 AND "spree_stock_locations"."active" = 't'

2016-03-10T22:17:59.865878+00:00 app[web.1]:   Spree::StockItem Load (1.9ms)  SELECT "spree_stock_items".* FROM "spree_stock_items" INNER JOIN "spree_stock_locations" ON "spree_stock_locations"."id" = "spree_stock_items"."stock_location_id" WHERE "spree_stock_items"."deleted_at" IS NULL AND "spree_stock_items"."variant_id" = 2 AND "spree_stock_locations"."active" = 't'

2016-03-10T22:17:59.867796+00:00 app[web.1]:   CACHE (0.0ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.871451+00:00 app[web.1]:   Spree::User Load (1.8ms)  SELECT  "spree_users".* FROM "spree_users" WHERE "spree_users"."deleted_at" IS NULL AND "spree_users"."id" = $1 LIMIT 1  [["id", 1]]

2016-03-10T22:17:59.874699+00:00 app[web.1]:   Spree::Country Load (1.8ms)  SELECT  "spree_countries".* FROM "spree_countries" WHERE "spree_countries"."id" = $1 LIMIT 1  [["id", 214]]

2016-03-10T22:17:59.877418+00:00 app[web.1]:   Spree::Country Load (2.0ms)  SELECT  "spree_countries".* FROM "spree_countries"  ORDER BY "spree_countries"."id" ASC LIMIT 1

2016-03-10T22:17:59.879573+00:00 app[web.1]:   CACHE (0.0ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.883867+00:00 app[web.1]:    (1.8ms)  SELECT COUNT(*) FROM "spree_roles" INNER JOIN "spree_roles_users" ON "spree_roles"."id" = "spree_roles_users"."role_id" WHERE "spree_roles_users"."user_id" = $1 AND "spree_roles"."name" = $2  [["user_id", 1], ["name", "admin"]]

2016-03-10T22:17:59.886145+00:00 app[web.1]:   Rendered vendor/bundle/ruby/2.2.0/gems/spree_frontend-3.0.5/app/views/spree/shared/_error_messages.html.erb (0.2ms)

2016-03-10T22:17:59.887656+00:00 app[web.1]:   CACHE (0.0ms)  SELECT "spree_payments".* FROM "spree_payments" WHERE "spree_payments"."order_id" = $1 AND ("spree_payments"."state" NOT IN ('failed', 'invalid'))  ORDER BY spree_payments.created_at  [["order_id", 1]]

2016-03-10T22:17:59.894578+00:00 app[web.1]:   Spree::Preference Load (1.7ms)  SELECT  "spree_preferences".* FROM "spree_preferences" WHERE "spree_preferences"."key" = $1 LIMIT 1  [["key", "spree/app_configuration/checkout_zone"]]

2016-03-10T22:17:59.898914+00:00 app[web.1]:   Spree::Zone Load (2.9ms)  SELECT  "spree_zones".* FROM "spree_zones" WHERE "spree_zones"."name" IS NULL LIMIT 1

2016-03-10T22:17:59.901207+00:00 app[web.1]:   Spree::Country Load (1.7ms)  SELECT "spree_countries".* FROM "spree_countries"

2016-03-10T22:17:59.903172+00:00 app[web.1]:   Rendered spree/address/_form.html.erb (13.4ms)

2016-03-10T22:17:59.903295+00:00 app[web.1]:   Rendered spree/checkout/_address.html.erb (14.0ms)

2016-03-10T22:17:59.903406+00:00 app[web.1]:   Rendered spree/checkout/edit.html.erb within spree/layouts/spree_application (17.9ms)

2016-03-10T22:17:59.903686+00:00 app[web.1]: Completed 500 Internal Server Error in 96ms (ActiveRecord: 44.6ms)

2016-03-10T22:17:59.905857+00:00 app[web.1]: 

2016-03-10T22:17:59.905871+00:00 app[web.1]: ActionView::Template::Error (undefined method `states' for nil:NilClass):

2016-03-10T22:17:59.905872+00:00 app[web.1]:     35: 

2016-03-10T22:17:59.905873+00:00 app[web.1]:     36:   <% if Spree::Config[:address_requires_state] %>

2016-03-10T22:17:59.905874+00:00 app[web.1]:     37:     <p class="field" id=<%="#{address_id}state" %>>

2016-03-10T22:17:59.905874+00:00 app[web.1]:     38:       <% have_states = !address.country.states.empty? %>

2016-03-10T22:17:59.905875+00:00 app[web.1]:     39:       <%= form.label :state, Spree.t(:state) %><span class='required' id=<%="#{address_id}state-required"%>>*</span><br/>

2016-03-10T22:17:59.905876+00:00 app[web.1]:     40: 

2016-03-10T22:17:59.905877+00:00 app[web.1]:     41:       <% state_elements = [

2016-03-10T22:17:59.905880+00:00 app[web.1]:   app/views/spree/address/_form.html.erb:38:in `_ff84f75278908ec5181327c5c0bd7eec'

2016-03-10T22:17:59.905880+00:00 app[web.1]:   app/views/spree/checkout/_address.html.erb:6:in `block in _9ba1ebb6c1a0bfe6c5699673873e0890'

2016-03-10T22:17:59.905881+00:00 app[web.1]:   app/views/spree/checkout/_address.html.erb:4:in `_9ba1ebb6c1a0bfe6c5699673873e0890'

2016-03-10T22:17:59.905882+00:00 app[web.1]:   app/views/spree/checkout/edit.html.erb:20:in `block in _3b87d06f67cd67c75e13475bf1de88d1'

2016-03-10T22:17:59.905882+00:00 app[web.1]:   app/views/spree/checkout/edit.html.erb:13:in `_3b87d06f67cd67c75e13475bf1de88d1'

2016-03-10T22:17:59.905883+00:00 app[web.1]: 

2016-03-10T22:17:59.905884+00:00 app[web.1]: 

[Barbara Donnini]

I just discovered something new! I was working on something unrelated on the site and came across this error when I went to the shop page in my LOCAL server (NOT the deployed Heroku app):

I think I had this issue before, I don't know if it's related to the other current issues or not, but I had a feeling my paperclip/amazon s3 wasn't set up correctly. I followed the instructions exactly (I sent my spree.rb file in a previous post) I'm not sure where I'm going wrong!

 

[Barbara Donnini]

Hi Jason and Shel,

Do you guys have any idea where I'm going wrong? Honestly at this point, Jason if you want the username and password to my c9 account to login and poke around I'd be more than happy to give it to you if it's easier and can help get this Spree cart launched faster (and fixed for good!)

Thanks,

Barbara