I have an problem installing a new plg with new CB 1.2.2 looks like this issue again...

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,64/id,78961/#78961

This is error message I got:

SQL error on field store2: moscomprofilerFields::store failed: CBSQLupgrader::changeColumn (ADD) of Table #__comprofiler Column confirmemail failed with SQL error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\\n ADD `confirmemail` varchar(255) DEFAULT NULL Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\\n ADD `confirmemail` varchar(255) DEFAULT NULL

Post edited by: krileon, at: 2010/05/12 21:19

I just got this error today as well. (3/2010)

Then upon my research to fix, I found I have reached the max number of fields.

the fix posted mentioned it will be fixed in the next version (that was 2008 btw)

I am running 1.2.2

The fix posted asks you to edit file

components/com_comprofiler/plugin/user/cb.core.xml

I dont have this file

although I do have

components/com_comprofiler/plugin/user/plug_cbcore/cb.core.xml

Should I edit the code
varchar (255) in that file?

suggestions?

Post edited by: jakobe75, at: 2010/03/22 23:30

I havent tested, as I just deleted some testing fields.
and that eliminated the error

but I hope it works, I have about 35 text type fields each for 6 different user types, and I got this message only on my 3rd user/sub type.


will post progress.

thanks

I have tried several solutions found on the forum for this but I still cannot add anymore fields.

I really dont have alot of fields as yet
my field count in fields manager is at 90


this is only about 75% of the fields I need to continue.

This is my error:

[code:1]moscomprofilerFields::«»store failed: CBSQLupgrader::changeColumn (ADD) of Table #__comprofiler Column cb_elite2confirm failed with SQL error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_elite2confirm` varchar(255) DEFAULT NULL Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `jos_comprofiler`\n ADD `cb_elite2confirm` varchar(255) DEFAULT NULL[/code:1]


I am not sure if this is the same error other users where getting in the other threads.

I have tried this fix:

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,64/id,78961/#78961


thus resulting in this file: (components/com_comprofiler/plugin/user/cb.core.xml)


[code:1]
</params>
</field>
<field type="text" label="Text Field">
<data name="" nametype="namesuffix" type="text" null="true" default="NULL" strict="false" />
<params>[/code:1]


When running the CB tools I get a ton of errors, so I did a dry run and nothing was fixed. (still red)

I also tried to change from varchar(255)
to varchar(125)

Based on suggestions in this thread:
www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,112/id,126433/#126433

I am still getting the error when adding any type of field.

how to fix?
or a workaround, as this is crippling me.

Post edited by: krileon, at: 2010/04/01 17:35