Community builder jos_core_acl_aro table

This forum is for general questions about extensions for Joomla! 2.5.

Moderators: pe7er, General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
jano_s
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Thu Dec 23, 2010 8:00 pm

Community builder jos_core_acl_aro table

Post by jano_s » Wed Feb 02, 2011 3:58 pm

Joomla! 1.6
Community builder 1.3.1
Apache 2.2.17
MySQL 5.0.91-community-log

Error after using: "CB Tools: Check Users database: Results"
SQL error DB function failed with error number 1146
Table 'mydomain.jos_core_acl_aro' doesn't exist SQL=INSERT INTO jos_core_acl_aro (section_value,value,order_value,name,hidden) SELECT 'users' AS section_value, u.id AS value, 0 AS order_value, u.name as name, 0 AS hidden FROM jos_users u LEFT JOIN jos_core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL
Table jos_core_acl_aro created.
After SQL quest:
INSERT INTO jos_core_acl_aro (section_value,value,order_value,name,hidden) SELECT 'users' AS section_value, u.id AS value, 0 AS order_value, u.name as name, 0 AS hidden FROM jos_users u LEFT JOIN jos_core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL
error
#1054 - Unknown column 'a.value' in 'where clause
Could you help? I try to create a new table, but an error is my problem and I don't know how to create it "manualy" by phpMyAdmin (what values etc)

 
 
Locked

Return to “Extensions for Joomla! 2.5”