[otrs] Default Item in Queue View

2007-02-07 Thread Dan Mahoney, System Admin
Hello, I notice that on some tickets, when in queue view, I view the customer's original request, but on others (like internally generated email tickets), I view the last internal note (for example, on a queue change). Is there any way to get consistency here? Specifically, I would like to e

RE: Database pruning (was: RE: [otrs] Ticket history table full error)

2007-02-07 Thread Maurice James Ny
How many tickets do you have? _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason B. Loven Sent: Wednesday, February 07, 2007 11:19 AM To: User questions and discussions about OTRS.org Subject: Database pruning (was: RE: [otrs] Ticket history table full error) OK

Database pruning (was: RE: [otrs] Ticket history table full error)

2007-02-07 Thread Jason B. Loven
OK... I bit the bullet and did the max_rows change and all seems well. Next question: Is there a way to prune the database or to archive history out of the database to get things down in size? My history file is currently at 4GB after about a year of usage and I'd like to prune that down or at

[otrs] DB.pm line 223 Error

2007-02-07 Thread Petar Kazakov
I got this strange error from every cron-job that I run. I upgrade my OTRS from 2.1.1 to 2.1.5, using the source. I just extract the new files over the old folder. The error is this DBI::db=HASH(0x8a7d130)->disconnect invalidates 1 active statement handle (either destroy statement handles

[otrs] Help me on Generic agent

2007-02-07 Thread Ramziddin Artykov
Hi list I have selected the 10 min time option in the Generic Agent Job's settings it should check every ten minutes the definite queue and if he finds the owner is [EMAIL PROTECTED] it should change it should change it to the appropriate owner (F.Y.I every time the customer opens a ticket the in

[otrs] Ticket history table full error

2007-02-07 Thread Jason B. Loven
Anyone know how to fix this? We're running 2.0.4 and I saw this showing up in the cron logs. I've disabled cron for now but obviously that's bad because now we're having to manually handle the incoming mail queue for our support. Here's the error... DBD::mysql::db do failed: The table 'tick

R: [otrs] OTRS and MS SQL Server

2007-02-07 Thread COSTA Dave - Lievitalia S.p.A.
Do you please have a working Config.pm? Thank you Dave Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Piergiovanni Gualotto Inviato: martedì 6 febbraio 2007 17.04 A: User questions and discussions about OTRS.org Oggetto: Re: [otrs] OTRS and MS S