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====
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
SQL Error when report has image
-
- 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
No issues here when I follow the steps in this video:
https://www.youtube.com/watch?v=8t79JmO1pIc
https://www.youtube.com/watch?v=8t79JmO1pIc
-
- Posts: 35
- Joined: Mon Dec 31, 2018 10:31 am
Re: SQL Error when report has image
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===========
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
BoydG,
We planned to release a new version on Tuesday. But we'll look at your problem first.
Steven
We planned to release a new version on Tuesday. But we'll look at your problem first.
Steven
-
- Posts: 35
- Joined: Mon Dec 31, 2018 10:31 am