(SOLVED) Company tickets are not working

Moderator: crythias

Locked
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

(SOLVED) Company tickets are not working

Post by bayerex »

Hi all,

Since moving to 3.2.7 I haven't been able to get company tickets working. My two test accounts have the same customer_ID but cannot access each other's tickets.

I have created a customer company - although I don't think this has anything to do with it. I'm pretty sure this is for adding drop customer_ID dropdown values but we enter our IDs manually anyway.

Both accounts can see the "Company Tickets" button but clicking on it makes no difference. Searching via ticket no. also finds nothing so they somehow have no access to each other's tickets.

I just want all customers with the same Customer_ID to be able to access each other's tickets. How do I do this?

Many thanks in advance.
Last edited by bayerex on 24 Sep 2013, 11:18, edited 1 time in total.
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Company tickets are not working

Post by jojo »

do you use customer group support? And the tickets are in queues with different groups?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

Re: Company tickets are not working

Post by bayerex »

jojo wrote:do you use customer group support? And the tickets are in queues with different groups?
Yes, CustomerGroupSupport is already enabled. "Standard Queues" is one of the CustomerGroupAlwaysGroups. This is confirmed to me when I open 'customer1' in AdminCustomerUserGroup as this group is listed as a standard group and not as an available group to select.

"Queue1" contains two new tickets created by 'customer1' and 'customer2' created themselves via the webinterface. Both customers have the same company ID. But they are only able to see their own ticket.

Selecting either of these views produces the exact ticket list results. No difference:
customer.pl?Action=CustomerTicketOverview;Subaction=CompanyTickets
customer.pl?Action=CustomerTicketOverview;Subaction=MyTickets
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Company tickets are not working

Post by crythias »

changing CustomerID is not retroactive to existing tickets. Use Generic Agent to update.
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
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

Re: Company tickets are not working

Post by bayerex »

crythias wrote:changing CustomerID is not retroactive to existing tickets. Use Generic Agent to update.
That's true, I understand that. But these are two new tickets created for the purposes of troubleshooting this problem. Since 'customer1' and 'customer2' have always had the same CustomerID since creation of these two tickets I assume this should give them access to both tickets via Company Tickets.
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Company tickets are not working

Post by crythias »

check case and spelling. Customer Company support would enable dropdown choice of customerID.
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
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

Re: Company tickets are not working

Post by bayerex »

crythias wrote:check case and spelling. Customer Company support would enable dropdown choice of customerID.
Spelling etc is all correct. I need this resolved pretty soon. Please contact me with your hourly rate if you would like to resolve this on a Freelancer basis.
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
bayerex
Znuny expert
Posts: 164
Joined: 03 Dec 2012, 00:30
Znuny Version: 3.2.7

Re: Company tickets are not working

Post by bayerex »

in the end our developer was able to spot an error he had made to the file.

<<< change:
System/CustomerUser/DB.pm:455

should be:
sub CustomerIDs {
my ( $Self, %Param ) = @_;
return $Self->CustomerIDList(%Param);
}
Current Production Server (recently switched from Windows)
OTRS 3.2.7 on Ubuntu 12.04LTS 64bit
PHP 5.3.10-1ubuntu3.6
mysql Ver 14.14 Distrib 5.5.31

Previous Production Server:
Windows 2008
MySQL 5.1.51 Community Server
Strawberry Perl 5.12.3.0
Locked