ItSolutionStuff.com

Solved - Syntax Error or Access Violation 1118 Row Size Too Large ( 8126)

By Hardik Savani β€’ November 5, 2023
Installation

Few days ago i was working on my php laravel application and i need to have one table that 200+ columns on it and i need to add it. so when i run my create sql command i found following error:

"Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format"

After research on google i found solution how to resolve this issue.

i need to disable innodb_strict_mode in mysql.

So, you can use following solution:

Solution:

Connect to MySQL

mysql -u root -p

Run the below Query:

SET GLOBAL innodb_strict_mode = 0;

You can see the below output:

Output:

I hope it can help you...

Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

πŸ“Ί Subscribe on YouTube

We Are Recommending You

β˜…

Laravel Migration Add Column After Column Example

Read Now β†’
β˜…

Laravel Migration Default Value Current Timestamp Example

Read Now β†’
β˜…

Python Generate Random Number Between 1 and 10 Example

Read Now β†’
β˜…

How to Add Custom Attribute in Laravel Model?

Read Now β†’
β˜…

How to Generate Random Number in Python?

Read Now β†’
β˜…

How to Use DB Raw Query in Laravel?

Read Now β†’
β˜…

How to Generate Random Password in Python?

Read Now β†’
β˜…

Laravel Get Min Value of Column Example

Read Now β†’
β˜…

Python Generate Random String of Specific Length Example

Read Now β†’
β˜…

Laravel Get Max Value of Column Example

Read Now β†’
β˜…

How to Generate Random String in Python?

Read Now β†’
β˜…

Get the Current Route in Angular 15 Example

Read Now β†’
β˜…

Laravel E-Signature using Docusign API Tutorial

Read Now β†’