User management sql error

11 years 5 months ago #86090 by ricardo777
User management sql error was created by ricardo777
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 Log in to join the conversation.

11 years 5 months ago #86101 by nant
Replied by nant on topic Re:User management sql error
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.

Please Log in to join the conversation.

11 years 5 months ago #86102 by ricardo777
Replied by ricardo777 on topic Re:User management sql error
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

Please Log in to join the conversation.

11 years 5 months ago #86108 by nant
Replied by nant on topic Re:User management sql error
now that you have upgraded, please run all cb tools checks - hopefully the users check might address this issue.

Please Log in to join the conversation.

11 years 5 months ago #86270 by ricardo777
Replied by ricardo777 on topic Re:User management sql error
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

Please Log in to join the conversation.

11 years 5 months ago #86272 by nant

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.418 seconds

Facebook Twitter LinkedIn