SQL Error when report has image

Questions related to nuBuilder Forte Reports and the Report Builder.

SQL Error when report has image

Postby BoydG » Sat Feb 09, 2019 4:09 am

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====
BoydG
 
Posts: 15
Joined: Mon Dec 31, 2018 7:01 pm

Re: SQL Error when report has image

Postby kev1n » Sat Feb 09, 2019 6:23 pm

No issues here when I follow the steps in this video:
https://www.youtube.com/watch?v=8t79JmO1pIc
kev1n
 
Posts: 125
Joined: Mon Oct 15, 2018 2:13 am

Re: SQL Error when report has image

Postby BoydG » Sun Feb 10, 2019 4:57 am

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===========
BoydG
 
Posts: 15
Joined: Mon Dec 31, 2018 7:01 pm

Re: SQL Error when report has image

Postby admin » Sun Feb 10, 2019 9:41 am

BoydG,

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


Steven
admin
Site Admin
 
Posts: 3035
Joined: Mon Jun 15, 2009 9:53 am

Re: SQL Error when report has image

Postby BoydG » Thu Feb 21, 2019 6:00 am

Works great in new release
BoydG
 
Posts: 15
Joined: Mon Dec 31, 2018 7:01 pm

Re: SQL Error when report has image

Postby admin » Thu Feb 21, 2019 6:49 am

Cool!
admin
Site Admin
 
Posts: 3035
Joined: Mon Jun 15, 2009 9:53 am


Return to Reports



cron