want to fix mwsql error...#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
$10-30 USD
Paid on delivery
i get this message #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
whatever i do. table wont let me add a new row.. wont accept any varchar. it only admits text.. i have 230 rows in table.. and need to add 100 more...
i attched the table. you can try to add varchar row..
i upgraded to mariadb that didnt help..
my crret conf is
innodb_strict_mode = 0
Project ID: #17814160
About the project
5 freelancers are bidding on average $22 for this job
Hello, I have experience and skills to complete this jobs, I am the suitable person for this task, I have read your description. I can do this task. Please open your chat box for more discussion. Area of Interest: PH More
Hi, varchar has a max limit on the total size of varchar columns in the row. You'll have to reduce the size of some of your varchars, convert them to text or split the table into multiple tables. Thanks