Tuesday, March 17, 2015

Mysql::Error: Data too long for column 'description' at row 1

SHOW GLOBAL VARIABLES like 'table_definition_cache';

SHOW GLOBAL VARIABLES like 'table_open_cache';
SHOW GLOBAL VARIABLES like 'table_open_cache_instances';

 SET @@GLOBAL.table_definition_cache=4800;
 SET @@GLOBAL.table_open_cache=4800;

 -- if a table restrict you to insert data becasue the length is smaller and
 -- you realy want to get rid of the restriction
-- do this

show global variables like '%sql%mode';

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

set global sql_mode='NO_ENGINE_SUBSTITUTION';
SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';

-- also set it here -- /etc/my.cnf

-- http://dev.mysql.com/doc/refman/5.6/en/sql-mode.html

No comments:

Post a Comment