This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "main Koha release repository".

The branch, 19.11.x has been updated
       via  026316d5515621aa3a096850754d2fae5b6f01dc (commit)
       via  b70d602694ae45ec059f7b1d2763534c3f0a66c4 (commit)
       via  7c8e7bd18004e17a854433a0a1fcacabaf18d248 (commit)
       via  6a9cc05a0a046ba7535e7258e563fb8ec16d9ee3 (commit)
       via  3ff1ddc4b926b7c0dce6a66833ac7b85cf36ac41 (commit)
       via  af2146e565d5eb7c2ad95b744706f9a0c147af50 (commit)
      from  8cd87230b188d6677b58d222049919dcd9467401 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 026316d5515621aa3a096850754d2fae5b6f01dc
Author: Aleisha Amohia <[email protected]>
Date:   Tue Nov 17 17:56:18 2020 +1300

    Bug 18050: DBRev 19.11.11.002
    
    Signed-off-by: Aleisha Amohia <[email protected]>

commit b70d602694ae45ec059f7b1d2763534c3f0a66c4
Author: Katrin Fischer <[email protected]>
Date:   Mon Oct 5 06:17:34 2020 +0000

    Bug 18050: (QA follow-up) Adjust conditions and make use of message text
    
    - When we run into invalid data, we use Augustin's suggested solution
      and copy the data into a separate table, setting the budget_period_id to
      NULL.
    - We amend the output using the new $message.
    
    Signed-off-by: Katrin Fischer <[email protected]>
    
    Signed-off-by: Jonathan Druart <[email protected]>
    (cherry picked from commit 3c8bef50a223e70fe3023222f5f940a2b1771b5d)
    
    Signed-off-by: Lucas Gass <[email protected]>
    (cherry picked from commit a88f367c63a2d649625fe367fa64ce3c888638ab)
    
    Signed-off-by: Aleisha Amohia <[email protected]>

commit 7c8e7bd18004e17a854433a0a1fcacabaf18d248
Author: Agustin Moyano <[email protected]>
Date:   Fri Oct 9 15:14:26 2020 -0300

    Bug 18050: (follow-up) Force adding FK constraint
    
    When there are inconsistent budget_period_id in aqbudgets this patch
    creates the table _bug_18050_aqbudgets with the original data, then sets
    the column to null and warns the user that there is inconsistent data.
    
    Signed-off-by: Katrin Fischer <[email protected]>
    
    Signed-off-by: Jonathan Druart <[email protected]>
    (cherry picked from commit 1193dddd8beb4a10a78e385b221c0f908d92dcf6)
    
    Signed-off-by: Lucas Gass <[email protected]>
    (cherry picked from commit 5fc0d24ca8c58407e4461142054cb67a4aec5a00)
    
    Signed-off-by: Aleisha Amohia <[email protected]>

commit 6a9cc05a0a046ba7535e7258e563fb8ec16d9ee3
Author: Katrin Fischer <[email protected]>
Date:   Sun Sep 13 23:31:52 2020 +0000

    Bug 18050: Add relation alias to schema
    
    Signed-off-by: Martin Renvoize <[email protected]>
    
    Signed-off-by: Jonathan Druart <[email protected]>
    (cherry picked from commit 2800b53bdd6df1e87f72673bc79ed4896f4e4e35)
    
    Signed-off-by: Lucas Gass <[email protected]>
    (cherry picked from commit 9999d88169db3bd51d30b489d762a615c1872f7f)
    
    Signed-off-by: Aleisha Amohia <[email protected]>

commit 3ff1ddc4b926b7c0dce6a66833ac7b85cf36ac41
Author: Aleisha Amohia <[email protected]>
Date:   Tue Nov 17 17:51:14 2020 +1300

    Bug 18050: DBIC
    
    Signed-off-by: Aleisha Amohia <[email protected]>

commit af2146e565d5eb7c2ad95b744706f9a0c147af50
Author: Katrin Fischer <[email protected]>
Date:   Sun Sep 13 22:42:27 2020 +0000

    Bug 18050: Add FK constraint on aqbudgets.budget_period_id
    
    This adds a FK constraint on aqbudgets.budget_period_id so that
    a fund cannot be added with an invalid aqbudget.budget_period_id.
    
    We should not have funds that belong to no budget. In case we have, the
    update will be skipped and a note displayed.
    
    Part1:
    - Before applying the patch
    - Make sure you have a budget with some funds linked to it
    - You will have to change one of the funds to link to an invalid
      budget with SQL:
      UPDATE aqbudgets SET budget_period_id = 999 WHERE budget_id = 
max(budget_id);
    - Apply patch
    - Run updatedatabase - verify that you see the hint about 1 existing fund 
with invalid budget.
    - Repair your fund with SQL
      UPDATE aqbudgets SET budget_period_id = ... WHERE budget_id = 
max(budget_id);
      (... needs to be your existing budget_period_id)
    - Run updatedatabase again - verify it runs successfully now.
    - If you try to change the budget_period_id to a non-existing now with SQL, 
you will
      get a database error. The new FK doesn't permit it.
    Part 2:
    - Start fresh with the web installer, verify there are no errors on
      creating the database tables
    
    Signed-off-by: Martin Renvoize <[email protected]>
    
    Signed-off-by: Jonathan Druart <[email protected]>
    (cherry picked from commit 0ce62b29bf5ebe30125eb4c631de11391134f109)
    
    Signed-off-by: Lucas Gass <[email protected]>
    (cherry picked from commit fee8aa2b1cf4c90c37e55d7286bafe8a8b0307de)
    
    Signed-off-by: Aleisha Amohia <[email protected]>

-----------------------------------------------------------------------

Summary of changes:
 Koha.pm                                |  2 +-
 Koha/Schema/Result/Aqbudget.pm         | 33 +++++++++++++++++++++++++---
 Koha/Schema/Result/Aqbudgetperiod.pm   | 21 ++++++++++++++++--
 installer/data/mysql/kohastructure.sql |  3 ++-
 installer/data/mysql/updatedatabase.pl | 40 ++++++++++++++++++++++++++++++++++
 5 files changed, 92 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
main Koha release repository
_______________________________________________
koha-commits mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-commits

Reply via email to