Bug 33714

Summary: Enabling advanced editor causes 500 error
Product: Koha Reporter: National Library of Jamaica <kohasupport>
Component: CatalogingAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: critical    
Priority: P5 - low CC: m.de.rooy
Version: 21.05   
Hardware: All   
OS: Windows   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description National Library of Jamaica 2023-05-10 16:59:51 UTC
Good day. I am using Koha version 21.05 and 21.11 on local and offsite servers respectively. When I try to enable the Advanced Editor for the catalog, I get a 500 error which also affects the standard editor when it's enabled. Any help would be appreciated. Thank you. P.S- no updates were done on the system. Do I need to change something on the server? We run Apache on ubuntu. Thanks again.
Comment 1 Katrin Fischer 2023-05-14 11:58:23 UTC
Hi, there was a bug fixing a similar issue. Please check your exact version to see if the fix is already included in your installation or not:

Bug 33375 - Advanced editor crashes when using MySQL 8 due to reserved rank keyword 
See: Version(s) released in at the top section of the bug
Comment 2 Katrin Fischer 2023-05-14 11:59:15 UTC
Hm, I realize if it's this bug, it will be neither fixed in 21.05 nor 21.11. 
Can you confirm if you are using MySQL8?
Comment 3 Katrin Fischer 2023-05-17 16:04:30 UTC

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