[Koha-bugs] [Bug 31859] Error 500 when enabling advanced cataloging editor

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

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

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

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

--- Comment #9 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
I believe this IS a duplicate to bug 33375:

[Tue Oct 18 14:19:17.189372 2022] [cgi:error] [pid 3532853] [client
186.102.58.32:7547] AH01215: {UNKNOWN}: DBI Exception: DBD::mysql::db
selectall_arrayref failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near ',servername'

The fix:

     WHERE recordtype != 'authority' AND servertype = 'zed'
-    ORDER BY rank,servername
+    ORDER BY `rank`,servername

*** This bug has been marked as a duplicate of bug 33375 ***

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