[Koha-bugs] [Bug 23390] Add placeholder syntax for column names

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

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

--- Comment #3 from Nick Clemens <nick at 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.