Posted February 15, 20232 yr Hello, I tried to post a long comment for a record created within Pages database and fall into the issue: IPS\Db\Exception: Data too long for column 'comment_post' at row 1 (1406) The database_comment table has comment_post column of TEXT data type which is 65535 in length. Consider changing it to to MEDIUMTEXT or LONGTEXT to avoid such scenarios. Thanks.
February 15, 20232 yr Community Expert Please could you advise on which database is this on your system, so I can take a look?
February 15, 20232 yr Just now, PatrickRQ said: What do you mean on which database? This is MySQL, InnoDB. Pages database.
February 15, 20232 yr Author 7 minutes ago, Adriano Faria said: Pages database. Pages creates own table aka cms_database_x and the issue I mention is in database_comment table comment_post column. On the top of that, seems there is no protection that would check data length before attempting to INSERT data to DB, what results now in throwing an error. Edited February 15, 20232 yr by PatrickRQ
February 15, 20232 yr Community Expert Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.
April 4, 20232 yr Community Expert Solution This issue has been resolved in our recently released 4.7.9 version. Please upgrade if you are seeing this issue, and let us know if you see any further issues.