mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126
Permalink Browser Info Environment
Hi All,
I'm new to concrete and using designer content package, by the help of this I've created a block to insert content. I'm able to insert content with some field successfully but not with all fields, I've created near about 103 fields. I'm getting following error message:
"mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126"
Can anyone please help me on same thanks in advance :)
I'm new to concrete and using designer content package, by the help of this I've created a block to insert content. I'm able to insert content with some field successfully but not with all fields, I've created near about 103 fields. I'm getting following error message:
"mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126"
Can anyone please help me on same thanks in advance :)
| Type: | Discussion |
|---|---|
| Status: | In Progress |
One way to get around this is to change the "row_format" for the problematic table to "dynamic". Even if the database is set to use dynamic by default for tables, ensure that the table throwing the error is set to dynamic.
Why do you have over 100 fields in your block? I can't really think of a situation where that would be necessary... the way Concrete5 works best is by adding many blocks to a page, not by having one block that has everything in it.