Answers.Body: <p>Check PayPal IPN is configured properly or not.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-09T02:22:22.103Z
Answers.Text: IPN appears to be correct, Have a paypal support request
Answers.UserDisplayName: Rob
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-09T02:37:12.073Z
Answers.Text: Should  my site be listed with paypal as http or https? documentation just says http://www.example.com, have tried both
Answers.UserDisplayName: Rob
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-09T03:11:44.923Z
Answers.Text: If you have enabled SSL for civicrm then you nees to use https otherwise http.
Answers.UserDisplayName: Prem Patel
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-13T16:45:26.080Z
Answers.Text: Paypal is sending IPN to the website link  that generates a page not found
Answers.UserDisplayName: Rob
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-13T16:48:47.883Z
Answers.Text: the error log for the site records:  [13-Dec-2015 13:48:44 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status timestamp <= 1355406524 and id not in (select redirect_id from oxhhm_wbz4' at line 1 for query select id from oxhhm_wbz404_redirects where status = 2 status timestamp <= 1355406524 and id not in (select redirect_id from oxhhm_wbz404_logs) made by do_action_ref_array, call_user_func_array, wbz404_cleaningCron
Answers.UserDisplayName: Rob
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-13T16:49:32.237Z
Answers.Text: the link looks looks this........../wp-content/plugins/civicrm/civicrm/extern/ipn.php?reset=1&contactID=2&contributionID=12&module=event&eventID=1&participantID=12
Answers.UserDisplayName: Rob
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-02T23:57:34.173Z
Answers.Text: Problem fixed- folder was set to not writable. changed access and it works
Answers.UserDisplayName: Rob
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-04T04:34:10.957Z
Answers.Text: which folder was not set to writable? @Rob
Answers.UserDisplayName: harshal
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-08T09:22:01.823Z
Answers.LastActivityDate: 2015-12-08T09:22:01.823Z
Answers.UserDisplayName: Prem Patel
Body: <p>Registrants have status recorded as  Pending from incomplete transaction
  even after PayPal has collected fee and confirmed payment</p>
  
  <p>I have been over the PayPal processor setup multiple times and believe I have followed the text.</p>
  
  <p>I have created an event and assigned the PayPal processor to it.
  When I do a  registration civicrm accepts the registration and presents me to the PayPal site. the payment is made , charging the registrant and completing the payment to my merchant account, PayPal returns me to the registration page with the message "Your registration payment has been submitted to test <em>( test is the name of the fees for this event)</em> for processing. Please print this page for your records."
   PayPal merchant account sends out a notice to both my PayPal merchant email and the registrant email confirming the transaction.</p>
  
  <p>when I look in the event registration list to view the registrants, there are no attendees paid. 
  Only when I look in Pending from incomplete transaction do I find the listing with the pending notice attached.</p>
  
  <p>CiviCRM version:     4.6
  CMS version:     wordpress 4.3.1
  MySQL version:     5.5.42
  PHP version:     4.0.10.7 </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-08T09:54:31.603Z
Comments.Text: I reckon you will need to give a little more information for people to be able to provide a decent answer? Unfortunately I have no experience with PayPal so I can not help you :-(
Comments.UserDisplayName: ErikH - CiviCooP
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-01-03T00:03:35.740Z
Comments.Text: Solution to problem - working on old WP install (4years old) -  removed the htaccess file in the wp-content folder which made it impossible for outside sources to access php code. works now !!!
Comments.UserDisplayName: Rob
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-04T14:02:32.657Z
Comments.Text: Since you found the solution - please add an answer (not a comment) and accept your own answer.
Comments.UserDisplayName: Sanjay Jain
Tags: <payment-processor>
Title: Pending from incomplete transaction
ThreadText: # Pending from incomplete transaction
  
  (Asked by: username_0 on 2015-12-08)
  
  Registrants have status recorded as Pending from incomplete transaction
  even after PayPal has collected fee and confirmed payment
  
  I have been over the PayPal processor setup multiple times and believe I have followed the text.
  
  I have created an event and assigned the PayPal processor to it.
  When I do a registration civicrm accepts the registration and presents me to the PayPal site. the payment is made , charging the registrant and completing the payment to my merchant account, PayPal returns me to the registration page with the message "Your registration payment has been submitted to test *( test is the name of the fees for this event)* for processing. Please print this page for your records."
  PayPal merchant account sends out a notice to both my PayPal merchant email and the registrant email confirming the transaction.
  
  when I look in the event registration list to view the registrants, there are no attendees paid.
  Only when I look in Pending from incomplete transaction do I find the listing with the pending notice attached.
  
  CiviCRM version: 4.6
  CMS version: wordpress 4.3.1
  MySQL version: 5.5.42
  PHP version: 4.0.10.7
  
  **Tags:** payment-processor
  
  > **Comments:**
  > **username_1**: I reckon you will need to give a little more information for people to be able to provide a decent answer? Unfortunately I have no experience with PayPal so I can not help you :-(  
  > **username_0**: Solution to problem - working on old WP install (4years old) -  removed the htaccess file in the wp-content folder which made it impossible for outside sources to access php code. works now !!!  
  > **username_2**: Since you found the solution - please add an answer (not a comment) and accept your own answer.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2015-12-08. Score: 1
  
  Check PayPal IPN is configured properly or not.
  
  > **Comments:**
  > **username_0**: IPN appears to be correct, Have a paypal support request  
  > **username_0**: Should  my site be listed with paypal as http or https? documentation just says http://www.example.com, have tried both  
  > **username_3**: If you have enabled SSL for civicrm then you nees to use https otherwise http.  
  > **username_0**: Paypal is sending IPN to the website link  that generates a page not found  
  > **username_0**: the error log for the site records:  [13-Dec-2015 13:48:44 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status timestamp <= 1355406524 and id not in (select redirect_id from oxhhm_wbz4' at line 1 for query select id from oxhhm_wbz404_redirects where status = 2 status timestamp <= 1355406524 and id not in (select redirect_id from oxhhm_wbz404_logs) made by do_action_ref_array, call_user_func_array, wbz404_cleaningCron  
  > **username_0**: the link looks looks this........../wp-content/plugins/civicrm/civicrm/extern/ipn.php?reset=1&contactID=2&contributionID=12&module=event&eventID=1&participantID=12  
  > **username_0**: Problem fixed- folder was set to not writable. changed access and it works  
  > **username_4**: which folder was not set to writable? @username_0  
  
  ---
  
  