https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23390 --- Comment #3 from Nick Clemens <nick@bywatersolutions.com> --- (In reply to George Williams (NEKLS) from comment #2)
Tested on ByWater sandbox. I got this error message when I got to step 10:
The following error was encountered: The database returned the following error: 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 '[[cardnumber|library_barcode]] AS library_barcode FROM borrowers WHERE cardnumbe' at line 1 Please check the log for further details. Return to previous page
I left the sandbox up - it's just called "sandbox" - if you want to take a look.
I restarted the services on the sandbox and edited the report from: SELECT [[cardnumber|library_barcode]] AS library_barcode FROM borrowers WHERE cardnumber LIKE '%9' To: SELECT [[cardnumber|library_barcode]] FROM borrowers WHERE cardnumber LIKE '%9' and all appears to work now :-) -- You are receiving this mail because: You are watching all bug changes.