[SOLVED] Error 1118 When Saving New Field

krileon wrote: Yeah, you're hitting column size limit. The below is a possible workaround.

www.joomlapolis.com/forum/64-rc3-general-discussions/78961-comprofiler-table-reaches-maximum-database-fields#78981

The alternative is to edit all of your _comprofiler database tables and change their engine from MyISAM to InnoDB, which should allow for up to 1,000 fields. The engine change is already done in CB 2.0.

Ah that's where it is, i'd read about changing from varchar to text but had no idea where in CB to actually change it. Updated that and working now thanks.

Actually that only fixed it for a couple of extra fields then it started happening again. Changing all comprofiler fields to innoDB did fix the issue.

this link was very helpful

aryannava.com/2011/05/11/convert-myisam-to-innodb-using-phpmyadmin-for-moodle/