Here are tasks that are set to be completed during the q2 maintenance window.
Dates: October 30, 2023 - November 3, 2023
Asana task: https://app.asana.com/0/1125967519298615/1204682488550226/f
- T325123: Do a prune on detail data for activity records of type thank you
- T339314: Reduce the year fields for WMF donor
- T170321: encrypt fundraising database client->server communication
- T349160: endowment fiscal & calendar year totals are transposed
- T349158: Prevent future us from hating now-us - change table name
- T347353: Upgrade Fundraising puppet servers to bookworm and puppetserver 7.x
- Update tax_amount to be 0 -since we skipped during upgrade
UPDATE civicrm_contribution SET tax_amount = 0 WHERE tax_amount IS NULL; UPDATE civicrm_line_item SET tax_amount = 0 WHERE tax_amount IS NULL;
- T349107: Store Adyen ShopperReference (processor_contact_id) in new custom field
- Consider optimising tables civicrm_mailing & civicrm_mailing_event_queue - which have had significant deletions
- kernel updates and reboots
- - potential civicrm point upgrade T350208:
- Add mailing columns - see sql below
- Add new stock fields
Mailing column sql
-- around 15-20 mins ALTER TABLE civicrm_mailing_event_queue MODIFY job_id int unsigned null comment 'Mailing Job', ADD COLUMN mailing_id int(10) unsigned DEFAULT NULL COMMENT 'Related mailing. Used for reporting on mailing success, if present.', ADD CONSTRAINT FOREIGN KEY (`mailing_id`) REFERENCES `civicrm_mailing` (`id`) ON DELETE SET NULL, ADD COLUMN is_test tinyint(4) NOT NULL DEFAULT 0, DROP FOREIGN KEY FK_civicrm_mailing_event_queue_job_id; -- around 15-20 mins ALTER TABLE `civicrm_mailing_event_queue` ADD CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job`(`id`) ON DELETE SET NULL; -- around 20 mins UPDATE civicrm_mailing_event_queue q INNER JOIN civicrm_mailing_job job ON job.id = q.job_id SET q.mailing_id = job.mailing_id, q.is_test=job.is_test WHERE q.mailing_id IS NULL;