[Koha-bugs] [Bug 23093] New: Error during upgrade of OpacNavRight preference to Koha news

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23093

            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 at lists.koha-community.org
          Reporter: oleonard at myacpl.org
        QA Contact: testopia at bugs.koha-community.org
                CC: testopia at 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=d.createElement(s);js.id=id;js.src=p+'
at line 1 [for Statement "INSERT INTO opac_news (branchcode, lang, title,
content ) VALUES (NULL, 'OpacNavRight_en', '', '            <a
class="twitter-timeline"  href="https://twitter.com/ETFLibrary"
data-widget-id="702160486524186624">Tweets by @ETFLibrary</a>
            <script>!function(d,s,id){var
js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+"://platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
          ')"] 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=22318
[Bug 22318] Extend Koha news feature to include other content areas
-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.