CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • User registration problems
Pages: 1 [2]

Author Topic: User registration problems  (Read 5724 times)

mantzm

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.2 Stable
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: User registration problems
March 25, 2012, 10:28:08 am
System: Joomla 2.5.1 Civicrm 4.1.1 -
Still having minor problems - after applying  Joomla.php.3.patch. I'm now able to create both a user in Civicrm & Joomla yet it throws an error meesage saying : Sorry. A non-recoverable error has occurred. DB Error: already exists -Error Database Error Code: Duplicate entry '(HIDDEN FOR PRIVACY)-1' for key 2, 1062

I can provide the full detail of the error if needed. Can someone help?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: User registration problems
March 25, 2012, 03:00:01 pm

yes, please do provide full detail on the error. Can you take a closer look and see if u can debug and figure out how to improve the patch

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: User registration problems
March 25, 2012, 08:05:01 pm
i suspect the full error describes a duplicate match on the uf_match table?
the uf_match table is what is used to join the joomla user to the civi contact record. you probably have a few bad records in there, where a record was created for a user you are now trying to create a new account for.

take a look at the uf_name field in that table and see if a record exists with the email for the user you are creating an account for. if so -- delete that record and try to create the account again.

at some point we should try to trap errors better with this table.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

mantzm

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.2 Stable
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: User registration problems
March 30, 2012, 05:34:49 pm
Sorry I did not have topic notify on- Just saw your responses...

I did check and everything in relation to that email was removed from the database prior to trying.

Lobo, I not a coder sorry... But I can sure test things out and asssist the coders the best I can...

Ok trying to post the error message but it won't let me - how do I get it to you?
Sorry expert forum poster - it keeps saying 'Sorry, you are not allowed to post external links." yet I do not see external links.

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: User registration problems
March 31, 2012, 06:47:53 am
the error you are getting is with the civicrm_uf_match table.
please check that table again for the presence of your test email. also try using a different email to confirm it's working and that the only issue is the existence of the bad data.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

mantzm

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.2 Stable
  • MySQL version: 5.0.95
  • PHP version: 5.3.10
Re: User registration problems
March 31, 2012, 07:13:59 am
Ok that did the trick - you can not just use Civicrm to permanently delete the "email address" in the "uf_match table" you will have to manually remove that. I was only removing the Joomla User and the Civicrm User - you have to go through to your PhpAdmin and manually remove the email associated with the above 2 to be able to recreate a user with same email.

Maybe in the future the function of user removal (permanently deleting) a user record in Civicrm can include removing the record in "uf_match" to make this easier. Should I open a tracker?

Once again Thanks for all your help...  Still having problems with the Authentication Plugin, I will address that separately.

MM

lefer

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.1
  • CMS version: Joomla 2.5.4
  • MySQL version: 5.5
  • PHP version: 5.3
Re: User registration problems
June 19, 2012, 09:30:04 am
I'm having a problem with creating joomla user with a profile of civicrm. Someone has gone through this problem?

nicol

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 5
  • CiviCRM version: 4.2, 4.3, 4.4
  • CMS version: Joomla 2.5.x, Joomla 3.x Wordpress 3.x, Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.3 / 5.4
Re: User registration problems
June 19, 2012, 10:36:33 am
The problem described here was fixed.

Are you creating the user thru the admin interface, a front-end Joomla registration form, or a Civi Contribute / Event page?
Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • User registration problems

This forum was archived on 2017-11-26.