CiviCRM Community Forums (archive)

I'm on Civi 3.1.5. I'm using it with Drupal / Ubercart / Ubercart CiviCRM integration. I want to make sure everything is working smoothly to ensure schema integrity down the road. One thing I'm concerned about is if I delete an ubercart order. I plan to write integration code to ensure that if an order gets deleted, the mirroring Civi transactions also get deleted.

When ubercart makes an order a contribution and an activity are both created in CiviCRM automatically. So when I delete an order, I will also want to delete both the activity and the contribution. First I went ahead to do this manually. I tested deleting the contribution relating to an order, but the activity stays. My questions are:

1) Shouldn't a relevant activity get deleted if its associated contribution gets deleted?

2) By deleting this contribution but not the activity, if I go to view the activity I get the Civi death error of the yellow screen and just a 'One of parameters (value: ) is not of the type Integer' message. Is this the type of thing that will eventually result in some kind of FK error when I try to upgrade someday?

3) Assuming the above is bad, I want to delete the activity, but there's no delete option (it appears) on my activity screen. So I need to delete manually in the db? Is there more than 1 table I'll need to delete from?

Thanks much,
Emily

1. I deleted via the UI. Tested on demo but could not reproduce...but demo is currently 3.2 and I'm on 3.1. I also tested with an event registration contribution and it did not delete the associated activity. However, I thought I was on 3.1.5 and I'm actually on 3.1.3. I will upgrade tonight and then check this again to see if it is resolved. I will report back.

2. Thank you.

3. Thank you.