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) »
  • Errors during registration
Pages: [1]

Author Topic: Errors during registration  (Read 4652 times)

cruiskeenconsulting

  • Guest
Errors during registration
May 06, 2008, 09:43:55 am
We're registering people for an event, and occasionally people are reporting an error during registration.  It APPEARS that this is a problem when they pay via Paypal.  I havent' been able to replicate the problem, of course. 

We're receiving some repeating errors in the logs that look like this:

May 05 07:08:59  [info] $Fatal Error Details = Array
(
    [message] => We experienced an unexpected error. Please file an issue with the backtrace
   
Code: [Select]
=>
)


May 05 07:08:59  [info] $backTrace = /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 265
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/DAO.php, fatal, 627
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php, getFieldValue, 57
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php, __construct, 47
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Event/Invoke.php, __construct, 99
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/Component.php, main, 130
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/Invoke.php, invoke, 158
/home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 329
, civicrm_invoke,
/home/.geordi/wnp/wisconsinnonprofits.org/includes/menu.inc, call_user_func_array, 418
/home/.geordi/wnp/wisconsinnonprofits.org/index.php, menu_execute_active_handler, 15

And also Occasionally

May 06 06:12:28  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_participant_payment (participant_id ) VALUES ( 60 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wnpadrupal/civicrm_participant_payment`, CONSTRAINT `FK_civicrm_participant_payment_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_participant_payment (participant_id ) VALUES ( 60 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wnpadrupal/civicrm_participant_payment`, CONSTRAINT `FK_civicrm_participant_payment_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_participant_payment (participant_id ) VALUES ( 60 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wnpadrupal/civicrm_participant_payment`, CONSTRAINT `FK_civicrm_participant_payment_contribution_id` FOREIGN KEY (`contribution_id`) REFERENCES `civicrm_contribution` (`id`) ON DELETE CASCADE)]"]
)


Any insight would be appreciated[/code]

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: Errors during registration
May 07, 2008, 03:50:09 am

Both the below errors are a bit wierd.

the first error basically indicates that we could not find the event id. the second error indicate that a contribution id was missing.

seems like the session has vanished while the user was doing the payment. is the processor paypal standard or paypal pro?

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

cruiskeenconsulting

  • Guest
Re: Errors during registration
May 07, 2008, 07:44:51 am
Paypal Standard.

I'm beginning to think that some of this may be due to the issue with clicking on the print icon in the midst of the registration process --- I'm still trying to get in touch with the users who were having the problem, but alas usually all I can get from them is that "there was some kind of error while I was registering". 

cruiskeenconsulting

  • Guest
Re: Errors during registration
May 08, 2008, 03:01:02 pm
I'm not sure if this is any help or not, but I've set up the email on fatal errors from the server, and this is an example of what I get occasionally:
There was a CiviCRM error at Wisconsin Non-Profits Association.


***CIVICRM ERROR***
message:            We experienced an unexpected error. Please file an issue with the backtrace code:               


***PHP ERROR***



***USER***
uid:                0 hostname:           204.246.129.196 roles:              Array
(
   [1] => anonymous user
)

session:             cache:              0


***SERVER***
PATH:               /usr/local/bin:/usr/bin:/bin REDIRECT_STATUS:    200 UNIQUE_ID:          Gp8L@UBvawgAAFjgJVYAAAAD SCRIPT_URL:         /civicrm/event/register SCRIPT_URI:         http://wisconsinnonprofits.org/civicrm/event/register HTTP_ACCEPT:        text/plain, text/html, text/xml, text/vnd.wap.wml, application/vnd.wap.wmlc HTTP_ACCEPT_LANGUAGE:en, *;q=0.7 HTTP_USER_AGENT:    Mozilla/4.0 HTTP_HOST:          wisconsinnonprofits.org HTTP_CONNECTION:    Keep-Alive SERVER_SIGNATURE:    SERVER_SOFTWARE:    Apache/2.0.61 (Unix) PHP/4.4.7 mod_ssl/2.0.61 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.4.2 SERVER_NAME:        wisconsinnonprofits.org SERVER_ADDR:        208.97.162.22 SERVER_PORT:        80 REMOTE_ADDR:        204.246.129.196 DOCUMENT_ROOT:      /home/wnp/wisconsinnonprofits.org SERVER_ADMIN:       webmaster@wisconsinnonprofits.org SCRIPT_FILENAME:    /home/wnp/wisconsinnonprofits.org/index.php REMOTE_PORT:        28530 REDIRECT_QUERY_STRING:q=civicrm/event/register REDIRECT_URL:       /index.php GATEWAY_INTERFACE:  CGI/1.1 SERVER_PROTOCOL:    HTTP/1.1 REQUEST_METHOD:     GET QUERY_STRING:       q=civicrm/event/register REQUEST_URI:        /civicrm/event/register SCRIPT_NAME:        /index.php ORIG_SCRIPT_FILENAME:/dh/cgi-system/php5.cgi ORIG_PATH_INFO:     /index.php ORIG_PATH_TRANSLATED:/home/wnp/wisconsinnonprofits.org/index.php ORIG_SCRIPT_NAME:   /cgi-system/php5.cgi PHP_SELF:           /index.php REQUEST_TIME:       1210283577 argv:               Array
(
   
  • => q=civicrm/event/register

)

argc:               1


***REQUEST***
q:                  civicrm/event/register


***BACKTRACE***
**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/Error.php line:               249 function:           civicrm_error_handler args:               Array
(
   
  • => Array

       (
           [message] => We experienced an unexpected error. Please file an issue with the backtrace
           
Code: [Select]
=>        )

)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/DAO.php line:               627 function:           fatal class:              CRM_Core_Error type:               :: args:               Array
(
)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php line:               57 function:           getFieldValue class:              CRM_Core_DAO type:               :: args:               Array
(
   [0] => CRM_Event_DAO_Event
   [1] =>    [2] => is_monetary
)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php line:               47 function:           __construct class:              CRM_Event_StateMachine_Registration type:               -> args:               Array
(
   [0] => CRM_Event_Controller_Registration Object
       (
           [_title:protected] => Online Registration
           [_key] => e1c1ca71b44cbd6747632173f9278ed3
           [_scope:protected] => CRM_Event_Controller_Registration_e1c1ca71b44cbd6747632173f9278ed3
           [_stateMachine:protected] =>            [_embedded:protected] =>            [_print:protected] => 0
           [_parent:protected] =>            [_pages] => Array
               (
               )

           [_actions] => Array
               (
               )

           [_name] => CRM_Event_Controller_Registration_e1c1ca71b44cbd6747632173f9278ed3
           [_modal] => 1
           [_actionName] =>        )

   [1] => 0
)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Event/Invoke.php line:               99 function:           __construct class:              CRM_Event_Controller_Registration type:               -> args:               Array
(
   [0] => Online Registration
)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/Component.php line:               130 function:           main class:              CRM_Event_Invoke type:               :: args:               Array
(
   [0] => Array
       (
           [0] => civicrm
           [1] => event
           [2] => register
       )

)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/CRM/Core/Invoke.php line:               158 function:           invoke class:              CRM_Core_Component type:               :: args:               Array
(
   [0] => Array
       (
           [0] => civicrm
           [1] => event
           [2] => register
       )

   [1] => main
)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/sites/all/modules/civicrm/drupal/civicrm.module line:               329 function:           invoke class:              CRM_Core_Invoke type:               :: args:               Array
(
   [0] => Array
       (
           [0] => civicrm
           [1] => event
           [2] => register
       )

)


**next call**
function:           civicrm_invoke args:               Array
(
   [0] => event
   [1] => register
)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/includes/menu.inc line:               418 function:           call_user_func_array args:               Array
(
   [0] => civicrm_invoke
   [1] => Array
       (
           [0] => event
           [1] => register
       )

)


**next call**
file:               /home/.geordi/wnp/wisconsinnonprofits.org/index.php line:               15 function:           menu_execute_active_handler args:               Array
(
)


shunshifu

  • I’m new here
  • *
  • Posts: 10
  • Karma: 0
Re: Errors during registration
May 28, 2008, 10:27:07 am
We are getting what looks like the same error. Was this ever resolved

Here's mine

    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
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -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 ,  20080528091808 ,  350.00 ,  350.00 , '0' , '5e6a6fef614d768a4fede22d3e597f35' , 'USD' ,  20080528091808 , 'Online Event Registration: EMT Instructor Orientation' , 'Tuition and Books' ,  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 ,  20080528091808 ,  350.00 ,  350.00 , '0' , '5e6a6fef614d768a4fede22d3e597f35' , 'USD' ,  20080528091808 , 'Online Event Registration: EMT Instructor Orientation' , 'Tuition and Books' ,  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 ,  20080528091808 ,  350.00 ,  350.00 , '0' , '5e6a6fef614d768a4fede22d3e597f35' , 'USD' ,  20080528091808 , 'Online Event Registration: EMT Instructor Orientation' , 'Tuition and Books' ,  1 )  [nativecode=1062 ** Duplicate entry '0-1' for key 2]"]
)

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Errors during registration
May 28, 2008, 02:35:41 pm
Are you using Authorize.net in test drive mode? If so, do some searches on this forum for the error msg plus Authorize.net.
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Errors during registration

This forum was archived on 2017-11-26.