SQL Error when report has image
Posted: Fri Feb 08, 2019 7:39 pm
I'm trying to add an image to a report.
I uploaded the image to the file section.
Added the object as a file and selected the image.
The image doesn't show up.
Debug shows:
19-02-08 12:34:25 - SQL Error in <b>nuRunQuery</b>
===PDO MESSAGE===
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''SELECT * FROM zzzzsys_file WHERE sfi_code = ? '' at line 1
===SQL===========
===BACK TRACE====
I uploaded the image to the file section.
Added the object as a file and selected the image.
The image doesn't show up.
Debug shows:
19-02-08 12:34:25 - SQL Error in <b>nuRunQuery</b>
===PDO MESSAGE===
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''SELECT * FROM zzzzsys_file WHERE sfi_code = ? '' at line 1
===SQL===========
===BACK TRACE====