https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23390
--- Comment #3 from Nick Clemens <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
