Problem with mysql connector adding "s" to the end of querries

I am a beginner with ruby and was working through some basic examples
from Onlamp where I create a basic controller and model, use the
scaffold command, and edit my database.yml file to point it to the
correct database.

The problem I am having is that no matter what I do, I continue to get
a mysql db connection error when I web to application. It seems that my
connector is trying to connect to "infos" instead of "info".

I deleted everything and started fresh, using other file names and it
does the same thing; tries to connect to the "tests" table instead of
the "test" table in my DB.

As a cheezy workaround, I created a table in my DB called "infos" and
created my controller and model named "info" and everything works since
it automatically adds the "s" to the table name.

Can anyone please point me in the right direction my obvious
misconfiguration?

thanks

jackster wrote:

I am a beginner with ruby and was working through some basic examples
from Onlamp where I create a basic controller and model, use the
scaffold command, and edit my database.yml file to point it to the
correct database.

The problem I am having is that no matter what I do, I continue to get
a mysql db connection error when I web to application. It seems that my
connector is trying to connect to "infos" instead of "info".

I deleted everything and started fresh, using other file names and it
does the same thing; tries to connect to the "tests" table instead of
the "test" table in my DB.

As a cheezy workaround, I created a table in my DB called "infos" and
created my controller and model named "info" and everything works since
it automatically adds the "s" to the table name.

Can anyone please point me in the right direction my obvious
misconfiguration?

Sorry for the late reply - it has taken ten days for Google Groups to deliver your message.

You haven't any misconfiguration: unless you tell it not to, Rails expects table names to be plural, and class names to be singular. Look again at the ONLamp articles - you should find that they follow this pattern.

regards

   Justin Forder