[MOD] Auto Assigned Ticket

[underpope]

I've installed this mod and the two additional mods that are required for this one to work, and I continue to receive this DB error when submitting a ticket:

SELECT staff_id FROM ost_help_topic_auto_assign WHERE dept_id= AND topic_id=

which looks like it's being thrown in topicautoassign.inc.php; it seems the values of $dept_id and $topic_id are not being passed.

Any thoughts on how to approach this one?

[valentin.marzac]

gettiinh the same errors

[masino_sinaga]

@valentin.marzac,
@underpope,
@eddieburroughs,

Please re-apply this mod especially the step number 5 and 7. I have found the causes, it seems there are some lines of code that are missing. Now they have already there. Sorry for the inconveniences.

Sincerely,
Masino Sinaga
P.S.: That mod also works fine in 1.6 ST as I have just tested it a few minutes ago.

[gulatinaveen]

@ Masino

Hey,

will this MOD work on v1.6ST as well??

Regards
Naveen

[ZeroEffect]

Originally Posted by masino_sinaga

@valentin.marzac,
@underpope,
@eddieburroughs,

Please re-apply this mod especially the step number 5 and 7. I have found the causes, it seems there are some lines of code that are missing. Now they have already there. Sorry for the inconveniences.

Sincerely,
Masino Sinaga
P.S.: That mod also works fine in 1.6 ST as I have just tested it a few minutes ago.

I have just installed this MOD using the link above. and I am receiving the following error messages.

[SELECT topic_id, topic FROM ost_help_topic WHERE topic_id=]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[SELECT staff_id, firstname, lastname FROM ost_staff WHERE dept_id =  ORDER BY staff_id]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY staff_id' at line 1

[SELECT dept_id,dept_name FROM ost_department WHERE dept_id=]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This is happening when I try to apply the selected user.

I am going to go through the steps again.

Thanks for your help

ZeroEffect

[ZeroEffect]

I am using version 1.6ST It looks like this issue is when the data is read from the data base. The table that the help topics are listed in is not correct.

Still hunting this down.

Thanks

ZeroEffect

[ZeroEffect]

Originally Posted by ZeroEffect

I have just installed this MOD using the link above. and I am receiving the following error messages.

[SELECT topic_id, topic FROM ost_help_topic WHERE topic_id=]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[SELECT staff_id, firstname, lastname FROM ost_staff WHERE dept_id =  ORDER BY staff_id]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY staff_id' at line 1

[SELECT dept_id,dept_name FROM ost_department WHERE dept_id=]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This is happening when I try to apply the selected user.

I am going to go through the steps again.

Thanks for your help

ZeroEffect

Ok I have found the problem but don't know how to fix it. Using myphpadmin I ran the above command and got the same message. I ran it again adding a department ID.

SELECT dept_id,dept_name FROM ost_department WHERE dept_id='Engineering'

and it worked perfectly. Looks like the problem is the variable for the "WHERE" statement is empty. I'm trying to locate how to fix that.

[stacehamilton]

Does anyone have this working fully? I have performed the mod as well as the two prerequisite mods numerous times and still have trouble. Would love to have this capability. thank you.

[ZeroEffect]

Originally Posted by stacehamilton

Does anyone have this working fully? I have performed the mod as well as the two prerequisite mods numerous times and still have trouble. Would love to have this capability. thank you.

Currently this does work for me but I get three emails every time I setup an auto assign or when someone submits a ticket. Telling me about the errors I mentioned above. I'll be able to move forward once this is resolved.

ZeroEffect

[ZeroEffect]

*****Update*****
I noticed that I did not do the help topic mod. I followed the steps of the help topic mod and now the auto assign does not work. Side note I could not complete step 2 of the help topic mod. The lines I was asked to change are not in that document. (OST1.6ST) I have gone back and removed the help topic mod and still auto assign is not working. Rolling back to the setup I had before the auto assign mod and try again.

Out of all the MOD this is the one I wanted the most. I hope this can be resolved.

ZeroEffect