From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 14:39:45 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] New: Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 12:39:41 +0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============6653654841785367993==" --===============6653654841785367993== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3D23093 Bug ID: 23093 Summary: Error during upgrade of OpacNavRight preference to Koha news Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: oleonard@myacpl.org QA Contact: testopia@bugs.koha-community.org CC: testopia@bugs.koha-community.org Depends on: 22318 Target Milestone: --- Copied from Bug 22318: Moving the contents of OpacNavRight to opac_news fails due to improper (no?) escaping: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'http':'https';if(!d.getElementById(id)){js=3Dd.createElement(s);js.id=3Did;j= s.src=3Dp+' at line 1 [for Statement "INSERT INTO opac_news (branchcode, lang, title, content ) VALUES (NULL, 'OpacNavRight_en', '', ' Tweets by @ETFLibrary ')"] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 18220. In this example, OpacNavRight contains a script to embed a Twitter timeline. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3D22318 [Bug 22318] Extend Koha news feature to include other content areas --=20 You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============6653654841785367993==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 14:40:36 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 12:40:30 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2820618451775024616==" --===============2820618451775024616== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Bug 23093 depends on bug 22318, which changed state. Bug 22318 Summary: Extend Koha news feature to include other content areas https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22318 What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============2820618451775024616==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 16:15:10 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 14:14:40 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7152519608914954205==" --===============7152519608914954205== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Jonathan Druart changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |jonathan.druart@bugs.koha-c |ity.org |ommunity.org CC| |jonathan.druart@bugs.koha-c | |ommunity.org Status|NEW |ASSIGNED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. --===============7152519608914954205==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 16:29:19 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 14:28:49 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7910348354955201749==" --===============7910348354955201749== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Jonathan Druart changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. --===============7910348354955201749==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 16:29:23 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 14:28:52 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1264200750052912184==" --===============1264200750052912184== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3D23093 --- Comment #1 from Jonathan Druart = --- Created attachment 90494 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3D90494&action=3D= edit Bug 23093: (bug 22318 follow-up) Use placeholders in query moving OpacNavRight Placeholders must be used (!) in all SQL queries. Test plan: 1/ % git checkout 0c95e22afe13349b60d134217fce6718bfa9727f # commit before bug 22318 2/ Edit the pref OpacNavRight with something with " just a " and more ' 3/ git checkout master 4/ restart_all 5/ run updatedatabase.pl =3D> Boom and the content of the pref has been lost 6/ Repeat 1 to 3 7/ Apply this patch 8/ run updatedatabase.pl =3D> The pref has been correctly moved to opac_news --=20 You are receiving this mail because: You are watching all bug changes. --===============1264200750052912184==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 16:32:46 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 14:32:44 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4782484732730390868==" --===============4782484732730390868== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Jonathan Druart changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|major |critical -- You are receiving this mail because: You are watching all bug changes. --===============4782484732730390868==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 16:59:48 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 14:59:18 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4501218887654556547==" --===============4501218887654556547== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 M. Tompsett changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. --===============4501218887654556547==-- From bugzilla-daemon@bugs.koha-community.org Tue Jun 11 16:59:52 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Tue, 11 Jun 2019 14:59:21 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1929789689975604909==" --===============1929789689975604909== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 M. Tompsett changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #90494|0 |1 is obsolete| | --- Comment #2 from M. Tompsett --- Created attachment 90500 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=90500&action=edit Bug 23093: (bug 22318 follow-up) Use placeholders in query moving OpacNavRight Placeholders must be used (!) in all SQL queries. Test plan: 1/ % git checkout 0c95e22afe13349b60d134217fce6718bfa9727f # commit before bug 22318 2/ Edit the pref OpacNavRight with something with " just a " and more ' 3/ git checkout master 4/ restart_all 5/ run updatedatabase.pl => Boom and the content of the pref has been lost 6/ Repeat 1 to 3 7/ Apply this patch 8/ run updatedatabase.pl => The pref has been correctly moved to opac_news Signed-off-by: Mark Tompsett -- You are receiving this mail because: You are watching all bug changes. --===============1929789689975604909==-- From bugzilla-daemon@bugs.koha-community.org Wed Jun 12 15:55:48 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Wed, 12 Jun 2019 13:55:43 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2825030528060469382==" --===============2825030528060469382== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Nick Clemens changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. --===============2825030528060469382==-- From bugzilla-daemon@bugs.koha-community.org Wed Jun 12 15:55:51 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Wed, 12 Jun 2019 13:55:46 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4474407767201866400==" --===============4474407767201866400== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Nick Clemens changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #90500|0 |1 is obsolete| | --- Comment #3 from Nick Clemens --- Created attachment 90531 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=90531&action=edit Bug 23093: (bug 22318 follow-up) Use placeholders in query moving OpacNavRight Placeholders must be used (!) in all SQL queries. Test plan: 1/ % git checkout 0c95e22afe13349b60d134217fce6718bfa9727f # commit before bug 22318 2/ Edit the pref OpacNavRight with something with " just a " and more ' 3/ git checkout master 4/ restart_all 5/ run updatedatabase.pl => Boom and the content of the pref has been lost 6/ Repeat 1 to 3 7/ Apply this patch 8/ run updatedatabase.pl => The pref has been correctly moved to opac_news Signed-off-by: Mark Tompsett Signed-off-by: Nick Clemens -- You are receiving this mail because: You are watching all bug changes. --===============4474407767201866400==-- From bugzilla-daemon@bugs.koha-community.org Wed Jun 12 15:56:56 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Wed, 12 Jun 2019 13:56:26 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7620101141224022209==" --===============7620101141224022209== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Nick Clemens changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nick@bywatersolutions.com QA Contact|testopia@bugs.koha-communit |nick@bywatersolutions.com |y.org | -- You are receiving this mail because: You are watching all bug changes. --===============7620101141224022209==-- From bugzilla-daemon@bugs.koha-community.org Thu Jun 13 13:08:17 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Thu, 13 Jun 2019 11:07:43 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============7236541308100145955==" --===============7236541308100145955== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Martin Renvoize changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master Version(s)| |19.11.00 released in| | -- You are receiving this mail because: You are watching all bug changes. --===============7236541308100145955==-- From bugzilla-daemon@bugs.koha-community.org Thu Jun 13 13:08:17 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Thu, 13 Jun 2019 11:07:45 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1247004031643629486==" --===============1247004031643629486== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 --- Comment #4 from Martin Renvoize --- Nice work! Pushed to master for 19.11.00 -- You are receiving this mail because: You are watching all bug changes. --===============1247004031643629486==-- From bugzilla-daemon@bugs.koha-community.org Mon Jun 17 09:50:48 2019 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] Error during upgrade of OpacNavRight preference to Koha news Date: Mon, 17 Jun 2019 07:50:45 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============4370193181503578257==" --===============4370193181503578257== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 Fridolin SOMERS changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |Pushed to Stable CC| |fridolin.somers@biblibre.co | |m Version(s)|19.11.00 |19.11.00,19.05.01 released in| | --- Comment #5 from Fridolin SOMERS --- Pushed to 19.05.x for 19.05.01 -- You are receiving this mail because: You are watching all bug changes. --===============4370193181503578257==-- From bugzilla-daemon@bugs.koha-community.org Thu Apr 9 05:21:14 2026 From: bugzilla-daemon@bugs.koha-community.org To: koha-bugs@lists.koha-community.org Subject: [Koha-bugs] [Bug 23093] [CVE-2022-0495] Error during upgrade of OpacNavRight preference to Koha news Date: Thu, 09 Apr 2026 03:21:14 +0000 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3470181247230915458==" --===============3470181247230915458== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093 David Cook changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au Summary|Error during upgrade of |[CVE-2022-0495] Error |OpacNavRight preference to |during upgrade of |Koha news |OpacNavRight preference to | |Koha news --- Comment #6 from David Cook --- CVE-2022-0495 doesn't provide much info but it looks like it could be around the right time although the CVE would have a slightly wrong version number. -- You are receiving this mail because: You are watching all bug changes. --===============3470181247230915458==--