I have:
MySQL said: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
why ?
MERCI !
why ?
-
grimblefritz
- AppGini Super Hero
- Posts: 336
- Joined: 2015-12-23 16:52
Re: why ?
Difficult to say without seeing the table structure. You might want to post that.
If I remember correctly, for InnoDB tables the row limit is actually more like 16K (ie, the size in the error message may be incorrect.)
A common cause is the use of very large VARCHAR fields. If you have them, change them to TEXT. If you're relying on VARCHAR to limit the maximum input, you'll need to switch to doing that during the POST, or via jquery if you wish to monitor it realtime.
If I remember correctly, for InnoDB tables the row limit is actually more like 16K (ie, the size in the error message may be incorrect.)
A common cause is the use of very large VARCHAR fields. If you have them, change them to TEXT. If you're relying on VARCHAR to limit the maximum input, you'll need to switch to doing that during the POST, or via jquery if you wish to monitor it realtime.