Plots2: ActiveRecord::Fixture::FixtureError: table "comments" has no column named "reply_to".

[cesswairimu]

I just rebase my branch with the latest master and now all my tests are failing with this error

ActiveRecord::Fixture::FixtureError:         ActiveRecord::Fixture::FixtureError: table "comments" has no column named "reply_to".

:confused: Anyone else experiencing this? Any ideas for fixes or causes?

[grvsachdeva]

Mentioning @jywarren @ViditChitkara as this issue seems related to https://github.com/publiclab/plots2/pull/4537/ . Thanks!

[jywarren]

Ah, there was a new migration added - i think you need to run rake db:migrate!

On Wed, Mar 20, 2019 at 4:27 PM Cess [e-mail] wrote:

I just rebase my branch with the latest master and now all my tests are
failing with this error

ActiveRecord::Fixture::FixtureError: ActiveRecord::Fixture::FixtureError: table "comments" has no column named "reply_to".

😕 Anyone else experiencing this? Any ideas for fixes or causes?

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/publiclab/plots2/issues/5207, or mute the thread
https://github.com/notifications/unsubscribe-auth/AABfJw71BfS0P1hJNFvv_n-2QBD3m3Siks5vYpl8gaJpZM4cAMm6
.

[grvsachdeva]

tried that, no success

[cesswairimu]

Seems we do not really have reply_to column in env test.
model from console in test

Comment
  cid: integer
  pid: integer
  nid: integer
  uid: integer
  subject: string
  comment: text
  hostname: string
  timestamp: integer
  status: integer
  format: integer
  thread: string
  name: string
  mail: string
  homepage: string
  aid: integer
  comment_via: integer
  message_id: string
  belongs_to :answer (foreign_key :aid)
  belongs_to :node (foreign_key :nid)
  belongs_to :user (foreign_key :uid)
  has_many :likes
  has_many :replied_comments (class_name :Comment, foreign_key :reply_to)

in development environment

Comment
  cid: integer
  pid: integer
  nid: integer
  uid: integer
  subject: string
  comment: text
  hostname: string
  timestamp: integer
  status: integer
  format: integer
  thread: string
  name: string
  mail: string
  homepage: string
  aid: integer
  comment_via: integer
  message_id: string
  tweet_id: string
  reply_to: integer
  belongs_to :answer (foreign_key :aid)
  belongs_to :node (foreign_key :nid)
  belongs_to :user (foreign_key :uid)
  has_many :likes
  has_many :replied_comments (class_name :Comment, foreign_key :reply_to)

:thinking:

[jywarren]

Hi Cess, the new migration should create the reply_to column, did it not work?

[cesswairimu]

It did not create one on the test env just the dev env

[jywarren]

Oh, hmm. @ViditChitkara - do you know why the migration may not be running
for @cesswairimu? If the schema.rb file is correct, it should be used to
run tests, right?

On Tue, Mar 26, 2019 at 9:14 AM Cess [e-mail] wrote:

It did not create one on the test env just the dev env

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/publiclab/plots2/issues/5207#issuecomment-476625307,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AABfJ-ba-7cSXJdKNGFHoUuV44L6IB_Mks5vah0cgaJpZM4cAMm6
.

[rhiroe]

Hello, I'm Japanese.
I don't understand English well, so I use Google Translate as a reference.
I can't write English well, but please forgive me.

Specify a test environment and try to migrate.

$ RAILS_ENV=test rake db:migrate

Or reset.

$ RAILS_ENV=test rake db:migrate:reset

However, since I'm a beginner, It is just a suggestion.
I hope you will find it useful.

[cesswairimu]

This solved it thanks so much @eRy-sk

[grvsachdeva]

Hey @eRy-sk we would love to have more help from you if you're interested -https://github.com/publiclab/plots2/issues/ . Thanks!