Hi everyone,
I am just starting with rails, and s...
# supportf
Fred Jeanne
04/05/2023, 4:44 PMHi everyone,
I am just starting with rails, and solidus. No problem on localhost, but I don't understand why I have this error on Heroku logs :
Completed 500 Internal Server Error ActiveRecord::StatementInvalid (Could not find table 'spree_stores'): app/controllers/home_controller.rb8in `index'
hope someone could help me ! thanks !
j
Jared Norman
04/05/2023, 4:46 PM
Sounds like you have run your migrations/loaded your schema in production.
f
Fred Jeanne
04/05/2023, 4:54 PMscuse me if i don't understand... I am really starting. You mean that i don't have to to do "heroku run rails db:migrate" ?
j
Jared Norman
04/05/2023, 4:59 PM
sorry, I meant "haven't" 🤦🏻♂️
Jared Norman
04/05/2023, 5:00 PM
it sounds like you have not run your migrations/loaded your schema on production
f
Fred Jeanne
04/05/2023, 5:00 PMFred Jeanne
04/05/2023, 5:00 PMthat's why i don't understand what's going on...
j
Jared Norman
04/05/2023, 5:00 PM
are you sure they actually ran successfully? If they did, you'd have a spree_stores table.
f
Fred Jeanne
04/05/2023, 5:01 PMI am sure
Fred Jeanne
04/05/2023, 5:01 PMand the table is present in production
Fred Jeanne
04/05/2023, 5:07 PMI, [2023-04-05T170643.931962 #2] INFO -- : Migrating to AddBccEmailToSpreeStores (20230405154569)
== 20230405154569 AddBccEmailToSpreeStores: migrating =========================
-- add_column(:spree_stores, :bcc_email, :string)
-> 0.0015s
== 20230405154569 AddBccEmailToSpreeStores: migrated (0.0015s) ================
Fred Jeanne
04/05/2023, 5:09 PM-- create_table("spree_stores", {force=>cascade, id=>integer})
-> 0.0008s
j
Jared Norman
04/05/2023, 5:17 PM
what database are you using?
f
Fred Jeanne
04/05/2023, 5:17 PMproduction:
<<: *default
database: db/production.sqlite3
Fred Jeanne
04/05/2023, 5:18 PMand storage
cloudinary:
service: Cloudinary
folder: <%= Rails.env %>
j
Jared Norman
04/05/2023, 5:18 PM
I doubt you are actually using SQLite, as Heroku normally sets up Postgres for you.
Jared Norman
04/05/2023, 5:18 PM
However, if you are actually using SQLite, that would explain your problem: you can't use SQLite in production.
f
Fred Jeanne
04/05/2023, 5:18 PMcan i use postgres ?
j
Jared Norman
04/05/2023, 5:19 PM
Yeah, you should use Postgres.
f
Fred Jeanne
04/05/2023, 5:20 PMI am goinna try, thank a lot Jared !
sg thumbs up 1
Fred Jeanne
04/06/2023, 11:19 AMit works now, thanks
Fred Jeanne
04/06/2023, 11:19 AMi am just trying to change the home page; but impossible to change the root of the store...
Fred Jeanne
04/06/2023, 11:19 AMroute