DB function failed with error number 1062

16 years 5 months ago #50444 by lseibert
When a user registers on our client's site, www.bikinisandbifocals.com, they receive the following error on the completion of thier registration. They are using the Account Expiration Control Component for site paid registrations. Please help. The guys at AEC said this was a Community Builder issue. Thanks.

> Registration Complete!
> An email with further instructions on how to complete your registration has been sent to the email address you provided. Please check your email to complete your registration.
>
> 1store errorB function failed with error number 1062 Duplicate entry
> '512' for key 1 SQL=INSERT INTO jos_comprofiler (
> `id`,`user_id`,`approved`,`confirmed`,`cb_suiteapt`,`cb_streetaddress`
> ,`cb_city`,`cb_state`,`cb_country`,`cb_zipcode`,`cb_phone`,`cb_bbcircl
> emember`,`cb_circlename`,`cb_circle`,`cb_circleyes`,`cb_circlecity`,`c
> b_circlestate`,`cb_circlecountry`,`cb_circlenumber`,`cb_findout`,`cb_b
> irthyear`,`firstname`,`middlename`,`lastname` ) VALUES ( '512','512','1','0','','18 Valleyview Drive','Fisherviille','KY','USA','40023','502-442-7851','No','','','','','','','','Friend','1988','' ,'','' ) SQL = INSERT INTO jos_comprofiler ( `id`,`user_id`,`approved`,`confirmed`,`cb_suiteapt`,`cb_streetaddress`,`cb_city`,`cb_state`,`cb_coun try`,`cb_zipcode`,`cb_phone`,`cb_bbcirclemember`,`cb_circlename`,`cb_circle`,`cb_circleyes`,`cb_circ lecity`,`cb_circlestate`,`cb_circlecountry`,`cb_circlenumber`,`cb_findout`,`cb_birthyear`,`firstname `,`middlename`,`lastname` ) VALUES ( '512','512','1','0','','18 Valleyview Drive','Fisherviille','KY','USA','40023','502-442-7851','No','','','','','','','','Friend','1988','' ,'','' )

Please Log in to join the conversation.

16 years 5 months ago #50456 by beat
That error just says database seems not ok, having an entry with id 512 in it already in jos_comprofiler table, while it shouldn't have one.

Doesn't happen without AEC. I didn't look at AEC and AEC's hacks in CB, so can't tell why this happens. Checked CB genuine code and didn't see a bug.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.157 seconds

Facebook Twitter LinkedIn