I just upgraded CB on a big site for a client to prepare for CBSUBS installation and when I try to register as a new user, we get the following error:

moscomprofiler::storeNew failed: Duplicate entry '30486' for key 'PRIMARY' SQL=INSERT INTO `tqyap_comprofiler` (`id`,`user_id`,`firstname`,`lastname`,`approved`,`confirmed`,`registeripaddr`,`cb_country`,`cb_country_desc`,`cb_state`,`cb_doctorbased`,`cb_profession`,`cb_doctorspcialty`) VALUES ('30486','30486','Eric','Caldwell','1','1','99.19.78.156','US','United States','AR','Office Based','MD or DO','Urology')

I tried the usual CB Tools sync and repairs but, no luck. The user is registered but, the page reloads and shows the SQL instead of the normal next step.

BTW, your support ticket system is broken. You get an internal server error when submitting a ticket with the information you would need to login to our system.

Ok, I had to hire a developer to look into this over the weekend and they did the following:

updated following file
/administrator/components/com_comprofiler/library/cb/cb.tables.php

Added following lines after line #2453

$db = JFactory::getDBO();
$db->setQuery("DELETE FROM #__comprofiler WHERE user_id = '".$this->_cmsUser->id."'");
$db->Query();

Why would this be necessary?

Thanks

Just tried your suggestion and no-go. Same error message with an incremented number. I made sure that both the _users and were all set to increment to the next number and they were, and did, even properly created the user but then put up that SQL error message.

Thoughts?

As for the ticket. I can pull the code out since its in the forums now. We run WHMCS too but, don't have that set to block code.

Should I open a ticket?

Just to give everyone an update. What was causing this was the OSE Membership addon. There is a setting in the OSE User V5 plugin where you can set to create CB profile. If that is checked, this will cause this problem. Thanks to the CB team for helping us solve this.