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 CiviEvent (Moderator: Yashodha Chaku) »
  • Payment confirmation screens
Pages: [1]

Author Topic: Payment confirmation screens  (Read 2025 times)

senojeel

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 1
Payment confirmation screens
July 30, 2007, 01:44:06 pm
I have been looking for answer to this, but haven't found one yet...

In the admin, I can do a test of the registration for an event and it confirms my order and sends emails out and everything.   When I do it from the frontend, it doesn't quit work. First of all, after I hit continue for the order, it takes me back to the same registration form, but in my default template not the template I assigned for the registration page.  Do I have to do something special to make it go to a confirmation screen?


Using Joomla 1.0.12, CiviCRM 1.8 beta and authorize.net.


Thanks!
Shawn
« Last Edit: July 30, 2007, 01:47:30 pm by senojeel »

senojeel

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 1
Re: Payment confirmation screens
July 30, 2007, 01:54:56 pm
So it does work if I use my default template for the form and then the confirmation is returned fine.  So is there a way to set the component to use a template? Will check Joomla forums...

senojeel

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 1
Re: Payment confirmation screens
July 30, 2007, 01:58:38 pm
I got this after I clicked to submit the transaction:



Code: [Select]
unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Database Error Code: Duplicate entry '0-1' for key 2, 1062

    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_contribution (domain_id , contact_id , contribution_type_id , payment_instrument_id , receive_date , total_amount , net_amount , trxn_id , invoice_id , currency , receipt_date , source , amount_level , contribution_status_id ) VALUES ( 1 ,  1 ,  4 ,  1 ,  20070730165638 ,  60 ,  60 , '0' , '5d3a4521e4529800038cb7fd5d07668c' , 'USD' ,  20070730165638 , 'Online Event Registration: Start with  Art 2007' , 'Start with  Art 2007' ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' for key 2]
    [type] => db_error
    [user_info] => INSERT INTO civicrm_contribution (domain_id , contact_id , contribution_type_id , payment_instrument_id , receive_date , total_amount , net_amount , trxn_id , invoice_id , currency , receipt_date , source , amount_level , contribution_status_id ) VALUES ( 1 ,  1 ,  4 ,  1 ,  20070730165638 ,  60 ,  60 , '0' , '5d3a4521e4529800038cb7fd5d07668c' , 'USD' ,  20070730165638 , 'Online Event Registration: Start with  Art 2007' , 'Start with  Art 2007' ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' 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_contribution (domain_id , contact_id , contribution_type_id , payment_instrument_id , receive_date , total_amount , net_amount , trxn_id , invoice_id , currency , receipt_date , source , amount_level , contribution_status_id ) VALUES ( 1 ,  1 ,  4 ,  1 ,  20070730165638 ,  60 ,  60 , '0' , '5d3a4521e4529800038cb7fd5d07668c' , 'USD' ,  20070730165638 , 'Online Event Registration: Start with  Art 2007' , 'Start with  Art 2007' ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' for key 2]"]
)

Does this just mean the email used is already in the database?  If it does, is there a nicer way to get an error message?

Shawn[/code]

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Payment confirmation screens
July 30, 2007, 03:38:29 pm
Shawn - Based on that error message, I'm guessing that you're using Authorize.net as your payment processor. The DB record insert error is happening because the trxn_id is being set to 0 - but this is supposed to be a unique value for each transaction.

There have been some posts on the forum regarding this issue: http://forum.civicrm.org/index.php/topic,486.0.html

You might need to check with Marshall Newrock who contributed the Authorize.net plugin for help debugging.
Protect your investment in CiviCRM by  becoming a Member!

senojeel

  • I post occasionally
  • **
  • Posts: 70
  • Karma: 1
Re: Payment confirmation screens
July 31, 2007, 10:23:02 am
Back to the original reason I posted...

This is Joomla specific... When you continue on my registration form, the order confirmation screen comes up in my default template, not the template I assigned.  Does anyone know if there is a way to make it come back with the same template?

Thanks!
Shawn

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Payment confirmation screens

This forum was archived on 2017-11-26.