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 (Moderator: Dave Greenberg) »
  • DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5
Pages: [1]

Author Topic: DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5  (Read 1046 times)

pmoeckel

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Joomla 1.5
  • MySQL version: 5.0.92-rs-log
  • PHP version: 5.2.17
DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5
June 23, 2011, 10:37:14 am
I hate to make my first post here a help request, but it is what it is, so here we go :-)

I've been working for the last few weeks trying to integrate Civi with a Joomla web site hand having a bit of a rough time. I have been able to work through a number of issues thanks to post here, some subtle, some fairly embarrassing - yes, you need to have user registration enabled in Joomla before a contribute form with compulsory user registration will work... 

But I'm back to one of the same errors I had on my inital crack, after hitting the confirmation button on the second payment screen I get kicked to the following URL:
httpx://XXX/index.php?option=com_civicrm&task=civicrm/contribute/transact&&Itemid=207

And a page that says:
Sorry. A non-recoverable error has occurred.
<hr />
DB Error: already exists

And not much more (notably Error Details is just a gray bar with an what looks like a roll-out tab but no details).

Apache also logs the following:
PHP Notice:  Undefined variable: usertype in / ... /httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CMSUser.php on line 549, referer: httpx://XXX/index.php?option=com_civicrm&task=civicrm/contribute/transact&&Itemid=207&_qf_Confirm_display=true&qfKey=9e7b13a57f4f37f132f4cf8f835e4e58_6726

I currently have the page set to use Civi's dummy payment processor... If anyone can provide some tips or suggestions about how to get more information or how to go about debugging this it would be a huge help. Obviously I'm pretty new at this so I apologies if this has been covered before, if this is this case pointers to previous coverage would also be deeply appreciated and will be rewarded with my best attempts at self-flagellation ;-)

-PM

P.S. Not trying to be obtuse with the URLs, would be great-full to anyone who is willing to check this stuff out but the forum won't let me post links... So if you want to see it in person let me know and I would be happy to IM or email you the info...

pmoeckel

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Joomla 1.5
  • MySQL version: 5.0.92-rs-log
  • PHP version: 5.2.17
Re: DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5
June 23, 2011, 10:54:56 am
Noticed the following:

cat CMSUser.php |grep -C 2 -e usertype

        $userParams = &JComponentHelper::getParams('com_users');

        // get the default usertype
        $userType = $userParams->get('new_usertype');
        if ( !$usertype ) {
            $usertype = 'Registered';
        }

I'm not a PHP coder, so I can't really beguin to wrap my brain around the whole structure here... But it seems as though there might be a typo here? I know there are some coders out there (one of whom I count a a friend) who would use both $userType and $usertype in the same function to insult my puny brain...

Anyway... I'm going to try changing it and see what happens :-)

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: DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5
June 23, 2011, 11:32:04 am

this is a bug, we'll fix it in the next release

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

pmoeckel

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Joomla 1.5
  • MySQL version: 5.0.92-rs-log
  • PHP version: 5.2.17
Re: DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5
June 23, 2011, 11:56:16 am
Donald,

Yeah... No more error in the Apache log. And as the users were being generated in Joomla with the user type of 'Registered' anyway not much of one :-)

Hope I didn't come off as being an ass up there... The complexity of a coding project like Civi is staggering -- especially to someone who nearly failed 'Into To C' ;-) I was just excited to have potentially found the source of my grief...

Unfortunately the same DB Error: already exists after I hit confirm contribution still pops up... And now I'm flat out of ideas. Going to see if I can get logging in Civi working and find more clues, up to this point I had just assumed PEBCAK (and still do) but have hit a wall as to what I might do differently. 

Any tips as to what I else I might try?

-PM

« Last Edit: June 23, 2011, 11:58:11 am by pmoeckel »

pmoeckel

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 3.4.2
  • CMS version: Joomla 1.5
  • MySQL version: 5.0.92-rs-log
  • PHP version: 5.2.17
Re: DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5
June 23, 2011, 03:59:33 pm
Just to add a bit more info:

When I use the test-page link in CiviContribute I get a 500 server error in place of the previously mentioned DB error.

Only other difference I can spot is that time the URL is: ... administrator/index2.php?option=com_civicrm&task=civicrm/contribute/transact

-PM
« Last Edit: June 23, 2011, 04:03:39 pm by pmoeckel »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • DB Error: already exists when submiting confirmation page, Civi 3.4 / Joomla 1.5

This forum was archived on 2017-11-26.