- #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
- Change limit for “Mysql Row size too large”
- Row size too large 8126 Changing some columns
- 1118 Row size too large
The error was: 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 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
- Solution
- Login to phpMyAdmin with root previllege
- Go to Variables
- Then edit Innodb Strict Mode as follows
innodb_strict_mode = 0