I have an import with quite a lot of fields mapped.

When i try to add an additional mapping field I get the error "Data truncated. Data too long for column..."

Solution is to set the config column size to big.
Attaching patch in first comment.

Comments

Priority:Normal» Major
Status:Active» Needs review
StatusFileSize
new851 bytes

Patch.

Also changing priority to major since this completely breaks functionality once reaching a certain config size.

StatusFileSize
new852 bytes

Whoops, missing comma...

Status:Needs review» Needs work

hook_schema needs to be updated as well. Also, while we're at it, let's change from text to blob. Would it make more sense to split the configs into three separate columns? How many mappings do you have?

Status:Needs work» Needs review
StatusFileSize
new1.79 KB

I don't think it's necessary to split into 3 columns.
MySQL longblob/longtext columns can hold 4GB of data.
That should suffice.

I'm attaching a patch that changes both config fields to blob.

It's probably not necessary to change the source config to big,
but let's make them consistent.

Are the changes ok for you twistor?

As stated (and closed as duplicate) here: http://drupal.org/node/1736438 I'd like to see this changed too :-)

Bumping...

Status:Needs review» Patch (to be ported)

How many mappings do you have?

About 320.

It seems db_change_field() didn't work for SQL server - #1828950: Update to alpha7 database update fails on MSSQL