rails 3 not pluralizing table name

Question

I am trying to migrate from rails 2 to rails 3.

I am facing a strange problem.

The whole of application doesn't seem to pluralize the table names.

Mysql::Error: Table 'r_database.country_data' doesn't exist:

But my table has country_datas as the name.

App was working perfectly in rails 2.

I have another rails 3 app. that works fine.. so nothing to do with my OS or rails configuration — Gaurav Shah, Aug 22 '11 at 07:12
can you put your Gemfile in here? And can you put the backtrace of the error? — Michael Koper, Aug 22 '11 at 07:13

score 7 · Accepted Answer · answered Aug 22 '11 at 07:13

7

rails 3 recognizes that (in english) data is already plural. you'll have to either add a custom inflection in initializers, or use set_table_name "country_datas" in your model.

answered Aug 22 '11 at 07:13

Michael Johnston

5,298
1
29
37

I think indeed set_table_name is the right thing to do here. custom inflections could be bad for other translations. – Michael Koper Aug 22 '11 at 07:16
Yes.. I would rather run a migration to rename the table itself.. :) – Gaurav Shah Aug 22 '11 at 07:17
@Gaurav: even though I am a native english speaker, I will name a variable that is a collection xxxx_datas rather than xxxx_data. Too confusing otherwise – Michael Johnston Aug 22 '11 at 07:21

rails 3 not pluralizing table name

1 Answers1