Field 'operation' limited to 64 char and 'reference' to 128 char but nowhere trimming.

I have similar errors:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'operation' at row 1: INSERT INTO {userpoints_txn} (uid, points, time_stamp, changed, status, description, reference, expirydate, expired, parent_txn_id, tid, entity_id, entity_type, operation) 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, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 370 [:db_insert_placeholder_1] => -10 [:db_insert_placeholder_2] => 1354088790 [:db_insert_placeholder_3] => 1354088790 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 0 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 134 [:db_insert_placeholder_12] => user [:db_insert_placeholder_13] => Пользователь Дмитрий Константинович к вам равнодушен )

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'reference' at row 1: INSERT INTO {userpoints_txn} (uid, points, time_stamp, changed, status, description, reference, expirydate, expired, parent_txn_id, tid, entity_id, entity_type, operation) 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, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 339 [:db_insert_placeholder_1] => 5 [:db_insert_placeholder_2] => 1354088825 [:db_insert_placeholder_3] => 1354088825 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://xn--80aafa8brbojh.xn--p1ai/users/%D0%B4%D0%BC%D0%B8%D1%82%D1%80%D0%B8%D0%B9-%D0%BA%D0%BE%D0%BD%D1%81%D1%82%D0%B0%D0%BD%D1%82%D0%B8%D0%BD%D0%BE%D0%B2%D0%B8%D1%87 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 0 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 134 [:db_insert_placeholder_12] => user [:db_insert_placeholder_13] => Ваше слово нравится Дмитрий Константинович )

CommentFileSizeAuthor
#4 too_long_data_operation.patch761 bytesvanessakovalsky

Comments

drakmor’s picture

Version: 7.x-2.x-dev » 7.x-1.x-dev

Sorry, bug related to 7.x-1.x-dev.

29axe’s picture

Version: 7.x-1.x-dev » 7.x-1.0

Same error with working version : 7.x-1.0.
Is there a way to update to 7.x-2.x-dev? because not available in project page.

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'operation' at row 1: INSERT INTO {userpoints_txn} (uid, points, time_stamp, changed, status, description, reference, expirydate, expired, parent_txn_id, tid, entity_id, entity_type, operation) 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, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13); Array ( [:db_insert_placeholder_0] => 5 [:db_insert_placeholder_1] => 3 [:db_insert_placeholder_2] => 1377434064 [:db_insert_placeholder_3] => 1377434064 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 0 [:db_insert_placeholder_9] => 0 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 10 [:db_insert_placeholder_12] => comment [:db_insert_placeholder_13] => user received 3 points for posting a comment : 10 ) in drupal_write_record() (line 7166 of C:\wamp\www\includes\common.inc).

xzabre’s picture

Any updates here? Having the problem at the moment. Is there a way to solve this issue?

Solved: I changed the field value in my database from max 48 characters to 128 characters.

vanessakovalsky’s picture

Issue summary: View changes
StatusFileSize
new761 bytes

Same problem for me.
I'v attached a patch to change the size of the 'operation' colum when you install Userpoints.