MySQL Error: #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.
Example SQL:
CREATE TABLE `wp_rich_web_slider_effect5` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `rich_web_slider_ID` varchar(255) NOT NULL, `rich_web_slider_name` varchar(255) NOT NULL, `rich_web_slider_type` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BoxShShow` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BoxShType` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BoxSh` varchar(255) NOT NULL, `Rich_Web_Sl_SC_BoxShC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_IW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_IH` varchar(255) NOT NULL, `Rich_Web_Sl_SC_IBW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_IBS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_IBC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_IBR` varchar(255) NOT NULL, `Rich_Web_Sl_SC_ICBW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_ICBS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_ICBC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_TBgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_TC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_TFS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_TFF` varchar(255) NOT NULL, `Rich_Web_Sl_SC_THBgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_THC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_OC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_BW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_BC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_BoxShShow` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_BoxShType` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_BoxSh` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Pop_BoxShC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_BgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_C` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_FS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_BW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_BS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_BC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_BR` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_HBgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_HC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_Type` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_Text` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_IType` varchar(255) NOT NULL, `Rich_Web_Sl_SC_L_FF` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_BgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_C` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_FS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_BW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_BS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_BC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_BR` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_HBgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_HC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_Type` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_Text` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_IType` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PI_FF` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_BgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_C` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_FS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_BW` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_BS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_BC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_BR` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_HBgC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_HC` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_Type` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_FF` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_IType` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_Next` varchar(255) NOT NULL, `Rich_Web_Sl_SC_Arr_Prev` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PCI_FS` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PCI_C` varchar(255) NOT NULL, `Rich_Web_Sl_SC_PCI_Type` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
Solution: edit file /etc/my.cnf
, add line
innodb_strict_mode=0