Skip to Content Skip to Menu

[SOLVED] entries in the core_acl_aro table without corresponding users table rows.

10 years 6 months ago - 10 years 6 months ago #244338 by steinsandy
Upon checking the users database I receive the error below, and when clicking to repair, it says the errors are repaired but when I check the users database again the problems are still there. Can anyone offer me a solution or should I just start over with a clean install (whimpers)?

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: 210 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=62 (aro_id=), user id=76 (aro_id=), user id=77 (aro_id=), user id=78 (aro_id=), user id=86 (aro_id=), user id=87 (aro_id=), user id=88 (aro_id=), user id=89 (aro_id=), user id=90 (aro_id=), user id=93 (aro_id=), user id=94 (aro_id=), user id=95 (aro_id=), user id=97 (aro_id=), user id=98 (aro_id=), user id=99 (aro_id=), user id=100 (aro_id=), user id=101 (aro_id=), user id=102 (aro_id=), user id=103 (aro_id=), user id=104 (aro_id=), user id=105 (aro_id=), user id=107 (aro_id=), user id=108 (aro_id=), user id=109 (aro_id=), user id=110 (aro_id=), user id=111 (aro_id=), user id=112 (aro_id=), user id=113 (aro_id=), user id=114 (aro_id=), user id=115 (aro_id=), user id=116 (aro_id=), user id=117 (aro_id=), user id=118 (aro_id=), user id=119 (aro_id=), user id=120 (aro_id=), user id=121 (aro_id=), user id=122 (aro_id=), user id=123 (aro_id=), user id=124 (aro_id=), user id=125 (aro_id=), user id=126 (aro_id=), user id=127 (aro_id=), user id=128 (aro_id=), user id=129 (aro_id=), user id=130 (aro_id=), user id=132 (aro_id=), user id=134 (aro_id=), user id=135 (aro_id=), user id=136 (aro_id=), user id=137 (aro_id=), user id=138 (aro_id=), user id=139 (aro_id=), user id=140 (aro_id=), user id=141 (aro_id=), user id=142 (aro_id=), user id=143 (aro_id=), user id=144 (aro_id=), user id=145 (aro_id=), user id=146 (aro_id=), user id=147 (aro_id=), user id=148 (aro_id=), user id=149 (aro_id=), user id=150 (aro_id=), user id=152 (aro_id=), user id=153 (aro_id=), user id=154 (aro_id=), user id=155 (aro_id=), user id=156 (aro_id=), user id=157 (aro_id=), user id=158 (aro_id=), user id=159 (aro_id=), user id=160 (aro_id=), user id=161 (aro_id=), user id=162 (aro_id=), user id=163 (aro_id=), user id=164 (aro_id=), user id=165 (aro_id=), user id=166 (aro_id=), user id=167 (aro_id=), user id=168 (aro_id=), user id=169 (aro_id=), user id=170 (aro_id=), user id=171 (aro_id=), user id=172 (aro_id=), user id=173 (aro_id=), user id=174 (aro_id=), user id=175 (aro_id=), user id=178 (aro_id=), user id=179 (aro_id=), user id=186 (aro_id=), user id=187 (aro_id=), user id=191 (aro_id=), user id=192 (aro_id=), user id=195 (aro_id=), user id=196 (aro_id=), user id=197 (aro_id=), user id=198 (aro_id=), user id=199 (aro_id=), user id=200 (aro_id=), user id=201 (aro_id=), user id=202 (aro_id=), user id=203 (aro_id=), user id=204 (aro_id=), user id=205 (aro_id=), user id=206 (aro_id=), user id=207 (aro_id=), user id=208 (aro_id=), user id=209 (aro_id=), user id=210 (aro_id=), user id=211 (aro_id=), user id=212 (aro_id=), user id=213 (aro_id=), user id=214 (aro_id=), user id=215 (aro_id=), user id=216 (aro_id=), user id=217 (aro_id=), user id=218 (aro_id=), user id=219 (aro_id=), user id=220 (aro_id=), user id=221 (aro_id=), user id=222 (aro_id=), user id=223 (aro_id=), user id=224 (aro_id=), user id=225 (aro_id=), user id=226 (aro_id=), user id=227 (aro_id=), user id=228 (aro_id=), user id=229 (aro_id=), user id=230 (aro_id=), user id=231 (aro_id=), user id=232 (aro_id=), user id=233 (aro_id=), user id=234 (aro_id=), user id=235 (aro_id=), user id=236 (aro_id=), user id=237 (aro_id=), user id=238 (aro_id=), user id=239 (aro_id=), user id=240 (aro_id=), user id=241 (aro_id=), user id=242 (aro_id=), user id=243 (aro_id=), user id=244 (aro_id=), user id=245 (aro_id=), user id=246 (aro_id=), user id=247 (aro_id=), user id=248 (aro_id=), user id=249 (aro_id=), user id=250 (aro_id=), user id=251 (aro_id=), user id=252 (aro_id=), user id=253 (aro_id=), user id=254 (aro_id=), user id=255 (aro_id=), user id=256 (aro_id=), user id=257 (aro_id=), user id=258 (aro_id=), user id=259 (aro_id=), user id=260 (aro_id=), user id=261 (aro_id=), user id=262 (aro_id=), user id=263 (aro_id=), user id=264 (aro_id=), user id=265 (aro_id=), user id=266 (aro_id=), user id=267 (aro_id=), user id=268 (aro_id=), user id=269 (aro_id=), user id=270 (aro_id=), user id=271 (aro_id=), user id=272 (aro_id=), user id=273 (aro_id=), user id=274 (aro_id=), user id=275 (aro_id=), user id=276 (aro_id=), user id=277 (aro_id=), user id=278 (aro_id=), user id=279 (aro_id=), user id=280 (aro_id=), user id=281 (aro_id=), user id=282 (aro_id=), user id=283 (aro_id=), user id=284 (aro_id=), user id=285 (aro_id=), user id=286 (aro_id=), user id=287 (aro_id=), user id=288 (aro_id=), user id=289 (aro_id=), user id=290 (aro_id=), user id=291 (aro_id=), user id=292 (aro_id=), user id=293 (aro_id=), user id=294 (aro_id=), user id=295 (aro_id=), user id=296 (aro_id=), user id=297 (aro_id=), user id=298 (aro_id=), user id=299 (aro_id=), user id=300 (aro_id=), user id=301 (aro_id=), user id=302 (aro_id=), user id=303 (aro_id=), user id=304 (aro_id=), user id=305 (aro_id=), user id=306 (aro_id=), user id=307 (aro_id=), user id=308 (aro_id=), user id=309 (aro_id=), user id=310 (aro_id=), user id=311 (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.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Cassandra Patton
Founder of Campaign Promotions
Promoting Experts in the Virtual Marketplace
campaign-promotions.com

Joomla 2.5.18 & 3.2.2 * CB 1.9.1 * CB Subs 2.0.0 * PHP 5.3.28 * Opera, Firefox, IE & Chrome (all most current versions) * Hosted by Host Gator
Last edit: 10 years 6 months ago by steinsandy.

Please Log in or Create an account to join the conversation.

10 years 6 months ago - 10 years 6 months ago #244339 by steinsandy
I just saw that I need to manually remove these 230 errors from the database, sorry for the wasted time....
Krileon posted:
You have usergroups assigned to users that do not exist. It's best to remove these manually within your _user_usergroup_map database table.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Cassandra Patton
Founder of Campaign Promotions
Promoting Experts in the Virtual Marketplace
campaign-promotions.com

Joomla 2.5.18 & 3.2.2 * CB 1.9.1 * CB Subs 2.0.0 * PHP 5.3.28 * Opera, Firefox, IE & Chrome (all most current versions) * Hosted by Host Gator
Last edit: 10 years 6 months ago by steinsandy.

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum