why i am getting this error

rubyonrails-talk
1

hi!! i am a newbie in ROR, I am getting this error i understand what the error says but don'y know why i am getting this error.

ActiveRecord::StatementInvalid in UserController#new

Mysql::Error: Table 'user.users' doesn't exist: SHOW FULL FIELDS FROM `users`

  def new     @user = User.new    end

  def edit

my user controller file contains :-

class UserController < ApplicationController

  def index   end

  def show   end

  def new     @user = User.new    end

  def edit   end

  def update   end

  def destroy   end

  def home   end

  def create   end end

user model contains:-

class User < ActiveRecord::Base end

i have created the databases name user and a table named user_info but still i am getting this error.

can someone please help me with this error

also can someone please explain the naming rules for model and controller.

Thanks's in Advance :slight_smile:

2

you are going in wrong way dud , you should have the users table

you are creating model name user which is finding the table user and that is not their change the table name from user_info to users

you will get your answer :slight_smile:

3

Arvind Vyas wrote in post #1108369:

you are going in wrong way dud , you should have the users table

you are creating model name user which is finding the table user and that is not their change the table name from user_info to users you will get your answer :slight_smile:

hey!! thanks for the reply.. could you please explain me the naming conventions for model and controller i am a bit confused with it..

Thanks.. :slight_smile:

4

go through this tutorials http://guides.rubyonrails.org/getting_started.html

5

Take the model name and pluralize it.

User model is "users" table Company model is "companies" table.

These tables should be created using migrations, not manually in the database by yourself.

Have a read of this:

6

I suggest working right through a good tutorial such as railstutorial.org (which is free to use online). That will show you the basics of Rails.

Colin

7

Try this for the naming conventions

http://itsignals.cascadia.com.au/?p=7

8

Try this for the naming conventions

Index of /

hi!! i am a newbie in ROR, I am getting this error i understand what the error says but don'y know why i am getting this error.

...

i have created the databases name user and a table named user_info but still i am getting this error.

can someone please help me with this error

also can someone please explain the naming rules for model and controller.

Thanks's in Advance :slight_smile:

No, look, really, just STOP banging away and take Colin's excellent advice. Work ALL THE WAY through the tutorial FIRST.