[Koha-bugs] [Bug 24488] Holds to Pull sometimes shows the wrong 'first patron' details

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

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

Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |martin.renvoize at ptfs-europe
                   |                            |.com

--- Comment #9 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
To summarise.. try setting `<strict_sql_modes>1</strict_sql_modes>` in your
koha-conf.xml Aleisha.. it's on by default in sandboxes and dev environments to
weed out queries that would fail we strict features enabled at the SQL level.

Looking at the error Kelly is reporting it sounds like strict SQL is enabled
and she's catching an error in your reworked SQL query that you're not seeing
with sql in 'forgiving' mode ;).

I've not looked at the code yet, but this usually arrises from a group by on a
query with a join where you're trying to group by an id field in on table.. the
fix, as horrible as it is, is to add all fields in that table to the group by.

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