Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

SQL Error when report has image

Questions related to nuBuilder Forte Reports and the Report Builder.
Post Reply
BoydG
Posts: 35
Joined: Mon Dec 31, 2018 10:31 am

SQL Error when report has image

Unread post 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====
kev1n
nuBuilder Team
Posts: 4294
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 444 times
Contact:

Re: SQL Error when report has image

Unread post by kev1n »

No issues here when I follow the steps in this video:
https://www.youtube.com/watch?v=8t79JmO1pIc
BoydG
Posts: 35
Joined: Mon Dec 31, 2018 10:31 am

Re: SQL Error when report has image

Unread post 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===========
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: SQL Error when report has image

Unread post by admin »

BoydG,

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


Steven
BoydG
Posts: 35
Joined: Mon Dec 31, 2018 10:31 am

Re: SQL Error when report has image

Unread post by BoydG »

Works great in new release
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: SQL Error when report has image

Unread post by admin »

Cool!
Post Reply