Upgrade to and enable CiviCRM 2.1

Thanks for the update. Let me know if you need me to do something to help out. We are looking forward to getting membership notification working, and using the new de-duping tools.

Thanks for taking care of this.

There appears to be some menu caching in the CiviCRM block. From http://association.drupal.org/civicrm when I click on links in the CiviCRM menu I get directed to http://daupgrade.fkbuild.com/civicrm/admin?reset=1

Looks like we lost the list of countries in the required organization membership drop down. Right now only people in the US can buy a membership.

I've created a new Civicontribute donation page that is now replacing the old donation page. http://association.drupal.org/civicrm/contribute/transact?reset=1&id=8

I am trying to see if Drupal's URL Alias can support CiviCRM URLs: http://association.drupal.org/admin/build/path/edit/228?destination=admi...

We will probably have to watch for /donate 404s and 403s to find all the links to the previous URLs.

The country upgrade list can be updated here: http://association.drupal.org/civicrm/admin/setting/localization?reset=1

We need to export the old donation tables into CSV and re-import them as donations into CiviCRM.

Deduplication is now very speedy. http://association.drupal.org/civicrm/admin/dedupefind?reset=1&rgid=

We also need to ensure the memberships are being active updated: Can we confirm that a cron job is hitting sites/all/modules/civicrm/bin/UpdateMembershipRecord.php

Moving to active under we get all the kinks worked out.

The updatedmembershiprecord file needs to be copied to .php and the fundraising@drupal.org email needs to be set in the file. Then a cron job needs to be run.

/var/webroot/association.drupal.org/htdocs/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php.txt

We will want to confirm that emails have been sent to all expired memberships.

Cheers,
Kieran

Neil raised the issue of whether this configuration required a special domain ID. I think we might need a special CiviCRM multi-site configuration file.

The crontab for the UpdateMembershipRecord.php is currently set on the drupal1 server, according to Gerhard.

1st try: $ sudo ./UpdateMembershipRecord.php
./UpdateMembershipRecord.php: line 1: ?php: No such file or directory
./UpdateMembershipRecord.php: line 3: /50_mailman.conf: Permission denied
./UpdateMembershipRecord.php: line 4: +--------------------------------------------------------------------+: command not found
[09:50] ./UpdateMembershipRecord.php: line 5: syntax error near unexpected token `|'
./UpdateMembershipRecord.php: line 5: ` | CiviCRM version 2.1 |'
2nd: $ sudo php UpdateMembershipRecord.php
Warning: require_once(CRM/Core/Config.php): failed to open stream: No such file or directory in /var/webroot/association.drupal.org/htdocs/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php on line 38
Fatal error: require_once(): Failed opening required 'CRM/Core/Config.php' (include_path='.:/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm:/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages:.:/usr/share/php5:/usr/share/php') in /var/webroot/association.drupal.org/htdocs/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php on line 38
3rd: $ sudo php bin/UpdateMembershipRecord.php
Warning: require_once(../civicrm.config.php): failed to open stream: No such file or directory in /var/webroot/association.drupal.org/htdocs/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php on line 37
Fatal error: require_once(): Failed opening required '../civicrm.config.php' (include_path='.:/usr/share/php5:/usr/share/php') in /var/webroot/association.drupal.org/htdocs/sites/all/modules/civicrm/bin/UpdateMembershipRecord.php on line 37

Installation documentation here: http://wiki.civicrm.org/confluence/display/CRMDOC/Install+2.1+for+Drupal...

Based on the way that CiviCRM is installed in the main Drupal modules directory I do not believe we need to configure settings_location.php as defined here: http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+for+Drupal+-+C...

Looks like we need to run this from the web. e.g. Curl or wget http://association.drupal.org/sites/all/modules/civicrm/bin/UpdateMember...&pass=
&key='

Directions are here: http://wiki.civicrm.org/confluence/display/CRMDOC/Command-line+Script+Co...

In the settings file we need to have a defined CIVICRM_SITE_KEY. e.g. define( 'CIVICRM_SITE_KEY', '3cx4aNkpQwxmM1hTMV~!B09iO6' );

Add the key privately to the cron job or share it with me so we can test it is working.

That is all done and the cron job works, but is still disabled. The "monster" query is still around, but its not what is killing the system. The fact that there is a PHP timeout while civi is doing its processing is killing the system. This timeout happens, but civicrm queries are still showing up in the processlist....then cron fires against in about 20 minutes and we get another duplicate set of these large queries...then in 20 minutes....etc..etc..etc. I could be wrong about this, but it seems like what is happening just from my view of the process-list.

Lock maybe?

Could you post the query that keeps timing out?

Could we get an encrypted version of the CiviCRM 2.1 to Lobo?

Just got this error:

backTrace

/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 969
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1587
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 144
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 862
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Contact/BAO/GroupContactCache.php, executeQuery, 157
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, remove, 567
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/api/v2/Contact.php, deleteContact, 179
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Contact/Form/Merge.php, civicrm_contact_delete, 381
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 114
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 169
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315
, civicrm_invoke,
/var/www/association.drupal.org/htdocs/includes/menu.inc, call_user_func_array, 348
/var/www/association.drupal.org/htdocs/index.php, menu_execute_active_handler, 18

In the body

Sorry. A non-recoverable error has occurred.

DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

Database Error Code: Deadlock found when trying to get lock; try restarting transaction, 1213

Return to home page.

Error Details:

Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => a515ac9c2796ca0e23adbe92c68fc9fc
[message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
[mode] => 16
[debug_info] =>
DELETE g
FROM civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
[nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
[type] => DB_Error
[user_info] =>
DELETE g
FROM civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
[nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]
[to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="
DELETE g
FROM civicrm_group_contact_cache g
INNER JOIN civicrm_contact c ON c.id = g.contact_id
[nativecode=1213 ** Deadlock found when trying to get lock; try restarting transaction]"]
)

I just checked CiviMember. I am currently showing ~190 memberships with end dates in the past as new or current. My understanding is that if the cron job was running correctly these memberships would change status from new or current to grace or expired.

David confirmed the script is running successfully. I've got the URL for running the membership updates. The membership status is still not updating, we are going to need more advanced CiviCRM help to debug why membership status is not being updated.

please send me the encrypted db (lobo at civicrm). we'll investigate and figure out whats happening etc

lobo

David-

What cron job did you re-enable and where? The last time I ran the cron job I got a PHP timeout.

-N

Talked on IRC: Cron is enabled now....I'll be watching it :)

We needed to move a copy of CiviCRM to another DB to run the encryption.

We are getting reports of problems with the organization name not saving in user profiles and not updating in the membership directory. We will need a review of those mappings.

Reported error upon purchase of membership.

I was trying to pay my membership dues and on http://association.drupal.org/civicrm/contribute/transact was faced with:

backTrace

/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1039
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, insert, 279
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/MembershipLog.php, save, 56
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, add, 1242
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, fixMembershipStatusBeforeRenew, 1029
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, renewMembership, 941
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php, postProcessMembership, 463
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315
, civicrm_invoke,
/var/www/association.drupal.org/htdocs/includes/menu.inc, call_user_func_array, 348
/var/www/association.drupal.org/htdocs/index.php, menu_execute_active_handler, 18

and

Sorry. A non-recoverable error has occurred.

DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE), 1452

and

Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_membership_log (membership_id , start_date , end_date , modified_id , modified_date , renewal_reminder_date ) VALUES ( 180 , 20071112 , 20081111 , 990 , 20090210 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_membership_log (membership_id , start_date , end_date , modified_id , modified_date , renewal_reminder_date ) VALUES ( 180 , 20071112 , 20081111 , 990 , 20090210 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_membership_log (membership_id , start_date , end_date , modified_id , modified_date , renewal_reminder_date ) VALUES ( 180 , 20071112 , 20081111 , 990 , 20090210 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]"]
)

I've been trying to renew my individual membership with the association and am running into problems. Amazon asked if I would document my steps.

Steps that I'm taking.

1) Log in
2) Click on Memberships Tab
3) Click "Buy for 22 Euros"
4) My form is pre-filled
5) I click "Continue" and am on the verification page
6) I click "Continue"

where I see at the top:

backTrace

/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1039
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, insert, 279
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/MembershipLog.php, save, 56
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, add, 1242
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, fixMembershipStatusBeforeRenew, 1029
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, renewMembership, 941
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php, postProcessMembership, 463
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
/var/www/association.drupal.org/htdocs/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315
, civicrm_invoke,
/var/www/association.drupal.org/htdocs/includes/menu.inc, call_user_func_array, 348
/var/www/association.drupal.org/htdocs/index.php, menu_execute_active_handler, 18

an error message:

Sorry. A non-recoverable error has occurred.

DB Error: constraint violation

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE), 1452

and finally below the error message:

Error Details:

Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_membership_log (membership_id , start_date , end_date , modified_id , modified_date , renewal_reminder_date ) VALUES ( 180 , 20071112 , 20081111 , 990 , 20090216 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_membership_log (membership_id , start_date , end_date , modified_id , modified_date , renewal_reminder_date ) VALUES ( 180 , 20071112 , 20081111 , 990 , 20090216 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_membership_log (membership_id , start_date , end_date , modified_id , modified_date , renewal_reminder_date ) VALUES ( 180 , 20071112 , 20081111 , 990 , 20090216 , NULL ) [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`association_civicrm/civicrm_membership_log`, CONSTRAINT `FK_civicrm_membership_log_status_id` FOREIGN KEY (`status_id`) REFERENCES `civicrm_membership_status` (`id`) ON DELETE CASCADE)]"]
)

Something isn't configured correctly with memberships after the conversion. I decided while I was in CiviCRM, to go ahead and renew my individual membership a little early this year.

It had my individual membership recorded good through September 2009, but after paying, I have only a single membership record that starts today and ends in a year, and lists me as status New - the previous start date is gone and my extension should be through September, not February.

Matthew's contact record is: http://association.drupal.org/civicrm/contact/view?reset=1&cid=990

There's several incomplete transactions on both the 10th and 16th of February.
February 16th, 2009
Contribution Status Pending : Incomplete Transaction

Kieran

Has anyone touched CiviCRM on d6-association.drupal.org lately? I logged in today to find the entire civicrm directory to be gone, which caused quite a bit of breakage :). I've done an SVN up, but now CiviCRM is complaining about a missing settings file. Since it's not in SVN, can someone copy it from sites/association.drupal.org from the live site to sites/d6-association.drupal.org on scratchvm?

I'd like to test out CiviCRM 2.1.6 to see if it solves any of the various issues in the queue.

I tried logging into: http://d6-association.drupal.org/drupal-association?destination=drupal-a...

Error: Could not create directory: /var/www/association.drupal.org.

If you have moved your database from a development install to a production install and the directory paths are different, please set the column config_backend in the civicrm_domain table to NULL. You will need to reinitialize your settings in the production install.

Kieran

First, I visited admin/build/modules page and saved it.
After visiting http://d6-association.drupal.org/civicrm/admin/setting/url and saving the page the menu's now pointed to the same instance.

Thank-you.

Marking as fixed.