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?
