XF 1.4 Error on changing parent theme

[Eric J.]

When changing the parent of a theme I'm getting the following error:

Mysqli statement execute error : Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

    Zend_Db_Statement_Mysqli->_execute() in C:\xampp\htdocs\xenforo145\library\Zend\Db\Statement.php at line 297
    Zend_Db_Statement->execute() in C:\xampp\htdocs\xenforo145\library\Zend\Db\Adapter\Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in C:\xampp\htdocs\xenforo145\library\XenForo\Model\DataRegistry.php at line 164
    XenForo_Model_DataRegistry->set() in C:\xampp\htdocs\xenforo145\library\XenForo\Model\Style.php at line 434
    XenForo_Model_Style->rebuildStyleCache() in C:\xampp\htdocs\xenforo145\library\XenForo\DataWriter\Style.php at line 169
    XenForo_DataWriter_Style->_rebuildCache() in C:\xampp\htdocs\xenforo145\library\XenForo\DataWriter\Style.php at line 160
    XenForo_DataWriter_Style->_postSave() in C:\xampp\htdocs\xenforo145\library\XenForo\DataWriter.php at line 1409
    XenForo_DataWriter->save() in C:\xampp\htdocs\xenforo145\library\XenForo\Model\StyleProperty.php at line 771
    XenForo_Model_StyleProperty->updatePropertyCacheInStyle() in C:\xampp\htdocs\xenforo145\library\XenForo\Model\StyleProperty.php at line 629
    XenForo_Model_StyleProperty->rebuildPropertyCacheInStyleAndChildren() in C:\xampp\htdocs\xenforo145\library\XenForo\DataWriter\Style.php at line 153
    XenForo_DataWriter_Style->_postSave() in C:\xampp\htdocs\xenforo145\library\XenForo\DataWriter.php at line 1409
    XenForo_DataWriter->save() in C:\xampp\htdocs\xenforo145\library\XenForo\Model\Style.php at line 535
    XenForo_Model_Style->importStyleXml() in C:\xampp\htdocs\xenforo145\library\XenForo\ControllerAdmin\Style.php at line 201
    XenForo_ControllerAdmin_Style->actionImport() in C:\xampp\htdocs\xenforo145\library\XenForo\FrontController.php at line 347
    XenForo_FrontController->dispatch() in C:\xampp\htdocs\xenforo145\library\XenForo\FrontController.php at line 134
    XenForo_FrontController->run() in C:\xampp\htdocs\xenforo145\admin.php at line 13

In case it helps this is on Xampp localhost.

 

[Mike]

It's related to a MySQL setting, though one that is a pain to change. See this thread: https://xenforo.com/community/threads/mysqli-statement-execute-error-row-size-too-large.88390/