LearnHotwire Course - stuck with Could not find table 'solid_queue_processes'

Hi all,

I bought the Learn Hotwire course and stuck at the Rails Application Introduction (3rd video).

When I ran "rails s" at 1.29 minute of the video, I got this error

'ActiveRecord::ConnectionAdapters::SQLite3Adapter#table_structure': Could not find table 'solid_queue_processes' (ActiveRecord::StatementInvalid)

I have tested rails 8.0.1 or even 8.0.2. No difference.

But I found out this post https://www.reddit.com/r/rails/comments/1gmkouh/solid_queue_in_new_rails_8_project/ and tried these steps

bin/rails db:drop
bin/rails db:create
bin/rails solid_queue:install // this wiil overwrite the queue_schema.rb
bin/rails db:prepare

When I ran "rail s", no more error.

When I compare the diff between this queue_schema.rb before and after change, I noticed the overwritten file using ActiveRecord::Schema[7.1] and the original file was 8.0. There are also other changes on indexes.

Anyway, how do I get to follow exactly like the video? Thanks.

Hey Eric! Thanks for checking out the course and sorry for the issue you had getting the app running though I'm glad to hear that you were able to get past it. If you wish to follow along with the videos and code on the app yourself you'll want to checkout the first commit in the repository locally so that your app will be at the starting point of the project as opposed to the finished app. You can do that by running git checkout d966d4f.

I've also updated the README on the rails repository for the course to reflect running the needed database step, thanks for writing in about this one!

Thanks, it works now. I did run git checkout d966d4f when I first posted this, but I'm not sure why it didn’t work then and does now. Anyway, it’s working—thanks again! :)