[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 --- Comment #5 from Victor Grousset/tuxayo --- Thanks, it works :D, fr-FR is fixed. -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 --- Comment #4 from Victor Grousset/tuxayo --- Created attachment 120188 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120188&action=edit Bug 28198: Correct sample HOLD_REMINDER notice for it,nb,pl,ru It turns out that ea6467724cf8e6fac2224e1dcb6c6ddee73736af also caused the same issue in these locales Also e0b0e908f767e510c5538d8e5cfb25f994579441 (a follow up) caused the issue in it-IT == Test plan == Paste all this :D ``` # doesn't work without this patch applied echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql | sudo koha-mysql kohadev echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/pl-PL/mandatory/sample_notices.sql | sudo koha-mysql kohadev echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/ru-RU/mandatory/sample_notices.sql | sudo koha-mysql kohadev echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/it-IT/necessari/notices.sql | sudo koha-mysql kohadev # test all the rest ## fixed by previous patch, double checking echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql | sudo koha-mysql kohadev ## was already working, just double checking echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/fr-CA/obligatoire/sample_notices.sql | sudo koha-mysql kohadev echo "DELETE FROM letter;" | sudo koha-mysql kohadev cat installer/data/mysql/uk-UA/mandatory/sample_notices.sql | sudo koha-mysql kohadev ``` -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 Victor Grousset/tuxayo changed: What|Removed |Added Attachment #120183|0 |1 is obsolete|| --- Comment #3 from Victor Grousset/tuxayo --- Created attachment 120187 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120187&action=edit Bug 28198: Correct sample HOLD_REMINDER notice for French To test: 1 - sudo koha-mysql kohadev 2 - DELETE FROM letter 3 - cat installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql | sudo koha-mysql kohadev 4 - Error! 5 - Apply patch 6 - Repeat 1-3 7 - Success! Signed-off-by: Victor Grousset/tuxayo -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 --- Comment #2 from Nick Clemens --- Created attachment 120183 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120183&action=edit Bug 28198: Correct sample HOLD_REMINDER notice for French To test: 1 - sudo koha-mysql kohadev 2 - DELETE FROM letter 3 - cat installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql | sudo koha-mysql kohadev 4 - Error! 5 - Apply patch 6 - Repeat 1-3 7 - Success! -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 Nick Clemens changed: What|Removed |Added Status|ASSIGNED|Needs Signoff -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 --- Comment #1 from Victor Grousset/tuxayo --- note: workaround: remove from installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql The line: ('reserves','HOLD_REMINDER','','Waiting hold reminder',0,'You have waiting holds.','Dear [% borrower.firstname %] [% borrower.surname %],\r\n\r\nThe following holds are waiting at [% branch.branchname %]:\r\n\\r\n[% FOREACH hold IN holds %]\r\n[% hold.biblio.title %] : waiting since [% hold.waitingdate | $KohaDates %]\r\n[% END %]','email'), -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 Jonathan Druart changed: What|Removed |Added Keywords||rel_21_05_candidate Assignee|koha-b...@lists.koha-commun |n...@bywatersolutions.com |ity.org | Status|NEW |ASSIGNED CC||jonathan.dru...@bugs.koha-c ||ommunity.org -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 28198] French sample notices SQL fails: Column count doesn't match value count
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28198 Victor Grousset/tuxayo changed: What|Removed |Added Depends on||15986 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15986 [Bug 15986] Add a script for sending hold waiting reminder notices -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/