Data truncated for column

From Kolmisoft Wiki
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Example:

SQL (1.6ms)  INSERT INTO `devices` (`auth`, `calleridpres`, `context`, `control_c....
  (0.6ms)  ROLLBACK
--- !ruby/exception:Mysql2::Error
message: Data truncated for column 'calleridpres' at row 1
error_number: 1265
sql_state: '01000'
/usr/local/rvm/gems/ruby-2.0.0-p247@x5/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:286:in `query'
/usr/local/rvm/gems/ruby-2.0.0-p247@x5/gems/activerecord-4.0.0/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:286:in `block in execute'

Fix:

In /home/mor/config/database.yml make sure there is

production:
   strict: false