Max size of fields error, Row size too large

8 years 10 months ago #264818 by AvalonSailingClub
Max size of fields error, Row size too large was created by AvalonSailingClub
Hi
Some years ago I built a CB (and cb_subs) website that had some 330 fields for each record.
To get over the size limit restrictions I reduced the size of most of the fields to 30 from 255 varchars (which worked).

Now after upgrading to cb 2.08 (and cbSubs to 4.0) and running the tools checks I get numerous errors like:
"Table #__comprofiler Column cb_mailingname type is varchar(30) instead of varchar(255)"

When I try to do the "click here to fix all cb fields ..." I get ...

"Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `j25_comprofiler` CHANGE `cb_mailingname` `cb_mailingname` varchar(255) DEFAULT NULL"

Question 1: Do I worry about it?
Question 2: If it will cause probs or I should worry about it, what do I do?

thanks for your help
Kingsley

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.209 seconds

Facebook Twitter LinkedIn