StefanMischok Posted August 15, 2022 Share Posted August 15, 2022 Hi, Just tried updating to 4.7.1 and now the forum is offline. I get this error message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs Now, the forum is stuck in updating mode. Solutions? The full error message is: Quote Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs/home/killersi/public_html/community/applications/nexus/setup/upg_107018/queries.json - query #1 Link to comment Share on other sites More sharing options...
Solution Jim M Posted August 15, 2022 Solution Share Posted August 15, 2022 Please switch your table row formats to dynamic instead of compact. If you are unsure how to perform this, please contact your hosting provider for assistance. Link to comment Share on other sites More sharing options...
StefanMischok Posted August 15, 2022 Author Share Posted August 15, 2022 Thanks. Checking into it ... Can you tell which tables need to be changed to dynamic? You mean from FIXED to dynamic ... correct? Link to comment Share on other sites More sharing options...
StefanMischok Posted August 15, 2022 Author Share Posted August 15, 2022 Ok ... I went to the specific table in the error and got this: To clarify, for the table nexus_fraud_rules ... there is no option to set to dynamic. Suggestions? S Link to comment Share on other sites More sharing options...
Marc Posted August 15, 2022 Share Posted August 15, 2022 You would need to contact your hosting company to ask why you are unable to set that correctly. This is an issue on the host side unfortunately Link to comment Share on other sites More sharing options...
StefanMischok Posted August 15, 2022 Author Share Posted August 15, 2022 HI, I've tried some RAW SQL: ALTER TABLE 'nexus_fraud_rules' ROW_FORMAT = DYNAMIC; Getting syntax errors in PHPMyadmin. S LOL. It was my syntax, I added quotes around the table name. D'oh! ALTER TABLE nexus_fraud_rules ROW_FORMAT = DYNAMIC Link to comment Share on other sites More sharing options...
StefanMischok Posted August 15, 2022 Author Share Posted August 15, 2022 Upgrade worked. Link to comment Share on other sites More sharing options...
Marc Posted August 15, 2022 Share Posted August 15, 2022 Excellent. Glad to hear that got the upgrade through for you. Check in Support in your admin CP and ensure its not stating you still have dynamic tables. If it does, I would suggest checking for whatever others there are and changing those too. Just saved you having any issues in the future. Link to comment Share on other sites More sharing options...
Recommended Posts