Short Tables - Missing data

PeteIA

Hi, I use IU to record membership information within a secure area of a website. I've had to split the database up between several pages as the data is often getting cut short if too many rows are included.
Is there a maximum data size for each IU page or could the problem be caused by me cutting and pasting html code from another program?
It seems to work fine if I limit the table to less than 20 rows but over that and I run therisk of losing data.

Avram

The limit of content length is determined by maximum size of MySQL's TEXT data type. It's around 64 KB.

PeteIA

Thanks, that explains it. All pages are under 64kb now and show the full set of data.
I tried adding a page over 64kb and it cut the data as previously explained.

Thanks again for the clarification

Avram

If you know how to use phpMyAdmin or other similar MySQL management software, you can execute following query to increase it to 16 MB (virtually unreachable with html code):
-------[ code ]---------------------------------------
ALTER TABLE `iu3_content` CHANGE `text` `text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;
-------[ code ]---------------------------------------

Just remember to replace "iu3_" with your table prefix, if you haven't used the default one.

This fix should be included in the next release of Instant Update.

Howdy, Stranger!

Categories