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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • database error on new user registration
Pages: [1]

Author Topic: database error on new user registration  (Read 1002 times)

Stam

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.5.23
  • PHP version: 5.2.17
database error on new user registration
August 27, 2012, 04:11:39 am
Hi all,

I've created a simple profile form that requires account creation. Whenever the form is submitted, I get the error:

500 - DB Error: already exists

The user still gets created in the backend, despite this error. Any assistance greatly appreciated! Thanks!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: database error on new user registration
August 27, 2012, 06:30:53 am
Can you try this as an admin user and perhaps get a fuller error message?

Also you should enable debugging in CiviCRM.

Last, what items are created aside from a user when someone submits this form? Like tags/groups/other data etc. Seems that something other item is causing the error.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Stam

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.5.23
  • PHP version: 5.2.17
Re: database error on new user registration
August 27, 2012, 08:28:56 am
Hi Hershel :)

I have civiCRM debugging enabled and maximum joomla error reporting on, but I'm not getting anything other than the "500 - DB Error: already exists" message.

When using the form as an admin, it seems to work, but when logged in it doesn't require joomla account creation.

As far as data creation, the form is only creating a new contact and putting them into the "Individual" group - nothing too fancy. It's a very basic form, just requires name and email.

Thanks for the help - I realize this isn't much to go on...

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: database error on new user registration
August 27, 2012, 09:59:13 am
Hello sir. :

The contact is created, but is he also added to the group?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Stam

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.5.23
  • PHP version: 5.2.17
Re: database error on new user registration
August 27, 2012, 10:15:46 am
Yes - when I log in with admin and use the form, the user is successfully created and added to the "Individuals Group".

It does actually create the joomla account and civiCRM entry when submitting the form as a new user, it just sends you to the DB error page.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: database error on new user registration
August 27, 2012, 10:18:21 am
When a new user or anonymous user does it, he's also added to the group?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Stam

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.5.23
  • PHP version: 5.2.17
Re: database error on new user registration
August 27, 2012, 10:30:33 am
Correct.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: database error on new user registration
August 27, 2012, 11:43:51 am
Hmmm. I am not sure. All I can see is that it fails on the URL:

index.php?option=com_civicrm&task=civicrm/profile/create&Itemid=202

Seems that a profile record is supposed to made and perhaps that is failing to be created?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Stam

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.1.3
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.5.23
  • PHP version: 5.2.17
Re: database error on new user registration
August 27, 2012, 01:55:07 pm
Figured it out - Had to disable the civiregistration plugin, which I reckon was not compatible with my installation. Thanks for getting me going on this!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: database error on new user registration
August 28, 2012, 03:34:31 am
Glad you got it. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • database error on new user registration

This forum was archived on 2017-11-26.