|
|
|
DB function failed with error number 1062
|
|
Date: 2007/11/18 14:53
|
By: lseibert
|
Status: User
|
|
|
Karma: 0
|
|
Fresh Joomlapolitan
| Posts: 4 |   |
|
|
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','' ,'','' )
|
|
The administrator has disabled public write access. |
|
 |
|
Re:DB function failed with error number 1062
|
|
Date: 2007/11/18 16:43
|
By: beat
|
Status: Admin
|
|
|
Karma: 256
|
|
Admin
| Posts: 4214 | |
|
|
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  - Developer on Community Builder core Team
- If you like CB and this forum, you will love Nick's CB 1.2 RC4 reference manual !  : Click here to Get it now
- Would like to help us move faster ? Get it, and/or help us spend more time coding by helping others in this forum, many thanks
|
|
|
The administrator has disabled public write access. |
|
|
