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
--
Mailing list: https://launchpad.net/~banking-addons-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~banking-addons-team
More help : https://help.launchpad.net/ListHelp
