Answers.Body: <p>Donald, Could you help us with</p>
  
  <ol>
  <li><p>From which version of CiviCRM did you upgrade to 4.7.11?</p></li>
  <li><p>Are you using any payment processor extension like iAts, etc?</p></li>
  <li><p>Could you check in db if you get 0 results by running the query below</p>
  
  <p><code>SELECT ccr.payment_processor_id FROM civicrm_contribution_recur ccr 
  LEFT JOIN civicrm_payment_processor cpp ON cpp.id = ccr.payment_processor_id 
  WHERE cpp.id IS NULL
  GROUP BY ccr.payment_processor_id
  </code></p></li>
  <li><p>Could you also paste the result of below query?</p>
  
  <p><code>SELECT cr.payment_processor_id as ppID1, cp.payment_processor as ppID2
    FROM civicrm_membership mem
  INNER JOIN civicrm_membership_payment mp  ON ( mem.id = mp.membership_id )
  INNER JOIN civicrm_contribution       con ON ( mp.contribution_id = con.id )
  LEFT JOIN civicrm_contribution_recur cr  ON ( mem.contribution_recur_id = cr.id )
  LEFT JOIN civicrm_contribution_page  cp  ON ( con.contribution_page_id  = cp.id )</code></p></li>
  </ol>
  
  <p>Thanks
  Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:32:25.343Z
Answers.Text: 1) Was on previous version 4.7.10.  Upgrade and database upgrade completed without incident.  2) Using no payment processor extensions just what comes with civicrm we have been on paypal standard.  I am separately having issues with the IPN coming back but not updating the status of memberships.  I mention this but don't have reason to believe it is related. 3. MySQL returned an empty result set (i.e. zero rows).  4.  I get 4509 total rows either NULL NULL, NULL 3, or NULL 7.  Can't paste that many rows, happy to send other way. Pls advise
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:39:39.227Z
Answers.Text: Can paste result for 
  
  
  1. Select payment_processor_id FROM civicrm_contribution_recur GROUP BY payment_processor_id;
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:41:39.470Z
Answers.Text: And also for
  
  Select payment_processor_id FROM civicrm_contribution_page;
  
  Check if you see payment_processor_id that are not equal to civicrm_payment_processor.id
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:56:39.637Z
Answers.Text: Select payment_processor_id FROM civicrm_contribution_recur GROUP BY payment_processor_id;   Returned an empty result set (i.e. zero rows). (Query took 0.0016 seconds.)
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:58:29.947Z
Answers.Text: Select payment_processor FROM civicrm_contribution_page Returned  NULL
  NULL
  NULL
  3
  3
  3
  3
  3
  7
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T18:28:56.090Z
Answers.Text: So you have id 3 and 7 present in civicrm_payment_processor?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T18:34:57.153Z
Answers.Text: Let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/45710/discussion-between-pradeep-nayak-and-donald-knapp).
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T09:08:10.017Z
Answers.LastActivityDate: 2016-09-21T09:08:10.017Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>I would check to see which Payment Processors are enabled on the Membership form.  In Manage Contributions you will find the Membership one, look at the Amounts Tab (even though it's grayed out) and be sure a valid Payment processor is checked.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-20T13:48:32.327Z
Answers.Text: On the Manage Contribution Page I have checked the Amounts tab.  The payment processor is checked.  Note this contribution page was set up months ago.  I am currently just inquiring on a membership by clicking memberships from View Contacts when this blows up.
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-20T13:51:50.310Z
Answers.Text: I am.   I did this from memory :)   Fixed the answer.   If that does not do it - I'd create a new processor (even test) and switch to that for testing.  I have had times were the payment processor was the problem.   I don't have a joomla install to test on.   Do you get any error mesages in the CiviCRM log files? (Beyond what is noted above)
Answers.UserDisplayName: Kevin Cristiano
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-20T14:06:38.050Z
Answers.Text: Tried that.  Ran clean up caches as well.  Didn't fix it. Add this to the mix,  I go to the membership dashboard and can pull up a list of all my current memberships.  I can view and edit each one.  I have 673 memberships.  When I get to 601-650 the second to the last page and try to go next to the last page it blows up.  These 673 are all current the last ones are the oldest, from mid May of this year.
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-20T15:10:48.967Z
Answers.Text: Let me add that the dashboard shows I have 659 current members yet when I click on all current members (659), I get:                                      672 Results  
  Membership Status In Current, 3, Pending for Next Academic Year     along the top.  Those counts are off.
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:52:38.273Z
Answers.Text: I took a look at the membership table and I have 12 memberships listed current that shouldn't be.  I have manually set the status id on these to 4 (Expired).  Now my dashboard shows the right number and I can scroll to the end without a problem.  I can view and edit any membership from here as well.  I still cannot get to membership tab from the contact screen.
Answers.UserDisplayName: Donald Knapp
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-20T13:40:41.163Z
Answers.LastActivityDate: 2016-09-20T13:50:43.313Z
Answers.LastEditDate: 2016-09-20T13:50:43.313Z
Answers.UserDisplayName: Kevin Cristiano
Body: <p>Recently upgraded to civicrm 4.7.11 
  On joomla 3.6.2  php 5.6.23  mysql 5.6.29</p>
  
  <p>I have just noticed when I click memberships Civicrm throws a unable to reach the server. Please refresh this page in your browser and try again.  </p>
  
  <p>I am able to click on contributions activities and events.</p>
  
  <p>When I turn on logging and look at the log I'm getting in CRM_Core_Error::handleUnhandledException(Object(CiviCRM_API3_Exception))</p>
  
  <p>["error_message"]=>
        string(41) "Expected one PaymentProcessor but found 0"
        ["error_code"]=></p>
  
  <p>I have two payment processors setup. One that I have had for some time and another I just created after this issue. They each have a row for the production and test. Only think I can think of is the payment processor id field starts at 7.</p>
  
  <p>I haven't seen anything else on this.  Must be something specific on my site.
  We have been running civicrm joomla 5 years now.   </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-20T13:37:50.103Z
Comments.Text: please try to look for detailed error message in civicrm log file - if not look for any php error - that might help you
Comments.UserDisplayName: Ramesh - ARTECH Consultancy
Tags: <civimember><joomla><error>
Title: Clicking Membership on View Contact Throws Error won't display page
ThreadText: # Clicking Membership on View Contact Throws Error won't display page
  
  (Asked by: username_0 on 2016-09-20)
  
  Recently upgraded to civicrm 4.7.11
  On joomla 3.6.2 php 5.6.23 mysql 5.6.29
  
  I have just noticed when I click memberships Civicrm throws a unable to reach the server. Please refresh this page in your browser and try again.
  
  I am able to click on contributions activities and events.
  
  When I turn on logging and look at the log I'm getting in CRM\_Core\_Error::handleUnhandledException(Object(CiviCRM\_API3\_Exception))
  
  ["error\_message"]=>
  string(41) "Expected one PaymentProcessor but found 0"
  ["error\_code"]=>
  
  I have two payment processors setup. One that I have had for some time and another I just created after this issue. They each have a row for the production and test. Only think I can think of is the payment processor id field starts at 7.
  
  I haven't seen anything else on this. Must be something specific on my site.
  We have been running civicrm joomla 5 years now.
  
  **Tags:** civimember, joomla, error
  
  > **Comments:**
  > **username_1**: please try to look for detailed error message in civicrm log file - if not look for any php error - that might help you  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-09-21. Score: 2
  
  Donald, Could you help us with
  
  1. From which version of CiviCRM did you upgrade to 4.7.11?
  2. Are you using any payment processor extension like iAts, etc?
  3. Could you check in db if you get 0 results by running the query below
  
     `SELECT ccr.payment_processor_id FROM civicrm_contribution_recur ccr
     LEFT JOIN civicrm_payment_processor cpp ON cpp.id = ccr.payment_processor_id
     WHERE cpp.id IS NULL
     GROUP BY ccr.payment_processor_id`
  4. Could you also paste the result of below query?
  
     `SELECT cr.payment_processor_id as ppID1, cp.payment_processor as ppID2
     FROM civicrm_membership mem
     INNER JOIN civicrm_membership_payment mp ON ( mem.id = mp.membership_id )
     INNER JOIN civicrm_contribution con ON ( mp.contribution_id = con.id )
     LEFT JOIN civicrm_contribution_recur cr ON ( mem.contribution_recur_id = cr.id )
     LEFT JOIN civicrm_contribution_page cp ON ( con.contribution_page_id = cp.id )`
  
  Thanks
  Pradeep
  
  > **Comments:**
  > **username_0**: 1) Was on previous version 4.7.10.  Upgrade and database upgrade completed without incident.  2) Using no payment processor extensions just what comes with civicrm we have been on paypal standard.  I am separately having issues with the IPN coming back but not updating the status of memberships.  I mention this but don't have reason to believe it is related. 3. MySQL returned an empty result set (i.e. zero rows).  4.  I get 4509 total rows either NULL NULL, NULL 3, or NULL 7.  Can't paste that many rows, happy to send other way. Pls advise  
  > **username_2**: Can paste result for    1. Select payment_processor_id FROM civicrm_contribution_recur GROUP BY payment_processor_id;  
  > **username_2**: And also for  Select payment_processor_id FROM civicrm_contribution_page;  Check if you see payment_processor_id that are not equal to civicrm_payment_processor.id  
  > **username_0**: Select payment_processor_id FROM civicrm_contribution_recur GROUP BY payment_processor_id;   Returned an empty result set (i.e. zero rows). (Query took 0.0016 seconds.)  
  > **username_0**: Select payment_processor FROM civicrm_contribution_page Returned  NULL NULL NULL 3 3 3 3 3 7  
  > **username_2**: So you have id 3 and 7 present in civicrm_payment_processor?  
  > **username_2**: Let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/45710/discussion-between-pradeep-nayak-and-donald-knapp).  
  
  ---
  
  ### Answer by username_3 on 2016-09-20. Score: 1
  
  I would check to see which Payment Processors are enabled on the Membership form. In Manage Contributions you will find the Membership one, look at the Amounts Tab (even though it's grayed out) and be sure a valid Payment processor is checked.
  
  > **Comments:**
  > **username_0**: On the Manage Contribution Page I have checked the Amounts tab.  The payment processor is checked.  Note this contribution page was set up months ago.  I am currently just inquiring on a membership by clicking memberships from View Contacts when this blows up.  
  > **username_3**: I am.   I did this from memory :)   Fixed the answer.   If that does not do it - I'd create a new processor (even test) and switch to that for testing.  I have had times were the payment processor was the problem.   I don't have a joomla install to test on.   Do you get any error mesages in the CiviCRM log files? (Beyond what is noted above)  
  > **username_0**: Tried that.  Ran clean up caches as well.  Didn't fix it. Add this to the mix,  I go to the membership dashboard and can pull up a list of all my current memberships.  I can view and edit each one.  I have 673 memberships.  When I get to 601-650 the second to the last page and try to go next to the last page it blows up.  These 673 are all current the last ones are the oldest, from mid May of this year.  
  > **username_0**: Let me add that the dashboard shows I have 659 current members yet when I click on all current members (659), I get:                                      672 Results   Membership Status In Current, 3, Pending for Next Academic Year     along the top.  Those counts are off.  
  > **username_0**: I took a look at the membership table and I have 12 memberships listed current that shouldn't be.  I have manually set the status id on these to 4 (Expired).  Now my dashboard shows the right number and I can scroll to the end without a problem.  I can view and edit any membership from here as well.  I still cannot get to membership tab from the contact screen.  
  
  ---
  
  