update to OTRS 3.1.11 TicketFilter Breaks!

Moderator: crythias

Post Reply
rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

update to OTRS 3.1.11 TicketFilter Breaks!

Post by rey90 »

Hello

i have updateded to OTRS 3.1.11 today.
After that the Ticket Status Filter is broken.
All Tickets are shown as open once. But State is "Closed successfull"

Any Ideas?
Thanks

Rey90
Last edited by rey90 on 05 Nov 2012, 12:00, edited 4 times in total.
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by rey90 »

did nobody have the same problem?
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

jojo
Moderator
Posts: 14644
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by jojo »

which filter?
"Production": 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 :: Share your ideas

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by rey90 »

Tickets -> View Status
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

jojo
Moderator
Posts: 14644
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by jojo »

works for me. Check your sysconfig settings
"Production": 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 :: Share your ideas

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by rey90 »

could you please give me a hint were to search for this problem?

BTW: The Database is the same. i haven´t changed anything there, only the files while updating.. are you sure the Sysconfig is the problem?
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

jojo
Moderator
Posts: 14644
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by jojo »

something went wrong on your system. As the files for this are not touched I assume somebody changed the filters
"Production": 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 :: Share your ideas

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: update to OTRS 3.1.11 TicketFilter Breaks

Post by rey90 »

i have copied the dir to the new Version, changed nothing!

rebuild config
delete cache

Same problem
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: update to OTRS 3.1.11 TicketFilter Breaks!

Post by rey90 »

SOLVED!:

NEVER DELETE CACHE FILES!!!
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

crythias
Moderator
Posts: 10110
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: [SOLVED]update to OTRS 3.1.11 TicketFilter Breaks!

Post by crythias »

I wouldn't go that far. If the cache has something that the system doesn't, that's not good. You should always be able to delete cache.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: [SOLVED]update to OTRS 3.1.11 TicketFilter Breaks!

Post by rey90 »

any hint for me to solve this cache problem?
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

crythias
Moderator
Posts: 10110
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: [SOLVED]update to OTRS 3.1.11 TicketFilter Breaks!

Post by crythias »

rey90 wrote:any hint for me to solve this cache problem?
Not really. Like I said, if deleting the cache causes this issue, you may have another issue with the database ... maybe you changed names of state types or states. I didn't really follow the problem close enough with your issue to determine the cause, as out of the box it should just work.

My question is whether or not the numbers properly update with the cache issue.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: [SOLVED]update to OTRS 3.1.11 TicketFilter Breaks!

Post by rey90 »

are you sure it is a database problem?
You are right i have changed the prioritiy names...
and state typs are only 2 allowed
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

crythias
Moderator
Posts: 10110
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: [SOLVED]update to OTRS 3.1.11 TicketFilter Breaks!

Post by crythias »

rey90 wrote:are you sure it is a database problem?
Am I sure? No.

Priorities shouldn't matter to Tickets->View Status

You may want to check to make sure you're not looking at closed tickets in View Status.
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: [SOLVED]update to OTRS 3.1.11 TicketFilter Breaks!

Post by rey90 »

The Cronjob yesterday to delete the cache has now du the same...

All Tickets are in the View Open
this is the url to the view:
index.pl?Action=AgentTicketStatusView
;SortBy=Age;
OrderBy=Down;
View=;
Filter=Open;
Session=104ebf1cd89c0802613b9621c5bac9ca4e

Looks OK for me... but do not shows only the open ones :(

Why are those informations taken from the cache an not drom the DB to have actual values...

Any solution for me? uninstall OTRS. Install OTRS 3.1.11? But what should i do if the problem is there again.. ?

EDIT: DB isn´t the problem... I have used a new / originall one.
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

crythias
Moderator
Posts: 10110
Joined: 04 May 2010, 18:38
OTRS Version?: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: update to OTRS 3.1.11 TicketFilter Breaks!

Post by crythias »

I'm not sure I understand completely what you are encountering.
rey90 wrote:All Tickets are shown as open once. But State is "Closed successfull"
rey90 wrote:Looks OK for me... but do not shows only the open ones

Why are those informations taken from the cache an not drom the DB to have actual values...
These are the only statements that indicate what you are encountering. Screen shots? What is working? What is not?
OTRS 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
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

rey90
OTRS expert
Posts: 70
Joined: 16 Aug 2012, 15:56
OTRS Version?: 4.0.10

Re: update to OTRS 3.1.11 TicketFilter Breaks!

Post by rey90 »

you are right is is very complicate to explain a screenshout will be easier.
sry my fault.

see attached!
You do not have the required permissions to view the files attached to this post.
Produktiv: OTRS: 4.0.10
Testing": OTRS: 5
OS: Debian 7
Apache2/MySQL 5

ferrosti
OTRS ninja
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: update to OTRS 3.1.11 TicketFilter Breaks!

Post by ferrosti »

In your case I would revert to the original states and change the translation file instead. In there you are able to insert your own wording without having to change these parameters, which are quite essential.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems

Post Reply