Hello,

I have standard fresh installation and its missing some database configuration? i will appreciate any suggestions. I'm getting following errors when i click tab management:


Unknown column \'a.useraccessgroupid\' in \'where clause\' SQL=SELECT COUNT(*)\nFROM jos_comprofiler_tabs AS a\nWHERE 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, 30


and following error on field management:

Unknown column \'t.fields\' in \'where clause\' SQL=SELECT COUNT(*)\nFROM jos_comprofiler_fields AS f, jos_comprofiler_tabs AS t\nWHERE (f.sys = 0) AND (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, t.title AS 'tab', t.enabled AS 'tabenabled', t.pluginid AS 'pluginid', p.name AS pluginname, p.published AS pluginpublished FROM jos_comprofiler_fields AS f, jos_comprofiler_tabs AS t LEFT JOIN jos_comprofiler_plugin AS p ON p.id = t.pluginid WHERE (f.sys = 0) AND (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) ORDER BY t.ordering, f.ordering LIMIT 0, 30

list management fails with this error:

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, 30

looks like there is only 1 SQL query that needs to be run....it appears that the statement below is the cause of the problems, as I had the same issue...

log into your MySQL DB and run this query....

ALTER TABLE jos_comprofiler_tabs ADD `useraccessgroupid` int( 9 ) DEFAULT -2 NOT NULL AFTER `position`;

You should be good to go after that...

I tried doing it, it does not work. Seems the default installation has problems. I tried reinstalling as well, it does not work either.

i tried it even on clean joomla on new host, it does not work at all.

guess someone has to test the install scripts on clean system.

it seems many fields are missing in the table, it is not configure properly.

I've got the same problem, on a clean Joomla! 1.5 and CB 1.1 installation..

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,55682/catid,41/