# Upgrade 7.9 to 8.1 syntax error

**URL:** <https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 15, 2023, 1:27am UTC](https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905 "2023-11-15T01:27:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jamshidzade](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jamshidzade/32/24927_2.png) [@jamshidzade](https://forum.inductiveautomation.com/u/jamshidzade)\
**Post date:** [November 15, 2023, 1:27am UTC](https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905/1 "2023-11-15T01:27:29Z")

</div>

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

 ![cems-DATABASE](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/8/28672acf3e38eec3ebbdbdbe2ffcc6fcd4387842.jpeg)  
 ![script-issue2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/3/d392847bba68ae07179a0363e9504f9436a219c5.jpeg)

---

<div class="post-metadata">

**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\
**Post date:** [November 15, 2023, 2:42am UTC](https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905/2 "2023-11-15T02:42:32Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/1/b1bb50b7cfa61d8d4beab3872299278a8f95659d.jpeg)

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).

---

<div class="post-metadata">

**Author:** ![jamshidzade](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jamshidzade/32/24927_2.png) [@jamshidzade](https://forum.inductiveautomation.com/u/jamshidzade)\
**Post date:** [November 15, 2023, 3:20pm UTC](https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905/3 "2023-11-15T15:20:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 15, 2023, 4:05pm UTC](https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905/4 "2023-11-15T16:05:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jamshidzade](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jamshidzade/32/24927_2.png) [@jamshidzade](https://forum.inductiveautomation.com/u/jamshidzade)\
**Post date:** [November 15, 2023, 6:15pm UTC](https://forum.inductiveautomation.com/t/upgrade-7-9-to-8-1-syntax-error/81905/5 "2023-11-15T18:15:19Z")

</div>

Ok I will go support Thanks