Latest update destroyed my forum

[StefanMischok]

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

 

[Jim M]

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.

[StefanMischok]

Thanks. Checking into it ...

Can you tell which tables need to be changed to dynamic?

You mean from FIXED to dynamic ... correct?

[StefanMischok]

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

[Marc Stridgen]

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

[StefanMischok]

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

[StefanMischok]

Upgrade worked.

[Marc Stridgen]

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.