Data truncated for column
From Kolmisoft Wiki
Jump to navigationJump to search
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