Skip to Content Skip to Menu

[SOLVED] Why does CB create duplicates in the db?

  • carin
  • carin
  • OFFLINE
  • Posts: 417
  • Thanks: 18
  • Karma: 0
9 years 10 months ago - 9 years 10 months ago #254814 by carin
I have massive difficulties with the registrstion anyway and now even with no conditional field at all I get even this:

1062 - Duplicate entry '435' for key 'PRIMARY' SQL=INSERT INTO `xz685_comprofiler` (`id`,`user_id`,`firstname`,`lastname`,`approved`,`confirmed`,`registeripaddr`,`cb_businessname`,`cb_country`,`cb_zipcode`,`cb_city`,`cb_street`,`cb_additionaldetails`,`cb_phone`,`cb_mobilephone`,`cb_skype`,`cb_website`,`cb_facebook`,`cb_vat`) VALUES ('435','435','first','name','1','0','::1','coti','country_Spain_195','35660','El Cotillo','Calle Requena, 9','','','','','','','')

Why does CB not take care of duplicates? No I have to code an AJAX call to check for the next available id and have to set that in the form? What is the benefit of that?

CB 2.0
Last edit: 9 years 10 months ago by krileon.

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

  • heyai
  • heyai
  • OFFLINE
  • Posts: 324
  • Thanks: 79
  • Karma: 24
9 years 10 months ago #254815 by heyai
Replied by heyai on topic Why does CB create duplicates in the db?
Have you recently run all the CB database tools in the backend?

hey-ai - the community for asian guys and non-asian girls

The search bar is your friend, not just decoration!
The following user(s) said Thank You: krileon, carin

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

  • carin
  • carin
  • OFFLINE
  • Posts: 417
  • Thanks: 18
  • Karma: 0
9 years 10 months ago #254828 by carin
Replied by carin on topic Why does CB create duplicates in the db?
That helped indeed. Thanks. Do I have to do this every time a user registers?

CB 2.0

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

  • heyai
  • heyai
  • OFFLINE
  • Posts: 324
  • Thanks: 79
  • Karma: 24
9 years 10 months ago #254845 by heyai
Replied by heyai on topic Why does CB create duplicates in the db?
Ideally: no
If your Joomla+CB are set up correctly you won't need to run them again. However, if you or another plugin change the user tables these tools need to be run.
In my case sometimes other admins forget to use the CB user manager instead of the Joomla one. I run the tools every couple of weeks during normal use.
If you encounter this error message again you should try to pinpoint who or what causes it.

hey-ai - the community for asian guys and non-asian girls

The search bar is your friend, not just decoration!
The following user(s) said Thank You: krileon, carin

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

Moderators: beatnantkrileon
Powered by Kunena Forum