Upgrade 7.9 to 8.1 syntax error

Ignition
1

after upgrading to 8.1 from 7.9 i got a lot of syntax error would you please help me

cems-DATABASE
cems-DATABASE1148×414 52.5 KB

script-issue2
script-issue21219×626 68.7 KB

2

The error looks like it is related to a different (albeit similar) query. I'd focus on this area of your error:

image
image1170×200 40.3 KB

It looks like you're substituting a value into your query and generating a syntax error. That said, consider restructuring this to use a Named Query and proper parameterization to prevent SQL Injection (re: your Root Container.Filter Group.Filter.text substitution).

4 Likes
3

Thanks for the reply, I want to know the root cause because I have a lot of this script in the 7.9 version that works fine, why is it not working on version 8.1

4

You haven't really provided enough information for us to tell you. If you want a formal answer, then you should formally contact Support, where employees have signed NDAs and can look at your system live and figure out what's going on.

2 Likes
5

Ok I will go support Thanks