Our clients site required an update of CB profiles with extra information. We attempted to do this using a manual dump via a csv file. What has happened though the freelancer we asked to do the job missed adding some data into the core_acl_aro and core_acl_groups_aro_map tables. This means that every time we use the CB / Tools / Synchronisation tool, it adds another 885 users into the CB users profile total.

We have upgraded to CB1.2 which shows the following errors when checking the database integrity. The issue is, how to fix it?

Warning: 838 entries in the core_acl_aro table without corresponding users table rows.

Following entries of core_acl_aro table are missing in users table: user id=66 (aro_id=66), user id=67 (aro_id=67), user id=68 (aro_id=68), user id=69 etc, etc

Warning: 825 entries in the core_acl_aro table without corresponding core_acl_groups_aro_map table rows.

Following entries of core_acl_aro table are missing in core_acl_groups_aro_map table: user id=66 (aro_id=66), user id=67 (aro_id=67), user id=68 (aro_id=68), user id=69 (aro_id=69), user id=70 (aro_id=70), user id=71 (aro_id=71), user id=72 (aro_id=72), user id=73 (aro_id=73), user id=74 (aro_id=74), etc

Core CB Database structure differences:
Table #__comprofiler Index PRIMARY does not exist
Table #__comprofiler Index user_id does not exist

I am hoping it possible to write some sql commands to populate the missing data in the core_acl_..... tables? Please PM me with a recommendation on how to solve the problem and budget to complete the task.

• Post by: jross - Posted on: 08/Jul/2008 at 18:24:38
• Status: Completed project (Awarded Freelancer: burgos) - Budget: < $100
• Bids duration: From to 10/Jul/2008 at 18:24:38
• Time left for bidding: 0 day(s) left (out of 2)
• Job Types:
  • Extensions Programming
• Location: Freelancer can be from any country