[otrs] Stats error on postgres

Hello, I've see a post on forums about this error : ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target list This append when using 1.3.2 version on postgres Database. This is the SQL code that offense Pg : SELECT DISTINCT(th.ticket_id) FROM ticket_history th WHERE th.

[otrs] Queue Ticket Count

Hello: First let me apologize if this is a basic question: I just started at a new position, and one of my responsibilities is administering OTRS (version 1.2.2). Our main queue is currently displaying a ticket count as follows: Tickets Available: 56 All Tickets: 45 This is a discrepancy

[otrs] otrs error after login after initial install

I just installed otrs, from cvs on a FreeBSD 4.10 with apache 1.3.27 and mod_perl 1.29_1   I went through all the docs, and everything worked like it should, ran the installer it completed without a hitch Went to the login screen which came up fine, and logged in with the initial user/pa

Re: [otrs] Default Tech

Thanks so much for your comments. I appreciate the amazing work done on OTRS so my odd requests are really a reflection of my very strange needs and not a "flaw" in OTRS design. I am trying to make OTRS do things it was not intended to do in a way that poses more problems than it solves so it is

[otrs] Size of Session Data

Hi, running otrs 1.3.1 pretty well i wondered about an _huge_ amount of messages like the one at the bottom in my error.log. Can anybody tell me where to extend the Max. size of SessionData ? Or is there another way to avoid this ? I added the following Lines in my Config.pm, trying to avoid th

RE: [otrs] error OTRS-PM-10

Tyler and Markus, Just a thank you for your advice regarding the e-mail attachment issue I was having. I bumped up both the mySQL and OTRS attachment settings, and my bouncing e-mail issue is resolved. There are several people here who are very happy not to get a reoccurring ticket in their inb

[otrs] Can't call method "png"

I'm upgrading from 1.2 to 1.3 but I got some problem with the new stats the system is new is Gentoo Apache 2 mod_perl mod_php fastcgi GD 2.16 GD::Graph 1.43   When I try to make a statistic in format graph (but also bargraph etc.) I get Can't call method "png" on an undefined value at /opt/

[otrs] Re: Customer User Backend, Auth Backend and Customer Users

Hi all, I have send this mail to the user mailling list but I think it's a "bug" so I reply my comment into the dev mailling list :) For people who are not on the user mailling list I leave the entire original mail. On Mon, 8 Nov 2004 17:20:55 +0100, Yann Richard <[EMAIL PROTECTED]> wrote: > Hi a

Re: [otrs] Default Tech

[EMAIL PROTECTED] schrieb: 1. I needed to create duplicate "preferred" queues for each of my existing queues since my queues are based on area (cities). (That a lot of queues.) You needed one queue per "preferred area", and eventually a Generic Agent to automatically shove unlocked tickets o

Re: [otrs] Editing customer details from ticket zoom

Hello Rob, I 've understood the method (at least ;-)), but it doesn't really solve my problem. Several users got the same CustomerID as they shall be members of a company (by the way: thanx for this hint). When I follow your advice, the CustomerID is put in the opening search field, but when I c

[otrs] Software Error Forwarding ticket

Hello, I'm using OTRS 1.3.2 - got this recurring error when trying to forward a ticket to an external address: - Software error: Wide character in subroutine entry at path_to_otrs/bin/cgi-bin/../../Kernel/cpan-lib/MIME/Decoder/Base64.pm line 125. - The error only occurs for a particular ticket