I installed CB 1.2 RC3 on Joomla 1.5.6.

When I log into the admin I get these errors when I try to access CB tab management, field management and list management, respectively.

Tab mgt:
[code:1]Unknown column 'a.useraccessgroupid' in 'where clause' SQL=SELECT COUNT(*) FROM jos_comprofiler_tabs AS a WHERE a.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)DB function failed with error number 1054
Unknown column 'a.useraccessgroupid' in 'where clause' SQL=SELECT a.*, p.name AS pluginname, p.published AS pluginpublished FROM jos_comprofiler_tabs AS a LEFT JOIN jos_comprofiler_plugin AS p ON p.id = a.pluginid WHERE a.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1) ORDER BY position, ordering LIMIT 0, 20[/code:1]

Field mgt:
[code:1]Unknown column 't.fields' in 'where clause' SQL=SELECT COUNT(*) FROM jos_comprofiler_fields AS f, jos_comprofiler_tabs AS t WHERE (f.tabid = t.tabid) AND (t.fields = 1) AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)DB function failed with error number 1054
Unknown column 'f.description' in 'field list' SQL=SELECT f.fieldid, f.title, f.name, f.description, f.type, f.required, f.published, f.profile, f.ordering, f.registration, f.searchable, f.pluginid, f.sys, f.tablecolumns, t.title AS 'tab', t.enabled AS 'tabenabled', t.pluginid AS 'tabpluginid', p.name AS pluginname, p.published AS pluginpublished, pf.name AS fieldpluginname, pf.published AS fieldpluginpublished FROM jos_comprofiler_fields AS f INNER JOIN jos_comprofiler_tabs AS t ON ( (f.tabid = t.tabid) AND (t.fields = 1) ) LEFT JOIN jos_comprofiler_plugin AS p ON p.id = t.pluginid LEFT JOIN jos_comprofiler_plugin AS pf ON pf.id = f.pluginid WHERE t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1) ORDER BY t.ordering, f.ordering LIMIT 0, 20[/code:1]

List mgt:
[code:1]DB function failed with error number 1054
Unknown column 'useraccessgroupid' in 'field list' SQL=SELECT listid, title, description, published,`default`,ordering,useraccessgroupid FROM jos_comprofiler_lists a ORDER BY ordering LIMIT 0, 20[/code:1]

If it's any help, I ran the "check core cb database" tool with the following error:

All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table, but comprofiler_fields table is not yet upgraded to CB 1.2 table structure. You can do this by clicking on the upgrade link below.

Then there's over a hundred red lines (structure differences).

Please, please, please, anyone, how can I correct all this?

The "Click here to fix all..." facility gives new adjustment errors.

Ok. I reinstalled everything including mysql, joomla and cb. works ok now.

Is this the only way to fix this - I really don't want to go reinstalling Joomla etc...

Hi All,
I get the same errors after a clean install.
I've created manualy all fields and at last it works, but could it be possible to create automatically the missing fields during the installation ( same pb with 1.1 & 1.2rc3 )
Thank you very much.
Marc

here are the missing fields for each table

in _comprofiler_tabs
useraccessgroupid
pluginid
position
fields

in _compriofiler_fields
description
searchable
pluginid
tablecolumns


in _compriofiler_list
useraccessgroupid