Hi
We have a very large amount of information to store for our members and mysql is failing with a length limit per row due to the number of varchar(255) fields.

I tried changing jos_comprofiler_fields 'table' to #__comprofiler_marksdata and created it with a single id (int) column. Running tools/fix fields then moved the selected fields into marksdata. What I want to know is do I need to add a CB id field to link back to the actual CB user to get it all working or will it use the existing id field?

Many thanks

Mark

Hi Krileon,

Thanks for your comment. I did try bulk changing the columns to text instead of varchar but we still get errors of fields missing when running through the tools checks.

I wrpte

I tried changing jos_comprofiler_fields 'table' to #__comprofiler_marksdata and created it with a single id (int) column. Running tools/fix fields then moved the selected fields into marksdata. What I want to know is do I need to add a CB id field to link back to the actual CB user to get it all working or will it use the existing id field?

On trying to write data back after update I get an error saying field does not exist in #__comprofiler.

So I guess my real/next question is that of using tables other than comprofiler to store field data. Tools will write the fields into a sub table but when I try and update the field from the front end, I get an error saying the field cannot be found in comprofiler table. It looks like CB is mass writing all data back to the database whether changes have happened or not and it also looks like CB is ignoring the table field from the comprofiler_fields definition table.
It does use the table field when creating the fields but not when updating back.

Is this a bug, something I can hack code to sort or just a future item to be done?

Best Wishes

Mark