• Error: Data too long for column 'PS_TO' at row 1

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #45600  by dferguson
 
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 1
I did some digging and found this:
Code: Select all
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)
Can I edit the Type for PS_TO to allow more than 64?

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.