Jump to content

Pages, comment data type in DB too small

Go to solution Solved by Marc,

Recommended Posts


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.

Link to comment
Share on other sites

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 by PatrickRQ
Link to comment
Share on other sites

  • 1 month later...
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...