CiviCRM Community Forums (archive)

Very confused. After a few months of working with CiviCRM on Joomla 1.5.14 (and earlier) and testing it successfully numerous times, since moving it to a new server and upgrading, and doing a few further tests (successfully), since making the site live yesterday at http://www.wapcepc,org I'm now getting the duplicated email account error, the first time someone registers on the site with a new email address (even when they aren't being sent to a payment handler):

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: already exists

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 121 , 'test2@xxxx.org' ,  35 )  [nativecode=1062 ** Duplicate entry 'test2@xxxx.org' for key 2]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 121 , 'test2@xxxx.org' ,  35 )  [nativecode=1062 ** Duplicate entry 'test2@xxxx.org' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_uf_match (uf_id , uf_name , contact_id ) VALUES ( 121 , 'test2@xxxx.org' ,  35 )  [nativecode=1062 ** Duplicate entry 'test2@xxxx.org' for key 2]"]
)

I've tested this with a bunch of email addresses that have never been used on the site and it's still telling me that they already exist.

Tried to search the forums but couldn't see anything on this,

thanks
Nic[/code]

Thanks for the quick reply.

It seems fixed now. Here's what I did:

 - After posting this I remade the menu links (clutching at straws). Then all attempted signups created a 'cannot find key' error.

 - A while later (an hour) I tried purging expired cache in Joomla backend, and deleting all cache items, and when I tried again signup worked - and continued to work on four separate tests on safari and firefox.

I don't really understand, but if the error returns I'll repost.

Nic