Page 1 of 1

Community builder jos_core_acl_aro table

Posted: Wed Feb 02, 2011 3:58 pm
by jano_s
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)