Row Size too large error

mathfrick

• July 14, 2017 07:51

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

  • July 14, 2017 18:10

  Hello, You may find some of the discussions on the following StackOverflow thread helpful: Change limit for "Mysql Row size too large" Thank you.

  0

Please sign in to leave a comment.