There is field with length of varchar(20000) and its failed to convert that field and further execution stopped!
Error message as below :
Converting table: field_data_field_somename
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column [error]
'field_somename_value' (max = 16383); use BLOB or TEXT instead'

Comments

anbarasan.r created an issue.

dkh’s picture

dkh commented

I'm having the same issue:

exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'field_bio_puburl_value' (max = 16383); [error]
use BLOB or TEXT instead' in /Users/dhaley/html/energysciences/includes/database/database.inc:2227

BUT, I was able to solve my issue on the mysql side with this table alter (don't forget the associated revision table):

ALTER TABLE field_data_field_bio_puburl MODIFY field_bio_puburl_value TEXT NULL;
ALTER TABLE field_revision_field_bio_puburl MODIFY field_bio_puburl_value TEXT NULL;

In my case, changing the column from varchar with to text was an acceptable solution.

anbarasan.r’s picture

anbarasan.r commented

I solved this issue by reducing the varchar limit to 255.