[SOLVED] Error 1062

Hello,
For several days I have a 1062 error when a new utilistauer wants to register .
He told me : "DUPLICATE ENTRY ' 1024' FOR KEY ' PRIMARY ' SQL = INSERT INTO` BS3U0_COMPROFILER` "
I do not know fix this error.
Can you help me?
Best Regards.
Eric

Run Synchronize Users tool from CB > Tools and see if your issue persists. Your _users and _comprofiler table are out of sync. Do not use Joomla user management, registration, or login; you must use CB > User Management and CBs login/registration.

Hello ,
Thank you for your reply, I did what you say , I also checked the database , there were mistakes, which appear to have been repaired.
I redid all the tests, I have no error message, but the problem persists.
This last Sunday .

Best Regards.

Eric

Disable non-core CB plugins 1 by 1 until it resolves. If that doesn't resolve it repeat with Joomla System and User plugins (non-core! this is vital, as some core Joomla plugins will lock your install) to see if a 3rd party extension is conflicting.

If no extension appears to be conflicting then auto increment seams to be set incorrectly. Manually altering _users or _comprofiler tables can cause this. Using phpmyadmin navigate to the _users database table then click Operations and ensure AUTO_INCREMENT is set correctly. It should be the next ID column value. So for example if the highest ID you have in _users is 1072 then AUTO_INCREMENT would be 1073. It's fine for it to be significantly higher than the last ID as well; it just needs to be higher than and not lower than.

Hello, thank you for this help.
In the table I see fields "NULL" in the " First Name" while this is mandatory , is this normal and could this be the reason problems?
Best regards.
Eric

No, it's strictly the users ID that's causing your issue. It's trying to duplicate an existing ID. This is normally a conflict from a 3rd party Joomla extension or even CB plugin (e.g. CB Auto Actions if used incorrectly). You need to disable non-core usages to see if issue goes away.