comments icon indicating copy to clipboard operation
comments copied to clipboard

Long URL cannot be saved

Open pl-mnm opened this issue 9 months ago • 1 comments

Describe the bug

Comments on entry with a long URL are not getting saved:

https://example.site/%E0%A4%B2%E0%A4%BF%E0%A4%96%E0%A5%87-%E0%A4%9C%E0%A5%8B-%E0%A4%96%E0%A4%BC%E0%A4%A4-%E0%A4%AE%E0%A5%81%E0%A4%9D%E0%A5%87-%E0%A4%AE%E0%A4%AF%E0%A5%82%E0%A4%B0-%E0%A4%A4%E0%A5%8D%E0%A4%B0%E0%A4%BF%E0%A4%B5%E0%A5%87%E0%A4%A6%E0%A5%80-%E0%A4%95%E0%A5%87-%E0%A4%B8%E0%A4%BE%E0%A4%A5-likhe-jo-khat-mujhe-with-mayur-trivedi/%E0%A4%A6%E0%A4%BF%E0%A4%B2-%E0%A4%95%E0%A5%80-%E0%A4%86%E0%A4%B5%E0%A4%BE%E0%A4%9C%E0%A4%BC%E0%A5%87%E0%A4%82-sounds-of-the-heart

Next yii\db\Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'url' at row 1
The SQL being executed was: INSERT INTO `comments_comments` (`id`, `ownerId`, `ownerSiteId`, `userId`, `status`, `name`, `email`, `comment`, `url`, `ipAddress`, `userAgent`, `commentDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES (1555808, 1553710, 1, NULL, 'pending', 'Sample Visitor', '[email protected]', 'Very interesting article thank you. I really enjoyed it.', 'https://example.site/%[redacted]%82-sounds-of-the-heart', '172.18.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '2025-02-26 03:49:55', '2025-02-26 03:49:55', '2025-02-26 03:49:55', '3c3937c3-bf10-4867-9517-1099ff8e4fa6') in /var/www/html/vendor/yiisoft/yii2/db/Schema.php:676

Steps to reproduce

  1. Create an entry with a long slug
  2. Add a comment

Craft CMS version

5.5.8

Plugin version

3.0.4

Multi-site?

No

Additional context

No response

pl-mnm avatar Feb 27 '25 03:02 pl-mnm

Fixed for the next release. To get this early, run composer require verbb/comments:"dev-craft-5 as 3.0.4".

engram-design avatar Feb 27 '25 04:02 engram-design

Updated in 3.0.5.

engram-design avatar Jul 18 '25 14:07 engram-design