[fixed in RC3] entries in the core_acl_aro table

15 years 6 months ago #77109 by Andrej
I get this when i use CB Tools:

All users table rows have ACL entries in core_acl_aro table.

Warning: 24 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=63 (aro_id=11), user id=66 (aro_id=14), user id=652 (aro_id=600), user id=1031 (aro_id=979), user id=1106 (aro_id=1054), user id=1286 (aro_id=1234), user id=1475 (aro_id=1423), user id=1479 (aro_id=1427), user id=1488 (aro_id=1436), user id=1496 (aro_id=1444), user id=1522 (aro_id=1470), user id=1523 (aro_id=1471), user id=1623 (aro_id=1571), user id=1594 (aro_id=1542), user id=1596 (aro_id=1544), user id=1625 (aro_id=1573), user id=1636 (aro_id=1584), user id=1663 (aro_id=1611), user id=1665 (aro_id=1613), user id=1670 (aro_id=1618), user id=1709 (aro_id=1657), user id=1726 (aro_id=1674), user id=1732 (aro_id=1680), user id=1733 (aro_id=1681).

This one can be fixed in SQL using a tool like phpMyAdmin.

All core_acl_aro table rows have ACL entries in core_acl_groups_aro_map table.

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

aro_id = 185, 206, 245, 246, 248, 255, 259, 264, 268, 269, 271, 272, 280, 284, 285, 286, 289, 291, 296, 310, 315, 318, 319, 332, 338, 339, 343, 346, 347, 352, 356, 361, 362, 365, 367, 387, 398, 406, 414, 420, 421, 429, 432, 436, 442, 446, 447, 449, 450, 455, 461, 462, 464, 466, 476, 479, 483, 484, 485, 496, 502, 504, 505, 511, 513, 514, 516, 517, 523, 525, 530, 539, 544, 545, 551, 555, 564, 567, 582, 586, 597, 604, 607, 612, 613, 624, 633, 635, 639, 644, 649, 651, 661, 666, 669, 673, 682, 686, 688, 700, 706, 708, 711, 714, 715, 716, 717, 728, 730, 734, 738, 742, 744, 748, 750, 765, 771, 776, 777, 779, 785, 793, 797, 800, 802, 810, 822, 829, 837, 844, 846, 851, 853, 855, 858, 861, 864, 866, 868, 876, 878, 879, 883, 884, 887, 888, 889, 890, 891, 893, 897, 898, 899, 900, 903, 905, 908, 916, 919, 922, 924, 928, 941, 944, 947, 951, 956, 968, 971, 975, 978, 988, 997, 1016, 1017, 1020, 1025, 1037, 1039, 1044, 1051, 1053, 1055, 1057, 1065, 1071, 1072, 1075, 1086, 1088, 1089, 1093, 1098, 1106, 1113, 1120, 1121, 1124, 1126, 1127, 1139, 1140, 1147, 1151, 1155, 1180, 1182, 1185, 1186, 1188, 1190, 1195, 1202, 1203, 1207, 1212, 1213, 1222, 1225, 1243, 1247, 1252, 1258, 1262, 1277, 1286, 1303, 1309, 1312, 1320, 1323, 1328, 1347, 1350, 1352, 1354, 1358, 1360, 1362, 1363, 1370, 1380, 1384, 1385, 1410, 1421, 1430, 1433, 1465, 1475, 1478, 1479, 1482, 1485, 1486, 1493, 1494, 1507, 1513, 1514, 1522, 1524, 1534, 1536, 1557, 1559, 1564, 1566, 1575, 1580, 1586, 1587, 1599, 1603, 1606, 1616, 1620, 1621, 1632, 1633, 1644, 1648, 1664, 1676, 1677, 1694, 1702, 1704, 1707, 1708, 1711, 1729, 1751, 1783, 1784, 1792, 1799, 1812, 1814, 1818, 1826, 1832, 1834, 1839, 1872, 1880, 1887, 1894, 1899, 1904, 1919, 1923, 1928, 1935, 1941, 1951, 1952, 1953, 1957, 1960, 1971, 1978, 1981, 1982, 2004, 2006, 2007, 2013, 2016, 2017, 2020, 2023, 2028, 2066, 2073, 2075, 2080, 2082, 2087, 2102, 2105, 2108, 2109, 2121, 2125, 2127, 2130, 2133, 2134, 2150, 2151, 2152, 2157, 2169, 2179, 2196, 2199, 2200, 2202, 2210, 2220, 2223, 2235, 2237, 2240, 2244, 2257, 2277, 2280, 2287, 2290, 2292, 2300, 2303, 2305, 2311, 2316, 2321, 2330, 2334, 2339, 2346, 2353, 2357, 2360, 2374, 2375, 2394, 2398, 2407, 2434, 2441, 2443, 2445, 2449, 2464, 2472, 2478, 2483, 2490, 2508, 2509, 2529, 2540, 2542, 2554, 2556, 2558, 2561, 2565, 2569, 2580, 2584, 2586, 2588, 2591, 2609, 2613, 2627, 2629, 2639, 2643, 2648, 2650, 2652, 2655, 2661, 2663, 2668, 2671, 2673, 2679, 2691, 2700, 2712, 2715, 2725, 2726, 2728, 2736, 2744, 2753, 2755, 2760, 2761, 2764, 2773, 2776, 2780, 2781, 2782, 2790, 2791, 2792, 2801, 2802, 2809, 2812, 2815, 2825, 2828, 2830, 2834, 2835, 2837, 2840, 2846, 2848, 2849, 2859, 2864, 2870, 2881, 2897, 2898, 2902, 2910, 2922, 2928, 2933, 2942, 2946, 2951, 2955, 2956, 2959, 2966, 2970, 2974, 2975, 2984, 2986, 2999, 3013, 3019, 3026, 3028, 3031, 3032, 3033, 3037, 3045, 3048, 3058, 3068, 3075, 3081, 3082, 3085, 3087, 3090, 3100, 3102, 3104, 3105, 3111, 3116, 3118, 3124, 3126, 3128, 3129, 3131, 3141, 3146, 3152, 3165, 3170, 3173, 3186, 3195, 3211, 3213, 3217, 3218, 3220, 3240, 3241, 3242, 3245, 3250, 3251, 3255, 3259, 3261, 3268, 3276, 3277, 3281, 3285, 3293, 3297, 3305, 3315, 3328, 3343, 3345, 3348, 3358, 3362, 3363, 3366, 3372, 3387, 3389, 3393, 3395, 3397, 3403, 3405, 3408, 3409, 3414, 3420, 3421, 3426, 3429, 3437, 3443, 3454, 3470, 3477, 3485, 3486, 3491, 3494, 3501, 3505, 3507, 3512, 3515, 3517, 3522, 3533, 3550, 3556, 3557, 3562, 3571, 3586, 3596, 3598, 3599, 3602, 3603, 3604, 3615, 3623, 3625, 3626, 3649, 3650, 3656, 3657, 3661, 3700, 3707, 3721, 3725, 3747, 3787, 3807, 3824, 3826, 3834, 3836, 3845, 3851, 3854, 3855, 3862, 3869, 3875, 3879, 3882, 3898, 3917, 3919, 3922, 3938, 3939, 3940, 3964, 3972, 3978, 3984, 3986, 3987, 3988, 3994, 4001, 4002, 4013, 4016, 4019, 4020, 4021, 4022, 4027, 4035, 4053, 4057, 4067, 4091, 4094, 4107, 4108, 4121, 4126, 4150, 4167, 4169, 4176, 4180, 4190, 4195, 4199, 4210, 4217, 4219, 4259, 4277, 4281, 4283, 4288, 4296, 4316, 4317, 4321, 4340, 4341, 4347, 4362, 4363, 4364, 4367, 4369, 4379, 4380, 4388, 4391, 4396, 4400, 4402, 4404, 4409, 4417, 4425, 4426, 4436, 4447, 4454, 4458, 4463, 4464, 4466, 4476, 4477, 4480, 4481, 4484, 4487, 4492, 4497, 4500, 4507, 4515, 4517, 4525, 4536, 4542, 4546, 4558, 4573, 4581, 4593, 4598, 4608, 4612, 4617, 4619, 4625, 4626, 4638, 4646, 4657, 4672, 4673, 4675, 4677, 4685, 4691, 4696, 4702, 4709, 4714, 4742, 4764, 4765, 4773, 4789, 4805, 4820, 4829, 4830, 4839, 4842, 4846, 4857, 4863, 4874, 4920, 4922, 4933, 4938, 4947, 4965, 4983, 4996, 5017, 5020, 5026, 5030, 5032, 5034, 5040, 5059, 5067, 5068, 5071, 5085, 5126, 5128, 5145, 5156, 5157, 5164, 5167, 5172, 5176, 5181, 5187, 5193, 5206, 5222, 5226, 5228, 5233, 5234, 5239, 5255, 5273, 5275, 5282, 5298, 5299, 5316, 5338, 5339, 5370, 5392, 5404, 5409, 5415, 5438, 5445, 5447, 5451, 5452, 5453, 5469, 5482, 5485, 5496, 5510, 5520, 5537, 5542, 5546, 5551, 5552, 5563, 5564, 5569, 5582, 5583, 5584, 5588, 5592, 5598, 5606, 5612, 5618, 5626, 5627, 5644, 5646, 5647, 5654, 5658, 5664, 5669, 5671, 5682, 5687, 5706, 5709, 5720, 5721, 5733, 5735, 5758, 5775, 5785, 5805, 5806, 5807, 5811, 5816, 5820, 5827, 5839, 5849, 5860, 5862, 5890, 5896, 5902, 5904, 5908, 5909, 5916, 5921, 5928, 5938, 5957, 5967, 5975, 5983, 6007, 6008, 6010, 6030, 6036, 6038, 6052, 6060, 6066, 6068, 6075, 6078, 6082, 6086, 6110, 6115, 6126, 6134, 6136, 6144, 6154, 6163, 6171, 6177, 6185, 6194, 6225, 6253, 6254, 6264, 6265, 6272, 6312, 6324, 6328, 6329, 6363, 6370, 6500, 6506, 6553, 6575, 6579, 6594, 6652, 6670, 6671, 6718, 6721, 6772, 6781, 6784, 6811, 6834, 6841, 6880, 6937 are missing in core_acl_aro table table.

This one can be fixed in SQL using a tool like phpMyAdmin.

All Core CB Database is up to date.

What am i supposed to do about it and what effect this?

Post edited by: Rapunzl, at: 2008/10/30 00:09

Please Log in to join the conversation.

15 years 6 months ago #77111 by Rapunzl
Replied by Rapunzl on topic Re:entries in the core_acl_aro table without
1. Are you using the CB login/registration module?
2. Did you disable the Joomla login module?
3. Did you disable registration in Joomla Global Registration?
4. Did you set 'independent registration' in CB configuration / registration? Save the configuration even if there is no change.

After all this is confirmed, use Tools / Sync Users.

Jamie (Rapunzl)
Community Builder Team Member

Before posting on forums: Read all CB Articles | Specially the FAQ | Help us help you
CB links: Subscribe to CB documentation | [url=http://www.joomlapolis.com/content/view/7363/37/
]Our templates[/url] | [url=http://www.joomlapolis.com/content/blogcategory/61/74/
]Paid Subscriptions[/url] | Get Hosting | Our Forge
Visit my CB Profile

My personal site Rapunzl's Reality always under reconstruction

Please Log in to join the conversation.

15 years 6 months ago #77114 by nant
most likely these errors are due to bad migration of user data.

CB 1.2 RC3 has a new tool that might help you.

Try it.

Please Log in to join the conversation.

15 years 6 months ago #77119 by Andrej
Yes, everything of what you point at is correct. I double check and saved. And the same error is still there.

Please Log in to join the conversation.

15 years 6 months ago #77120 by Andrej
If the new CB 1.2 RC3 can fix it i will try it out.

Please Log in to join the conversation.

15 years 6 months ago #78494 by pinkyuru
Replied by pinkyuru on topic Re:entries in the core_acl_aro table without
i got a similar error, but i'm using other login (yoo)
and get this too:
SQL ERROR [ mysql4 ]

Duplicate entry 'username' for key 2 [1062]

i use to integrate with my forum

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.248 seconds

Facebook Twitter LinkedIn