Hi.

I used the iban field and the validation is good, but when the data is saved, i receive the following mysql error message:
'PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_bank_account_iban_field' at row 1'.

I see in depth and i find the reason of the problem. The max length that is allowed for the field is 22, but there exists more lengths available. I solved it changing the max length allowed.

In addition, i added a hook_update for update the existing instances of the field, in order to add that length.

CommentFileSizeAuthor
#3 iban_field-max-length.patch1.92 KBomarlopesino
iban_field-max-length.patch1.86 KBomarlopesino

Comments

omarlopesino’s picture

omarlopesino
he/him
commented
Status: Active » Needs review
omarlopesino’s picture

omarlopesino
he/him
commented

One thing i forgot to say: i found the max length in the module's file 'iban_field.csv'.

omarlopesino’s picture

omarlopesino
he/him
commented
StatusFileSize
new iban_field-max-length.patch1.92 KB
espurnes’s picture

espurnes
Primary language Catalan
commented

I tested the module 7.x-1.0 (at simplytest.me) and I've got the same ERROR.
Using the patch #3 solved the problem.

Thank you mistermoper.

Error I've got:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'field_iban2_iban_field' at row 1: INSERT INTO {field_data_field_iban2} (entity_type, entity_id, revision_id, bundle, delta, language, field_iban2_iban_field) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 2 [:db_insert_placeholder_2] => 2 [:db_insert_placeholder_3] => page [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => ES1020903200500041045040 ) in field_sql_storage_field_storage_write() (line 494 of /home/sc6c4971efc9fb7c/www/modules/field/modules/field_sql_storage/field_sql_storage.module).

strakkie’s picture

strakkie commented
Version: 7.x-1.x-dev » 7.x-1.0
Assigned: Unassigned » strakkie
Status: Needs review » Patch (to be ported)

Hi mistermoper,

Thanks a lot for the work you put into this. I have tested the patch included in #3 and will commit these changes in version 1.1 of the module.

strakkie’s picture

strakkie commented
Status: Patch (to be ported) » Reviewed & tested by the community

Wrong status selected.

strakkie’s picture

strakkie commented
Status: Reviewed & tested by the community » Closed (fixed)

Fixed in 1.1 release.