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 CiviContribute (Moderator: Donald Lobo) »
  • PayPal IPN sent, contribution record not updated
Pages: [1]

Author Topic: PayPal IPN sent, contribution record not updated  (Read 502 times)

cantusnovus

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 3.4.5
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.0.95-community
  • PHP version: 5.2.17
PayPal IPN sent, contribution record not updated
January 02, 2014, 04:33:17 am
We recently had Civihosting migrate our site for us from another host and now our contribution records no longer get updated to "completed". Paypal shows the IPN as being sent, with no errors, the log file says ""we can't load the requested web page because of an incomplete link". I contacted our host but they haven't been able to pinpoint the issue. Does anyone have any ideas? This worked fine before we migrated so I am clueless. Thanks

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: PayPal IPN sent, contribution record not updated
January 02, 2014, 05:35:29 am

are these for new contributions or recurring contributions?

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

aglozier

  • I post frequently
  • ***
  • Posts: 135
  • Karma: 9
    • Phoenix Academy
  • CiviCRM version: 4.7.9
  • CMS version: WordPress 4.6.1
  • MySQL version: 5.7.14
  • PHP version: 5.6.21
Re: PayPal IPN sent, contribution record not updated
January 09, 2014, 07:53:28 am
We switched to CiviHosting last spring.  I did the migration myself.  We use PayPal standard.  I don''t recall having any problems with IPN at that time.

I later had problems with IPN due to a bug in a new version when I upgraded.  This was fixed.

I test PayPal twhenever I make changes.  I use a test website (subdomain) and a PayPal sandbox account to do this.

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: PayPal IPN sent, contribution record not updated
January 15, 2014, 12:55:41 pm
I suggest you double check your settings for the "Notification URL" as posted on this documentation under the "Instant Payment Notification" heading.

Note that the www. or not and http: or https: matters in the URL.  Check that this is the same URL as configured in your CiviCRM settings file (civicrm.settings.php in Drupal). 
Try CiviTeacher: the online video tutorial CiviCRM learning library.

cantusnovus

  • I’m new here
  • *
  • Posts: 11
  • Karma: 0
  • CiviCRM version: 3.4.5
  • CMS version: Joomla 1.5.26
  • MySQL version: 5.0.95-community
  • PHP version: 5.2.17
Re: PayPal IPN sent, contribution record not updated
January 18, 2014, 04:12:25 am
Thanks for all the suggestions - it is for one-time contributions.

I changed the URL in PayPal to reflect what is in the settings file (which has /administrator/ after the domain), resent the IPN, and now I get this error message in the log file.

Jan 18 06:26:12  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
  • [1] => handle
            )

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_managed
 
 WHERE (  civicrm_managed.module  = 'joomla.plugin.system.admintools' ) 
 
 
 
 [nativecode=1146 ** Table 'cantusno_joomla.civicrm_managed' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_managed
 
 WHERE (  civicrm_managed.module  = 'joomla.plugin.system.admintools' ) 
 
 
 
 [nativecode=1146 ** Table 'cantusno_joomla.civicrm_managed' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_managed
 
 WHERE (  civicrm_managed.module  = 'joomla.plugin.system.admintools' ) 
 
 
 
 [nativecode=1146 ** Table 'cantusno_joomla.civicrm_managed' doesn't exist]"]
)


Jan 18 06:26:12  [info] $backTrace = #0 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(196): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB.php(968): PEAR_Error->PEAR_Error("DB Error: no such table", -18, 16, (Array:2), "SELECT * \n FROM civicrm_managed \n \n WHERE (  civicrm_managed.module  = 'jo...")
#4 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-18, 16, (Array:2), "SELECT * \n FROM civicrm_managed \n \n WHERE (  civicrm_managed.module  = 'jo...")
#5 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, -18, NULL, NULL, "SELECT * \n FROM civicrm_managed \n \n WHERE (  civicrm_managed.module  = 'jo...", "DB_Error", TRUE)
#6 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-18, NULL, NULL, NULL, "1146 ** Table 'cantusno_joomla.civicrm_managed' doesn't exist")
#7 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT * \n FROM civicrm_managed \n \n WHERE (  civicrm_managed.module  = 'jo...")
#9 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT * \n FROM civicrm_managed \n \n WHERE (  civicrm_managed.module  = 'jo...")
#10 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(441): DB_DataObject->_query("SELECT * \n FROM civicrm_managed \n \n WHERE (  civicrm_managed.module  = 'jo...")
#11 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/ManagedEntities.php(100): DB_DataObject->find()
#12 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/ManagedEntities.php(82): CRM_Core_ManagedEntities->reconcileEnabledModule(Object(CRM_Core_Module), (Array:0))
#13 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/ManagedEntities.php(68): CRM_Core_ManagedEntities->reconcileEnabledModules()
#14 /home/cantusno/www/www/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(386): CRM_Core_ManagedEntities->reconcile()
#15 /home/cantusno/www/www/plugins/system/civicrmsys/civicrmsys.php(103): CRM_Core_Invoke::rebuildMenuAndCaches(TRUE)
#16 [internal function](): plgSystemCivicrmsys->doCivicrmRebuild()
#17 {main}



Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • PayPal IPN sent, contribution record not updated

This forum was archived on 2017-11-26.