I installed the 1.2 on a new side. The setup was successful. I synchronizatied the users, which was successful, but the database check publishes the undermentioned mistake always. The users don't appear it the User Managment.
What is the mistake?
Php version: 5.1.6
[code:1]Checking Community Builder Datbase:
All Community Builder comprofiler_field_values table fieldid rows all match existing fields.
All Community Builder comprofiler_field_values table rows link to correct fieldtype fields in comprofiler_field table.
All Community Builder comprofiler table rows have links to user table.
All users table rows have links to comprofiler table.
All Community Builder fields from comprofiler_fields are present as columns in the 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.
Checking Community Builder folders:
Avatars and thumbnails folder is Writeable.
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: A(z) 'a.aro_id' oszlop ervenytelen 'field list'-ben 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: A(z) 'a.aro_id' oszlop ervenytelen 'field list'-ben 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: A(z) 'a.aro_id' oszlop ervenytelen 'where clause'-ben 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
All Core CB Database is up to date.
Click here to Show details
[/code:1]
Post edited by: zseni, at: 2008/06/29 01:12