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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Member status is not updated
Pages: [1]

Author Topic: Member status is not updated  (Read 773 times)

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Member status is not updated
May 30, 2011, 08:55:20 am
I have a member whose membership is expired. Its 'end date' is may 20 2010. Now today I opened his record to edit his membership and enter a payment there through 'Record Membership Payment'. That worked allright, the payment is at the bottom of the Membership page.
After that I ran the UpdateMembershipRecord-script. That also completed without complaining, however the members' status is still 'expired'. I expected it to switch to 'current'.  Where did I go wrong?

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Member status is not updated
June 01, 2011, 01:59:05 am
Am I right in expecting a status change here
and would anyone have a suggestion how to analyse this further?

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Member status is not updated
June 01, 2011, 03:19:14 am
I have enabled the Drupal Watchdog and ran the script again. The watchdog now comes with a long error, it is longer than 64 so I cannot attach it, I therefore paste the first chunk of lines here, hoping it says something about my present problem.

Code: [Select]
$Ignoring exception thrown here = DB_Error Object ( [error_message_prefix] => [mode] => 16 [level] => 1024 [code] => a515ac9c2796ca0e23adbe92c68fc9fc [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc [userinfo] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation] [backtrace] => Array ( [0] => Array ( [file] => /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB.php [line] => 971 [function] => PEAR_Error [class] => PEAR_Error [type] => ->  [args] => Array ( [0] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc [1] => a515ac9c2796ca0e23adbe92c68fc9fc [2] => 16 [3] => Array ( [0] => CRM_Core_Error [1] => nullHandler ) [4] => CREATE TRIGGER civicrm_domain_trigger BEFORE INSERT ON civicrm_domain FOR EACH ROW BEGIN END [nativecode=1227 ** Access denied; you need the SUPER privilege for this operation] ) )

TheoRichel

  • I post frequently
  • ***
  • Posts: 122
  • Karma: 0
  • CiviCRM version: 4.2.1
  • CMS version: Drupal 6.24
  • MySQL version: 5.9
  • PHP version: 5.3.16
Re: Member status is not updated
June 01, 2011, 03:20:41 am
And there is also a backtrace message which follows here:
Code: [Select]
$backTrace = /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 541 , nullHandler, /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 971 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2420 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1606 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 145 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 1335 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Admin/Form/Setting/Miscellaneous.php, checkTriggerViewPermission, 57 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, buildQuickForm, 326 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 99 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 115 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 195 /home/theorichel/domains/grkmain.com/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 355 , civicrm_invoke, /home/theorichel/domains/grkmain.com/public_html/includes/menu.inc, call_user_func_array, 349 /home/theorichel/domains/grkmain.com/public_html/index.php, menu_execute_active_handler, 17

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Member status is not updated

This forum was archived on 2017-11-26.