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

Stängt Publicerat 5 år sedan Betalades vid leverans
Stängt Betalades vid leverans

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

Projekt-id: #17814160

About the project

5 offerter Distansprojekt Aktivt 5 år sedan

5 frilansare har lagt bud på i genomsnitt $22 för det här jobbet

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. Mer

$25 USD inom 1 dag
(11 omdömen)
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 Mer

$25 USD inom 1 dag
(9 omdömen)
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 Mer

$15 USD inom 1 dag
(1 omdöme)
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 inom 1 dag
(0 omdömen)
0.0