jos_core_acl_aro table

13 years 3 months ago #152882 by jano_s
jos_core_acl_aro table was created 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?

Please Log in to join the conversation.

13 years 3 months ago #152994 by heyai
Replied by heyai on topic Re: jos_core_acl_aro table
This is probably due to several incompatibilities between CB 1.3.1 and Joomla 1.6. The 1.4 version of CB should be out by Valentines day and hopefully fix this!

hey-ai - the community for asian guys and non-asian girls

The search bar is your friend, not just decoration!
The following user(s) said Thank You: jano_s

Please Log in to join the conversation.

13 years 2 months ago #153385 by jano_s
Replied by jano_s on topic Re: jos_core_acl_aro table
True, it's due incompatibilities CB1.3.1 and Joomla1.6 (I tried to creat new tables and another tricks, but nothings helped).

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.208 seconds

Facebook Twitter LinkedIn