DB Error 1062 on Registration Completion

16 years 6 months ago #48632 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. 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 error:DB 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_country`,`cb_zipcode`,`cb_phone`,`cb_bbcirclemember`,`cb_circlename`,`cb_circle`,`cb_circleyes`,`cb_circlecity`,`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 6 months ago #49051 by lseibert
Replied by lseibert on topic Re:DB Error 1062 on Registration Completion
Anyone have any assistance with this? Thanks so much.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.124 seconds

Facebook Twitter LinkedIn