Hello, on local environment I face this problem when I try to update the Zipped theme uploading the XML XenBase file. Speaking also on Xenforo about this: https://xenforo.com/community/threads/row-size-too-large-8126-when-updating-theme.111261/
I know that I could fix the issue by increasing the ib_logfile size, but I'd like to know if you've ever experienced this situations and if you have another solution.
Also, would like to know if, according to your experience, there's been situations where you've successfully updated the themes with "innodb_log_file_size = 5M" in your settings.
Last question: what happens when I face the error? Currently I've XF 1.4.5 with Zipped 1.4.5 uploaded. I'd like to update everything to the latest version. Can I try to upload the Xenbase 1.5.3 XML file as a new theme on XF 1.4.5, on the production server? If I face the error, it'll simply abort the process?
Error:
I know that I could fix the issue by increasing the ib_logfile size, but I'd like to know if you've ever experienced this situations and if you have another solution.
Also, would like to know if, according to your experience, there's been situations where you've successfully updated the themes with "innodb_log_file_size = 5M" in your settings.
Last question: what happens when I face the error? Currently I've XF 1.4.5 with Zipped 1.4.5 uploaded. I'd like to update everything to the latest version. Can I try to upload the Xenbase 1.5.3 XML file as a new theme on XF 1.4.5, on the production server? If I face the error, it'll simply abort the process?
Error:
Server 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.
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\forum\library\Zend\Db\Statement.php at line 297
- Zend_Db_Statement->execute() in C:\xampp\htdocs\forum\library\Zend\Db\Adapter\Abstract.php at line 479
- Zend_Db_Adapter_Abstract->query() in C:\xampp\htdocs\forum\library\XenForo\Model\Template.php at line 1692
- XenForo_Model_Template->_insertCompiledTemplateRecord() in C:\xampp\htdocs\forum\library\XenForo\Model\Template.php at line 1617
- XenForo_Model_Template->compileAndInsertParsedTemplate() in C:\xampp\htdocs\forum\library\XenForo\Model\Template.php at line 1379
- XenForo_Model_Template->compileTemplateInStyleTree() in C:\xampp\htdocs\forum\library\XenForo\Model\Template.php at line 1329
- XenForo_Model_Template->compileNamedTemplateInStyleTree() in C:\xampp\htdocs\forum\library\XenForo\Model\Template.php at line 1268
- XenForo_Model_Template->compileAllTemplates() in C:\xampp\htdocs\forum\library\XenForo\Deferred\Template.php at line 36
- XenForo_Deferred_Template->execute() in C:\xampp\htdocs\forum\library\XenForo\Model\Deferred.php at line 295
- XenForo_Model_Deferred->runDeferred() in C:\xampp\htdocs\forum\library\XenForo\Model\Deferred.php at line 429
- XenForo_Model_Deferred->_runInternal() in C:\xampp\htdocs\forum\library\XenForo\Model\Deferred.php at line 374
- XenForo_Model_Deferred->run() in C:\xampp\htdocs\forum\library\XenForo\ControllerAdmin\Tools.php at line 159
- XenForo_ControllerAdmin_Tools->actionRunDeferred() in C:\xampp\htdocs\forum\library\XenForo\FrontController.php at line 351
- XenForo_FrontController->dispatch() in C:\xampp\htdocs\forum\library\XenForo\FrontController.php at line 134
- XenForo_FrontController->run() in C:\xampp\htdocs\forum\admin.php at line 13