Problem with MYSQL (INSERT)

Question

i have model question with text and token fields. Want to add data into this via scaffold.

This is my question_ controller

  def create
    # @question = Question.new(params[:question])
      @question = Question.create(:text => params[:text], :security_token => Digest::SHA1.hexdigest(rand(1000000).to_s))
    render :json => @question.to_ext_json(:success => @question.save)
  end

When i press "ADD" button i get in console this:

  Question Create (0.0ms)   Mysql::Error: Column 'text' cannot be null: INSERT INTO `questions` (`created_at`, `updated_at`, `text`, `security_token`) VALUES('2011-04-05 09:07:37', '2011-04-05 09:07:37', NULL, 'bf44551f11ce202b88d521a1826ab6db4254ce55')

Why COlumn 'text' can't be null?

It can't be null because table definition doesn't allow it to be null. Also, it's bad practice to use reserved words for column names in MySQL. Alter your table and remove "NOT NULL" part for that particular column definition. — Michael J.V.
– Michael J.V., Commented Apr 5, 2011 at 9:15

Malte · Accepted Answer · 2011-04-05 09:21:57Z

1

You created the text column for the questions table with a NOT NULL constraint, and params[:text] is probably nil.

Since you used the scaffolding form params[:question][:text] returns the contents for text, not params[:text]!

edited Apr 5, 2011 at 9:21

answered Apr 5, 2011 at 9:16

Malte

1,20010 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

honeyp0t · Accepted Answer · 2011-04-05 09:14:49Z

0

Because the column in the database table is defined as 'not null'?

answered Apr 5, 2011 at 9:14

honeyp0t

9271 gold badge8 silver badges17 bronze badges

Comments

Sebastian Zaklada · Accepted Answer · 2011-04-05 09:17:37Z

0

You are passing an empty text value (NULL/nil) to a database field which has NOT NULL constraint defined. You need to either ensure, that text is never empty or release this constraint, allowing NULLable fiels in the MySQL database.

answered Apr 5, 2011 at 9:17

Sebastian Zaklada

2,4041 gold badge15 silver badges26 bronze badges

Comments

Neelesh · Accepted Answer · 2011-04-05 09:24:40Z

0

I would suggest that you add a validation in your model to verify if text is null. as such, you will be spared from this low level error.

answered Apr 5, 2011 at 9:24

Neelesh

5063 silver badges17 bronze badges

Comments

sameera207 · Accepted Answer · 2011-04-05 10:26:00Z

0

This error is nothing to do with ruby or rails, its just because you have defined the column as not null (.. as everybody says... :D ) , You might want to check your migration to see if you defined the column as not null there..

cheers

sameera

answered Apr 5, 2011 at 10:26

sameera207

16.6k20 gold badges92 silver badges156 bronze badges

Collectives™ on Stack Overflow

Problem with MYSQL (INSERT)

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related