I am running on Joomla 1.5.8 legacy mode and CB 1.1

and get this error:

[code:1]Unknown column 'aro.aro_id' in 'on clause' SQL=SELECT DISTINCT a.*, g.name AS groupname, ue.approved,ue.confirmed FROM jos_users AS a LEFT JOIN jos_comprofiler AS ue ON a.id = ue.id INNER JOIN jos_core_acl_aro AS aro ON aro.value = a.id INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id INNER JOIN jos_core_acl_aro_groups AS g ON g.group_id = gm.group_id WHERE aro.section_value = 'users' LIMIT 0, 100[/code:1]

Only in the tab User management

Before i didn´t get this error.

Does someone has a fx?? Thanks!

nant wrote:

ricardo777 wrote:

I am running on Joomla 1.5.8 legacy mode and CB 1.1

and get this error:

[code:1]Unknown column 'aro.aro_id' in 'on clause' SQL=SELECT DISTINCT a.*, g.name AS groupname, ue.approved,ue.confirmed FROM jos_users AS a LEFT JOIN jos_comprofiler AS ue ON a.id = ue.id INNER JOIN jos_core_acl_aro AS aro ON aro.value = a.id INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id INNER JOIN jos_core_acl_aro_groups AS g ON g.group_id = gm.group_id WHERE aro.section_value = 'users' LIMIT 0, 100[/code:1]

Only in the tab User management

Before i didn´t get this error.

Does someone has a fx?? Thanks!

Please upgrade to CB 1.2 RC4 - recommended for Joomla 1.5.X series.

I had upgraded but it gives an white page and if i activate legacy mode it works but gives sql error in field tab

I found a fix for it on:

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/id,84873/catid,70/limit,6/limitstart,0/


If i check the tool

Check Users Database

I get this errors:

All Community Builder comprofiler table rows have links to user table.

All users table rows have links to comprofiler table.

users table has no zero id row.

comprofiler table has no zero id row.

All rows in comprofiler table have user_id columns identical to id columns.

All users table rows have ACL entries in core_acl_aro table.

ERROR: sql query: SELECT a.value AS id, a.aro_id FROM #__core_acl_aro a LEFT JOIN #__users u ON u.id = a.value WHERE a.section_value = 'users' AND u.id IS NULL : returned error: Unknown column 'a.aro_id' in 'field list' SQL=SELECT a.value AS id, a.aro_id FROM jos_core_acl_aro a LEFT JOIN jos_users u ON u.id = a.value WHERE a.section_value = 'users' AND u.id IS NULL

ERROR: sql query: SELECT a.value AS id, a.aro_id FROM #__core_acl_aro a LEFT JOIN #__core_acl_groups_aro_map g ON g.aro_id = a.aro_id WHERE g.aro_id IS NULL : returned error: Unknown column 'a.aro_id' in 'field list' SQL=SELECT a.value AS id, a.aro_id FROM jos_core_acl_aro a LEFT JOIN jos_core_acl_groups_aro_map g ON g.aro_id = a.aro_id WHERE g.aro_id IS NULL

ERROR: sql query: SELECT g.aro_id AS id FROM #__core_acl_groups_aro_map g LEFT JOIN #__core_acl_aro a ON a.aro_id = g.aro_id WHERE a.aro_id IS NULL : returned error: Unknown column 'a.aro_id' in 'where clause' SQL=SELECT g.aro_id AS id FROM jos_core_acl_groups_aro_map g LEFT JOIN jos_core_acl_aro a ON a.aro_id = g.aro_id WHERE a.aro_id IS NULL

Post edited by: ricardo777, at: 2009/01/22 18:51