Skip to content

[4.4.5]: Using "Field Limit" after creating new "Plain Text Field" -> Database Exception #12954

Closed
@mfell

Description

@mfell

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

  1. Create a new "Plain Text Field"
  2. Safe
  3. 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"

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions