Migration from 5.2 to 5.4

Should

  • [SQL] replace account_payment_sepa_message from TEXT to BYTEA:

     ALTER TABLE "account_payment_sepa_message" ALTER COLUMN "message" TYPE BYTEA USING message::BYTEA;
    

:arrow_forward: Migration from 5.4 to 5.6

1 Like

Hello,

another important thing to be aware when upgrading to 5.4 or newer is that when you use multiple currencies, you have to add an initial rate of “1” for your main currency. Use a date that predates the start of your accounting.

This requirement arises from this commit that dropped the default rate set via XML template:
https://hg.tryton.org/modules/currency/rev/e83a477968ca

It was part of this issue:

Thanks to pokoli who explained this to me on #tryton in IRC.

This is documented here:
https://docs.tryton.org/projects/modules-currency/en/latest/usage.html#setting-currency-exchange-rates