Error: Data too long for column 'PS_TO' at row 1
PostPosted:Tue Apr 03, 2018 1:16 pm
We are getting the error when trying to send document subscriptions to several users at once:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PS_TO' at row 1I did some digging and found this:
Code: Select all
Can I edit the Type for PS_TO to allow more than 64?Database changed
mysql> show columns from OKM_PROP_SUB_SENT;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| PS_ID | bigint(20) | NO | PRI | NULL | auto_increment |
| PS_FROM | varchar(64) | NO | | NULL | |
| PS_TO | varchar(64) | NO | | NULL | |
| PS_USER | varchar(64) | NO | | NULL | |
| PS_NODE | varchar(64) | NO | | NULL | |
| PS_TYPE | varchar(16) | NO | | NULL | |
| PS_COMMENT | longtext | YES | | NULL | |
| PS_SENT_DATE | datetime | NO | | NULL | |
+--------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)