Page 1 of 1

SQL Error when report has image

Posted: Fri Feb 08, 2019 7:39 pm
by BoydG
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====

Re: SQL Error when report has image

Posted: Sat Feb 09, 2019 9:53 am
by kev1n
No issues here when I follow the steps in this video:
https://www.youtube.com/watch?v=8t79JmO1pIc

Re: SQL Error when report has image

Posted: Sat Feb 09, 2019 8:27 pm
by BoydG
It doesn't work in the WordPress Version.
I duplicated the video and still got the error

019-02-09 13:23:30 - SQL Error in <b>nuRunQuery</b>
<br>
===USER==========
===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===========

Re: SQL Error when report has image

Posted: Sun Feb 10, 2019 1:11 am
by admin
BoydG,

We planned to release a new version on Tuesday. But we'll look at your problem first.


Steven

Re: SQL Error when report has image

Posted: Wed Feb 20, 2019 9:30 pm
by BoydG
Works great in new release

Re: SQL Error when report has image

Posted: Wed Feb 20, 2019 10:19 pm
by admin
Cool!