Hello all,
We have a running 3.1.4 OTRs on an ubuntu machine (Ubuntu 10.04.4 LTS).
I was playing around in it and tried to insert some queues into the DB (MySQL) using the insert statement that I got from the mysql log file when creating a new queue from the web interface.
The script ran fined, without errors, and the queues appeared in the web interface. Everything fine for the next 2 queues. But when trying to add a fourth one it didn't show up in the web interface. The same thing for the following 5 queues.
If I open an already existing queue (in the web interface) and edit the QueueID in the link to the queue id in the DB it opens and I see my queue. If I click then on the Submit button ALL of my queues show up in the web interface, including the ones that didn't show up after I ran the script in the DB.
Why is that ? If I want to create queues programmaticaly what do I need to do extra ? What am I missing ?
Any help would be great.
Thank you in advance.
Sorin M.
Create autommaticaly queues
Moderator: crythias
Re: Create autommaticaly queues
Hi Sorin,
I would guess that this is the interface cache showing you an older version of the pages before you added the new queues. Try running /opt/otrs/bin/otrs.DeleteCache.pl and then restarting your webserver.
I've seen this problem happen with some agents (that were added through the web interface, not scripts) and I've yet to get to the bottom of it (I can search for an agent to find them, but they are not in the agent list). There may be something odd going on here so if refreshing the cache doesn't help, then more investigation may be needed. Capturing all of the SQL queries ran by the interface when bringing up the list would be a good start. You can then use something like MySQL workbench to run them one at a time to see where it may be going wrong (pretty tedious, but will show you exactly what is going on).
I would guess that this is the interface cache showing you an older version of the pages before you added the new queues. Try running /opt/otrs/bin/otrs.DeleteCache.pl and then restarting your webserver.
I've seen this problem happen with some agents (that were added through the web interface, not scripts) and I've yet to get to the bottom of it (I can search for an agent to find them, but they are not in the agent list). There may be something odd going on here so if refreshing the cache doesn't help, then more investigation may be needed. Capturing all of the SQL queries ran by the interface when bringing up the list would be a good start. You can then use something like MySQL workbench to run them one at a time to see where it may be going wrong (pretty tedious, but will show you exactly what is going on).
Backend: OTRS 3.0.11 RedHat Enterprise Linux 6.2, Apache, MySQL with replication
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
Re: Create autommaticaly queues
Hi CSL,
Thank you for the quick reply.
Running the otrs.DeleteCache.pl script right after the insert command fixed the problem. The newly created queue shows up in the list. This works without restarting the webserver.
So thank you again for the help.
regards,
Sorin M.
Thank you for the quick reply.
Running the otrs.DeleteCache.pl script right after the insert command fixed the problem. The newly created queue shows up in the list. This works without restarting the webserver.
So thank you again for the help.
regards,
Sorin M.