banking-addons-team team mailing list archive
-
banking-addons-team team
-
Mailing list archive
-
Message #00021
Re: banking_addons: Upgrade to 6.1
I've noticed a change in the structure of the
'account_bank_statement_line_move_rel' record in my 6.0 to 6.1 upgraded
databases. I wonder if someone could confirm this:
6.0 Structure
Column | Type | Modifiers
--------------+---------+-----------
move_id | integer | not null
statement_id | integer | not null
6.1 Structure
Column | Type | Modifiers
-------------------+---------+-----------
statement_line_id | integer | not null
move_id | integer | not null
Notice the order of the field has changed and their names. This is
causing an error in the bank statement when clicking the 'Confirm'
button. I've fixed the error by changing the database structure using a
couple of alter table statements:
alter table account_bank_statement_line_move_rel rename column move_id
to statement_line_id;
alter table account_bank_statement_line_move_rel rename column
statement_id to move_id;
Are there any other changes like this lurking in the database?
James
Follow ups
References
-
Re: banking_addons: Upgrade to 6.1
From: Stefan Rijnhart, 2012-02-16
-
Re: banking_addons: Upgrade to 6.1
From: James Jesudason, 2012-02-16
-
Re: banking_addons: Upgrade to 6.1
From: James Jesudason, 2012-02-16
-
Re: banking_addons: Upgrade to 6.1
From: Stefan Rijnhart, 2012-02-16
-
Re: banking_addons: Upgrade to 6.1
From: James Jesudason, 2012-02-16
-
Re: banking_addons: Upgrade to 6.1
From: Stefan Rijnhart, 2012-02-16
-
Re: banking_addons: Upgrade to 6.1
From: James Jesudason, 2012-02-17
-
Re: banking_addons: Upgrade to 6.1
From: Stefan Rijnhart, 2012-02-17
-
Re: banking_addons: Upgrade to 6.1
From: James Jesudason, 2012-02-17
-
Re: banking_addons: Upgrade to 6.1
From: Stefan Rijnhart, 2012-02-18
-
Re: banking_addons: Upgrade to 6.1
From: Stefan Rijnhart, 2012-03-06