Syntax errors on rule for notifying IT on ticket submissions.
I am working to get our HelpDesk email notifications working. Two weeks ago, it was working because I was testing something else and the notification emails were being sent. I disabled them (without editing the SQL in the rule itself) through the queue email settings. Now, for some reason when I am trying to actually get the email notifications sent, I am getting syntax errors. So I do not understand what would have changed in just a couple of weeks. I am the only person working on it at this time, so I know no one else has made any changes to the rule. I did change a few field labels in KACE in one queue but not in the other. Both queues are showing the same syntax errors. This was also written before I joined the team. I am still relatively new to KACE so I may just not know the proper names of the tables and columns.
We have KACE 8.0.318. I believe that when this was installed (before my hire) it was 8.0 so our system did not expereince the name change in teh database that caused issued for others when updated to 7.0. (https://support.quest.com/kb/218437) (https://support.quest.com/kace-systems-management-appliance/kb/223753) I have checked the manual and preformed several searches on the IT Ninja boards. I have yet to find anything that breaks through my lack of understanding the cause of the error.
Here are the lines of SQL in question:
/* complete history*/ JOIN
HD_TICKET_CHANGE H ON H.HD_TICKET_ID = HD_TICKET.ID
/* priority ********/ JOIN HD_PRIORITY P
/* status **********/ JOIN HD_STATUS S ON
/* impact-severity */ JOIN HD_IMPACT I ON
/* category ********/ JOIN HD_CATEGORY CAT
/* owner ***********/ LEFT JOIN USER OWNER
ON OWNER.ID = HD_TICKET.OWNER_ID
/* submitter *******/ LEFT JOIN USER
SUBMITTER ON SUBMITTER.ID = HD_TICKET.SUBMITTER_ID
/* updater *********/ LEFT JOIN USER
UPDATER ON UPDATER.ID = C.USER_ID
I know for a fact that the first two are giving me the error message because I deleted the first line and ran it only to get a similar syntax error message on the second one. Instead of trying them all, I would like for some more experienced eyes to see if they can find what I am missing.
Here is the error message for the complete join history statement.
syntax errors in your query.
mysqli error: [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 ' /* complete history*/ JOIN
HD_TICKET_CHANGE H ON H.HD_TICKET_ID' at line 41]
There are no answers at this time