MySQL error: Field doesn’t have a default value – ClipBucket – Clip-bucket

Download PDF

Clip-bucket Field ‘action_link’ doesn’t have a default value

or

MySQL error: Field doesn’t have a default value

When inserting a new record with varchar or text field that is required and has no default value. This error will display for example:error : Field ‘description’ doesn’t have a default value

The possible reason is that sql-mode in my.ini is set to STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION.

Change the value to
sql-mode = “”

Update 2011/4/25:
Add Default value “” if possible to avoid changing mysql setting.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply