imploding error in updating profile

If I try to update anything in my CB profile I get this error O_o


Warning: implode(): Bad arguments. in /home/nullkris/public_html/main/components/com_comprofiler/comprofiler.php on line 427
SQL errorDB function failed with error number 1054
Unknown column 'sbsignature' in 'field list' SQL=UPDATE mos_comprofiler SET `cb_carandmods`='1984 Rabbit xflow' , `sbviewtype`='_UE_SB_VIEWTYPE_FLAT|*|_UE_SB_VIEWTYPE_FLAT' , `sbsignature`='' , `cb_aim`='DlgitaIK' , `sbviewtype`='_UE_SB_VIEWTYPE_FLAT|*|_UE_SB_VIEWTYPE_FLAT' , `sbordering`='' , `lastupdatedate`='2006-01-25T11:43:11', `firstname`='', `middlename`='', `lastname`='' WHERE id='63'
SQL =

UPDATE mos_comprofiler SET `cb_carandmods`='1984 Rabbit xflow' , `sbviewtype`='_UE_SB_VIEWTYPE_FLAT|*|_UE_SB_VIEWTYPE_FLAT' , `sbsignature`='' , `cb_aim`='DlgitaIK' , `sbviewtype`='_UE_SB_VIEWTYPE_FLAT|*|_UE_SB_VIEWTYPE_FLAT' , `sbordering`='' , `lastupdatedate`='2006-01-25T11:43:11', `firstname`='', `middlename`='', `lastname`='' WHERE id='63'

This looks like you got a corrupt jos_comprofiler_fields table.

Check in that SQL table with phpMyAdmin if you got the entry for "sbviewtype" twice...

If yes, you need to remove one of them if they are identical.

These are inserted by SB/JB on CB integration activation. Maybe you did that twice by error, or something got wrong.

I'll check but I've had it installed for a long time and its doing it all by itself O_o