want to fix mwsql error...#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

Closed Posted 5 years ago Paid on delivery
Closed 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

MariaDB MySQL phpMyAdmin

Project ID: #17814160

About the project

5 proposals Remote project Active 5 years ago

5 freelancers are bidding on average $22 for this job

Avinavkr

Hello there, I have just gone through your project details and understood the requirements. We have a team of experienced developers matching your project skill sets. So,we can complete your project successfully. More

$25 USD in 1 day
(11 Reviews)
4.9
nigamkumar09

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

$25 USD in 1 day
(9 Reviews)
2.7
MRE000

Hi, i downloaded the file and i fixed the error. I've BS degree in Computer Science, i have 6Y+ of experience in Web Development, Software Engineering, Quality, Linux. i am currently offering high quality work for More

$15 USD in 1 day
(1 Review)
2.2
apericore

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

$25 USD in 1 day
(0 Reviews)
0.0