From bugzilla-daemon@bugs.koha-community.org Fri Apr 12 08:26:26 2024
From: bugzilla-daemon@bugs.koha-community.org
To: koha-bugs@lists.koha-community.org
Subject: [Koha-bugs] [Bug 36587] New: Reserved word in mySQL prevents link to
 a purchase suggestion
Date: Fri, 12 Apr 2024 06:26:25 +0000
Message-ID: <bug-36587-70@https.bugs.koha-community.org/bugzilla3/>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4355181761541669736=="

--===============4355181761541669736==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

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

            Bug ID: 36587
           Summary: Reserved word in mySQL prevents link to a purchase
                    suggestion
 Change sponsored?: ---
           Product: Koha
           Version: 22.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Staff interface
          Assignee: koha-bugs@lists.koha-community.org
          Reporter: r.delahunty@arts.ac.uk
        QA Contact: testopia@bugs.koha-community.org
                CC: gmcharlt@gmail.com

There is no link to a specific purchase suggestion in Suggestions management =
in
the SQL Report Library. While this syntax CONCAT('<a
href=3D\"/cgi-bin/koha/suggestion/suggestion.pl?suggestionid=3D',
suggestionid,'\">', suggestionid, '</a>') copies the pattern of other links, =
it
takes the user to an upper level, where a library must be selected.

To reach a specific suggestion the url must have a 'trailing fragment' &op=3D=
show
added. Including the trailing fragment in the link statement is forbidden as
SHOW is a reserved word in mySQL.=20

If the API route were changed so that it used a different word, for example
"display" instead of "show", it would probably be possible to get around this.

--=20
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.

--===============4355181761541669736==--


From bugzilla-daemon@bugs.koha-community.org Tue Apr 16 16:21:20 2024
From: bugzilla-daemon@bugs.koha-community.org
To: koha-bugs@lists.koha-community.org
Subject: [Koha-bugs] [Bug 36587] Reserved word in mySQL prevents link to a
 purchase suggestion
Date: Tue, 16 Apr 2024 14:21:19 +0000
Message-ID: <bug-36587-70-XeMRVj4q3U@https.bugs.koha-community.org/bugzilla3/>
In-Reply-To: <bug-36587-70@https.bugs.koha-community.org/bugzilla3/>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7678134186905327579=="

--===============7678134186905327579==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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

--- Comment #1 from Ray Delahunty <r.delahunty@arts.ac.uk> ---
Further testing shows that this bug is invalid. The 'trailing frgament' is not
necessary. If the user is logged in to the **correct library** the link does
take the user directly to the suggestion and not to the upper level where the
library needsto be selected.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.

--===============7678134186905327579==--


From bugzilla-daemon@bugs.koha-community.org Tue Apr 16 16:21:52 2024
From: bugzilla-daemon@bugs.koha-community.org
To: koha-bugs@lists.koha-community.org
Subject: [Koha-bugs] [Bug 36587] Reserved word in mySQL prevents link to a
 purchase suggestion
Date: Tue, 16 Apr 2024 14:21:51 +0000
Message-ID: <bug-36587-70-DMrV13zuro@https.bugs.koha-community.org/bugzilla3/>
In-Reply-To: <bug-36587-70@https.bugs.koha-community.org/bugzilla3/>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7818256613396713957=="

--===============7818256613396713957==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

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

Ray Delahunty <r.delahunty@arts.ac.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INVALID
             Status|NEW                         |RESOLVED

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.

--===============7818256613396713957==--