Error on user check

11 years 1 month ago #223553 by brononi
Error on user check was created by brononi
Hey,

When i sync my users, i'm getting:

Joomla/Mambo User Table and Joomla/Mambo Community Builder User Table now in sync!


When i check my user table, i'm getting:

Checking Users Database:

All Community Builder comprofiler table rows have links to user table.

All users table rows have links to 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.

All users table rows have ACL entries in user_usergroup_map table.

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

Following entries of user_usergroup_map table are missing in users table: user id=226 (aro_id=), user id=227 (aro_id=), user id=228 (aro_id=), user id=229 (aro_id=), user id=230 (ar....<knip>..... user id=7382 (aro_id=), user id=7383 (aro_id=), user id=7384 (aro_id=), user id=7385 (aro_id=), user id=7386 (aro_id=), user id=7387 (aro_id=). This core_acl_aro entry with aro_id 0 should be removed, as it's not allowed.

This one can be fixed by first backing up database then by clicking here.


And when i 'fix' it, i'm getting:

Joomla/Mambo User Table and Joomla/Mambo ACL Table should now be in sync!


But when i test it again, the same error returns.
Any idea what's going on?


Can/may i manually remove this from my database?

Please Log in to join the conversation.

11 years 1 month ago #223555 by brononi
Replied by brononi on topic Error on user check
Hmmm,

At first sight, this is a problem with my joomla table user_usergroup_map.
I've manullay removed the userids in there that CB told me that were wrong. And now, i don't have the error anymore.

I just hope that i didn't do anything wrong with removing it...

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.124 seconds

Facebook Twitter LinkedIn