Closed
Description
What happened?
Description
Got a Database Exception when using "Field Limit" of a just created and saved new "Plain Text Field".
Database Exception – [yii\db\Exception](https://www.yiiframework.com/doc-2.0/yii-db-exception.html)
SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
The SQL being executed was: ALTER TABLE `content` ADD `field_assetDownloadName_hdmffqxr` varchar(200)
Error Info: Array
(
[0] => 42000
[1] => 1118
[2] => Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
)
↵
Caused by: PDOException
SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
in /var/www/html/vendor/yiisoft/yii2/db/Command.php at line 1302
Steps to reproduce
- Create a new "Plain Text Field"
- Safe
- Set the option "Field Limit" (in my case 50)
Expected behavior
no Database Exception
Actual behavior
- Database Exception
- Reload after Database Exception, see pdf
Database Exception – yii_db_Exception.pdf
Can send you config.json and DB, if needed.
Craft CMS version
Craft Pro 4.4.5
PHP version
8.1.13
Operating system and version
Linux 5.15.49-linuxkit (DDEV)
Database type and version
MySQL 5.7.38
Image driver and version
Imagick 3.7.0 (ImageMagick 6.9.11-60)
Installed plugins and versions
- "carlcs/craft-redactorcustomstyles": "4.0.3",
- "craftcms/cms": "4.4.4",
- "craftcms/redactor": "3.0.4",
- "doublesecretagency/craft-cpcss": "2.6.0",
- "nystudio107/craft-seomatic": "4.0.22",
- "nystudio107/craft-templatecomments": "^4.0",
- "nystudio107/craft-vite": "4.0.5",
- "sebastianlenz/linkfield": "2.1.5",
- "spicyweb/craft-embedded-assets": "3.1.1",
- "spicyweb/craft-neo": "3.7.3",
- "verbb/user-group-field": "3.0.1",
- "vlucas/phpdotenv": "^5.4.0",
- "xpertbot/craft-wheelform": "3.1.5"