Page MenuHomePhabricator

CiviCRM regular upgrade
Closed, ResolvedPublic

Description

The CiviCRM code going to rc on 5 July (yours) has fixes in it relevant to T309349 so we want to get it out to get on top of that one.

Note the specific fix is that the currency as of now renders differently for (eg. ) CAD for someone with a preferred language of Canadian English vs US English. This means what is seen in the preview screen may differ from what is received. After the update the preview screen will be an accurate reflection

Note the standardised rendering in English United States is per below. The last option adds the iso code for USD only - where it would otherwise be deemed implicit by the php currency library because the language is en_US

CurrencyTemplate codedisplays
CAD{$amount}$CA 50.00
USD{$amount}$50.00
CAD{$amount} {$currency}$CA 50.00 CAD
CAD{$amount} {$currency}$50.00 USD
CAD{$amount} {if $currency ==='USD}{$currency}(/if}$CA 50.00
CAD{$amount} {if $currency ==='USD}{$currency}(/if}$50.00 USD

Event Timeline

Change 935525 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] [WIP] Upgrade CiviCRM to 5.64rc

https://gerrit.wikimedia.org/r/935525

Change 935525 abandoned by Eileen:

[wikimedia/fundraising/crm@master] [WIP] Upgrade CiviCRM to 5.64rc

Reason:

https://gerrit.wikimedia.org/r/935525

Change 935803 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Add a match to the translations

https://gerrit.wikimedia.org/r/935803

Change 935803 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Add a match to the translations

https://gerrit.wikimedia.org/r/935803

@Jgreen to your question regarding triggers & if they need to be loaded when I do the update

  1. there are no new fields that need triggers added urgently & could not be picked up when we re-do the segment triggers
  2. the table civicrm_action_mapping table is being dropped as it is unused. This could cause problems if the triggers are there but you could remove then in the next day or so before the upgrade
  3. the field 'post_URL' is being renamed to 'post_url' in the civicrm_uf_group table (ditto cancel_URL). I don't know how that will play - it might be fine but we also don't use that table much so if you dropped the triggers on it when you do 2 ^ then an updated version will come back when we do 1

Just noting I sent out an email proposing this time https://www.timeanddate.com/worldclock/meetingdetails.html?year=2023&month=7&day=12&hour=22&min=0&sec=0&p1=2099&p2=179&p3=176&p4=240&p5=195&p6=31&p7=136&p8=224

I haven't 100% confirmed I can do it without @Jgreen on standby yet or when @Jgreen can do - hence the tentative proposal in the email

Change 936828 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix upgrade to work around order bug

https://gerrit.wikimedia.org/r/936828

Change 936828 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix upgrade to work around order bug

https://gerrit.wikimedia.org/r/936828

Change 937554 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Updated triggers file

https://gerrit.wikimedia.org/r/937554

Change 937554 merged by Eileen:

[wikimedia/fundraising/crm@master] Updated triggers file

https://gerrit.wikimedia.org/r/937554

Change 937564 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Fix for message preview not working in thank you email

https://gerrit.wikimedia.org/r/937564

Change 937564 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix for message preview not working in thank you email

https://gerrit.wikimedia.org/r/937564

XenoRyet set Final Story Points to 4.