User registration problem - HELP!

Hi Guys,

We're having a problem with the registration process on our site. It's throwing up the following error:

moscomprofiler::storeNew failed: Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `eyck7_comprofiler` (`id`,`user_id`,`firstname`,`lastname`,`approved`,`confirmed`,`registeripaddr`) VALUES ('0','0','kjk','jkkj','1','0','92.236.221.40')

Using the tools in the backend all display no problems apart from 'Check Users Database' which displays the below problems. I've tried the tools to fix it as it suggests but it's still coming up with the same errors. Any ideas?

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

All users table rows have links to comprofiler table.

Warning: 2 entries in users table with id=0.

users id=0 is not allowed.

users id=0 is not allowed.

This one can be fixed using menu Components-> Community Builder-> tools and then click `Synchronize users`.

Warning: 1 entries in comprofiler table with id=0.

comprofiler id=0 is not allowed.

This one can be fixed using menu Components / Community Builder / Tools and then click "Synchronize users".

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: 149 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=44 (aro_id=), user id=45 (aro_id=), user id=46 (aro_id=), user id=47 (aro_id=), user id=48 (aro_id=), user id=49 (aro_id=), user id=50 (aro_id=), user id=51 (aro_id=), user id=52 (aro_id=), user id=53 (aro_id=), user id=54 (aro_id=), user id=55 (aro_id=), user id=56 (aro_id=), user id=57 (aro_id=), user id=58 (aro_id=), user id=59 (aro_id=), user id=60 (aro_id=), user id=61 (aro_id=), user id=62 (aro_id=), user id=64 (aro_id=), user id=71 (aro_id=), user id=75 (aro_id=), user id=76 (aro_id=), user id=77 (aro_id=), user id=78 (aro_id=), user id=81 (aro_id=), user id=82 (aro_id=), user id=83 (aro_id=), user id=87 (aro_id=), user id=91 (aro_id=), user id=92 (aro_id=), user id=93 (aro_id=), user id=96 (aro_id=), user id=113 (aro_id=), user id=117 (aro_id=), user id=118 (aro_id=), user id=119 (aro_id=), user id=127 (aro_id=), user id=140 (aro_id=), user id=238 (aro_id=), user id=240 (aro_id=), user id=284 (aro_id=), user id=294 (aro_id=), user id=311 (aro_id=), user id=312 (aro_id=), user id=313 (aro_id=), user id=331 (aro_id=), user id=334 (aro_id=), user id=335 (aro_id=), user id=336 (aro_id=), user id=337 (aro_id=), user id=338 (aro_id=), user id=339 (aro_id=), user id=340 (aro_id=), user id=341 (aro_id=), user id=342 (aro_id=), user id=343 (aro_id=), user id=344 (aro_id=), user id=345 (aro_id=), user id=346 (aro_id=), user id=347 (aro_id=), user id=348 (aro_id=), user id=349 (aro_id=), user id=352 (aro_id=), user id=353 (aro_id=), user id=355 (aro_id=), user id=356 (aro_id=), user id=357 (aro_id=), user id=358 (aro_id=), user id=359 (aro_id=), user id=360 (aro_id=), user id=370 (aro_id=), user id=371 (aro_id=), user id=372 (aro_id=), user id=379 (aro_id=), user id=380 (aro_id=), user id=381 (aro_id=), user id=382 (aro_id=), user id=383 (aro_id=), user id=384 (aro_id=), user id=385 (aro_id=), user id=387 (aro_id=), user id=388 (aro_id=), user id=393 (aro_id=), user id=394 (aro_id=), user id=399 (aro_id=), user id=401 (aro_id=), user id=411 (aro_id=), user id=416 (aro_id=), user id=417 (aro_id=), user id=418 (aro_id=), user id=419 (aro_id=), user id=421 (aro_id=), user id=422 (aro_id=), user id=424 (aro_id=), user id=425 (aro_id=), user id=426 (aro_id=), user id=427 (aro_id=), user id=430 (aro_id=), user id=431 (aro_id=), user id=432 (aro_id=), user id=433 (aro_id=), user id=434 (aro_id=), user id=435 (aro_id=), user id=436 (aro_id=), user id=437 (aro_id=), user id=439 (aro_id=), user id=440 (aro_id=), user id=442 (aro_id=), user id=443 (aro_id=), user id=449 (aro_id=), user id=450 (aro_id=), user id=452 (aro_id=), user id=453 (aro_id=), user id=454 (aro_id=), user id=455 (aro_id=), user id=456 (aro_id=), user id=457 (aro_id=), user id=458 (aro_id=), user id=459 (aro_id=), user id=463 (aro_id=), user id=464 (aro_id=), user id=474 (aro_id=), user id=489 (aro_id=), user id=493 (aro_id=), user id=494 (aro_id=), user id=495 (aro_id=), user id=496 (aro_id=), user id=497 (aro_id=), user id=500 (aro_id=), user id=501 (aro_id=), user id=503 (aro_id=), user id=505 (aro_id=), user id=506 (aro_id=), user id=507 (aro_id=), user id=512 (aro_id=), user id=518 (aro_id=), user id=519 (aro_id=), user id=522 (aro_id=), user id=523 (aro_id=), user id=526 (aro_id=), user id=527 (aro_id=), user id=528 (aro_id=), user id=529 (aro_id=), user id=530 (aro_id=), user id=532 (aro_id=), user id=533 (aro_id=), user id=534 (aro_id=), user id=536 (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.