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] => Ваше слово нравится Дмитрий Константинович )
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | too_long_data_operation.patch | 761 bytes | vanessakovalsky |
Comments
Comment #1
drakmor commentedSorry, bug related to 7.x-1.x-dev.
Comment #2
29axe commentedSame 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).Comment #3
xzabre commentedAny 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.
Comment #4
vanessakovalsky commentedSame problem for me.
I'v attached a patch to change the size of the 'operation' colum when you install Userpoints.