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
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
Last edited by a moderator: