July 2019 - Koha-bugs - lists.koha-community.org

[Bug 11815] convert BorrowersTitles to an authorised value
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11815 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com Depends on| |20307 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20307 [Bug 20307] Language overlay for authorized values -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15664] koha-restore: Allow database dump to be restored to another Koha instance
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15664 --- Comment #7 from Rudolf Byker <rudolfbyker(a)gmail.com> --- Sorry, you also need this function: function drop_db { DB="$1" echo "Dropping $DB …" mysql -u "$MYSQL_USER" -p"$MYSQL_PASS" -e "DROP DATABASE IF EXISTS $DB;" } -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15664] koha-restore: Allow database dump to be restored to another Koha instance
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15664 --- Comment #6 from Rudolf Byker <rudolfbyker(a)gmail.com> --- Another option is to use sed to replace the USE and CREATE DATABASE commands using regular expressions. This can be done using pipes, without creating a new dump. I wrote this bash function a while ago, which imports a gzipped Koha sql-dump. The first argument is the name of the database you want to create, and the second argument is the file name to import from. function import_db { DB="$1" F="$2" # Change the database names when importing. REPLACE1="s/^CREATE DATABASE.*/CREATE DATABASE ${DB};/" REPLACE2='s/USE `koha_rsc`;/USE `'"${DB}"'`;/' # Can't import if it exists, so drop it. drop_db "$DB" echo "Importing database $DB from $F …" zcat "${F}" | sed "${REPLACE1}; ${REPLACE2}" | mysql -u "$MYSQL_USER" -p"$MYSQL_PASS" } -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12949] changing child to adult doesn't remove link to guarantor
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12949 Nick Clemens <nick(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick(a)bywatersolutions.com Status|Signed Off |Failed QA --- Comment #4 from Nick Clemens <nick(a)bywatersolutions.com> --- Hi Alex, A few comments: 1 - New preferences should be defaulted to 'off' - i.e. user should have to activate the behavior change 2 - This pref does not prevent entering unlinked information, it only blocks display. I think if we are not going to show it, maybe we shouldn't let the user enter it? 3 - I don't think this tackles the problem as reported, we should remove the contactname and contactfirstname if removing the guarantor id. The doesn't have to be handled here, but if it isn't then we should open a new bug for the original report -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11573] Fine descriptions related to Rentals are untranslatable
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11573 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |19919 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19919 [Bug 19919] Writing off a Lost Item Fee marks as "Paid for by patron" -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14825] Accounts Rewrite Omnibus
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14825 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on|19919 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19919 [Bug 19919] Writing off a Lost Item Fee marks as "Paid for by patron" -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15664] koha-restore: Allow database dump to be restored to another Koha instance
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15664 Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=23346 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15664] koha-restore: Allow database dump to be restored to another Koha instance
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15664 --- Comment #5 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- Bug 23346 does the first part of the job. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15664] koha-restore: Allow database dump to be restored to another Koha instance
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15664 --- Comment #4 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- diff without.sql with.sql 18a19,26 > -- Current Database: `koha_master` > -- > > CREATE DATABASE /*!32312 IF NOT EXISTS*/ `koha_master` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; > > USE `koha_master`; > > -- 6743c6751 < -- Dump completed on 2019-07-19 10:20:42 --- > -- Dump completed on 2019-07-19 10:16:49 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 15664] koha-restore: Allow database dump to be restored to another Koha instance
by bugzilla-daemon＠bugs.koha-community.org 19 Jul '19

19 Jul '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15664 --- Comment #3 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- (In reply to Marcel de Rooy from comment #2) > Problem is the hardcoded database name in the sql dump coming from the > --databases parameter of mysqldump. > We could make this an option ? And it would need passing the instance name to mysql in koha-restore. -- You are receiving this mail because: You are watching all bug changes.

1 0