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!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
SQL Error when report has image
-
- nuBuilder Team
- Posts: 4562
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 76 times
- Been thanked: 528 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