MyQueues For Agents - Wont Save

Moderator: crythias

Locked
MWMeads
Znuny newbie
Posts: 24
Joined: 09 Mar 2012, 22:27
Znuny Version: 31000
Real Name: Tim
Company: Mountain West Telephone

MyQueues For Agents - Wont Save

Post by MWMeads »

So when I go into an agent account, I select the queue, save it, and come back and no queues are selected. When I sign into the user, it shows me tickets that aren't in any of the queues I had selected.

I checked the error logs, and nothing in there points to being crazy.

What to do?
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: MyQueues For Agents - Wont Save

Post by crythias »

check also apache logs.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
MWMeads
Znuny newbie
Posts: 24
Joined: 09 Mar 2012, 22:27
Znuny Version: 31000
Real Name: Tim
Company: Mountain West Telephone

Re: MyQueues For Agents - Wont Save

Post by MWMeads »

Checked the apache logs too. It lets me know that the agent has been updated successfully but thats it. I am really unsure why it wouldn't update.
MWMeads
Znuny newbie
Posts: 24
Joined: 09 Mar 2012, 22:27
Znuny Version: 31000
Real Name: Tim
Company: Mountain West Telephone

Re: MyQueues For Agents - Wont Save

Post by MWMeads »

Wow....this is really an issue. I can't get the agents to see the tickets they need to see. This is damn near a deal breaker for me.
CSL
Znuny expert
Posts: 159
Joined: 11 Nov 2011, 19:27
Znuny Version: 3.0.11

Re: MyQueues For Agents - Wont Save

Post by CSL »

This data is held within the 'personal_queues' table in the OTRS database. It has two columns - user_id for the ID of the user account, and queue_id for the ID of the queue.

This should be updated when you select an additional queue in your my queues in your preferences. What I'd do to make sure this is working is first of all perform a select that shows you what your current personal queues are in the database:

Code: Select all

SELECT * FROM `otrs`.`personal_queues`
WHERE user_id = <your user id>
You can find your user id in the users table of the database. Once you've got this list, go into your preferences and select another queue, then click update. Run the command again, and you show now see an additional line for the new queue.
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
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: MyQueues For Agents - Wont Save

Post by crythias »

Also make sure your database isn't corrupt.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked