Row Size too large error

[mathfrick]

Hi,

I need help to fix 1118 Row Size too large in WHM/cPanel? Any ideas would be highly appreciated.

This is que SQL query:

ALTER TABLE `menus` ADD `menu12_titre` VARCHAR(100) NOT NULL AFTER `menu11_target_en`, ADD `menu12_url` VARCHAR(500) NOT NULL AFTER `menu12_titre`, ADD `menu12_titre_en` VARCHAR(100) NOT NULL AFTER `menu12_url`, ADD `menu12_url_en` VARCHAR(500) NOT NULL AFTER `menu12_titre_en`, ADD `menu12_target` VARCHAR(5) NOT NULL AFTER `menu12_url_en`, ADD `menu12_target_en` VARCHAR(5) NOT NULL AFTER `menu12_target`;

ALTER TABLE `menus`ADD `menu13_titre` VARCHAR(100) NOT NULL AFTER `menu12_target_en`, ADD `menu13_url` VARCHAR(500) NOT NULL AFTER `menu13_titre`, ADD `menu13_titre_en` VARCHAR(100) NOT NULL AFTER `menu13_url`, ADD `menu13_url_en` VARCHAR(500) NOT NULL AFTER `menu13_titre_en`, ADD `menu13_target` VARCHAR(5) NOT NULL AFTER `menu13_url_en`, ADD `menu13_target_en` VARCHAR(5) NOT NULL AFTER `menu13_target`, ADD `menu14_titre` VARCHAR(100) NOT NULL AFTER `menu13_target_en`, ADD `menu14_url` VARCHAR(500) NOT NULL AFTER `menu14_titre`, ADD `menu14_titre_en` VARCHAR(100) NOT NULL AFTER `menu14_url`, ADD `menu14_url_en` VARCHAR(500) NOT NULL AFTER `menu14_titre_en`, ADD `menu14_target` VARCHAR(5) NOT NULL AFTER `menu14_url_en`, ADD `menu14_target_en` VARCHAR(5) NOT NULL AFTER `menu14_target`;


And i've tried to push up to innodb_log_file_size=531072000

... not working

This is the error:

Requête SQL :


ALTER TABLE `menus` ADD `menu12_titre` VARCHAR(100) NOT NULL AFTER `menu11_target_en`, ADD `menu12_url` VARCHAR(500) NOT NULL AFTER `menu12_titre`
MySQL a répondu: Documentation

#1118 - Ligne trop grande. Le taille maximale d'une ligne, sauf les BLOBs, est 65535. Changez le type de quelques colonnes en BLOB

 

[cPanelMichael]

Hello,

You may find some of the discussions on the following StackOverflow thread helpful:

Change limit for "Mysql Row size too large"

Thank you.