[otrs] Ticket Ordering by Reply or Update

2009-09-15 Thread Jesse Hartel
Hey Everyone, I have a quick question. I want to have the Queueview sorted by last reply of the ticket, not the original ticket age. I ran a SQL statement of SELECT * FROM ticket st ORDER BY change_time desc and it brought up the results ordered how I want them to be. How do I implement this

[otrs] OTRS 1.2 Linux to 2.0 Debian or Windows Upgrade...

2009-07-11 Thread Jesse Shumaker
much appreciated to receive that knowledge if someone has made that move. thanks jesse - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cg

Re: [otrs] Root has lost admin permissions

2004-12-04 Thread Jesse
Thomas Earl wrote: Greetings to all, I'm working on getting OTRS config'd and I mistakenly removed root's admin permissions. How do I fix this? Thanks, Tom -- Thomas Earl Network Engineer & Designer Communications Access Center (CAC) 1631 Miller Road Flint, Michigan, 48503 248-705-7408 (cell) 8

[otrs] Can't Get to /otrs/index.pl

2004-11-30 Thread Jesse Shumaker
I recently did a fresh install of 1.3.2 and then restored my 1.2.3 database to it. Everything looked like it restored fine and I can see all the restored data within mysql but when I try to access the /otrs/index.pl page I get the error below. This prevents me from using OTRS. I didn't see anyt

Re: [otrs] Can't use MOd_perl with apache2 and otrs!

2004-11-19 Thread Jesse Shumaker
t; text anywheres in it. Thanks. --Matthew Shapiro --- Jesse Shumaker <[EMAIL PROTECTED]> wrote: Go here ==> http://lists.otrs.org/pipermail/otrs/2004-May/004919.html specifically this is helpful: "Yes, this was the main fault: I had forgotten t

Re: [otrs] Can't use MOd_perl with apache2 and otrs!

2004-11-19 Thread Jesse Shumaker
[EMAIL PROTECTED] wrote: ok I can't get otrs to wrok with mod_perl. Perl is complaining that it can't find the Apache.pm. Looking through CPAN it looks like the apache perl module is for the apache1 mod_perl but I'm using apache-2.0.52 for otrs. Furthermore, when I go into the CPAN shell and do

[otrs] How to Display Locked Tickets to non-owners?

2004-11-16 Thread Jesse Shumaker
We have three agents who oversee OTRS and all the tickets and I am curious if there is a way for us to each see all of the open tickets. Instead of only seeing the ones which are not owned by anyone or the tickets which are only owned by a particular agent. Does version 1.3.2 address this? I wo

Re: [otrs] Installing 1.3.2 and Restoring 1.2.3 DBase

2004-11-11 Thread Jesse Shumaker
Graham Smith wrote: I decided to look at this a little closer, and have come to the conclusion that a 1.2.3 install is probably not required for a move from 9.0 to 9.1. If you a) backup the database on the old server using the /opt/otrs/scripts/backup.sh script. b) Copy backup files

Re: [otrs] Linking Tickets to Knowledgebase

2004-08-11 Thread Jesse
Robert Kehl wrote: Marshall28 sagte: Are there plans to link the tickets created with the knowledgebase? This way someone can search for a ticket and what has occured on a ticket in the knowledgebase and everything is centralized. Yes, there are. Robert Kehl _

[otrs] I Can't Acces AdminArea

2004-07-18 Thread Jesse
I recently logged in today with the same user I've been logging in as that has Admin rights and I now can't see the "AdminArea" Icon. I can see FAQ, QueueView, Preferences, Stats, and a few others but no AdminArea icon. ? I went to my preferences and under the custom queues I saw that I don't have

Re: [otrs] Default FAQ Article State

2004-07-12 Thread Jesse
Alex Kelly wrote: Hello All, In our organization, the helpdesk is using the FAQ internally for all of their own documentation to help people when they call in with tickets. As such, I would like the defautlt FAQ state to be Internal. I have done a few searches and looked through the Defaults.pm

[otrs] Where do I specify Customers default theme?

2004-06-06 Thread Jesse
I want to keep the customers default theme the same as the admin/agents default theme but it's still on standard. I have the line in my Config.pm file as: $Self->{DefaultTheme} = 'BGCEV'; but this only changes it for the admin/agents. What is the string to specify this for the customers? thank

Re: [otrs] Making Customers Only able to Send tickets to certainq ueue's

2004-06-06 Thread Jesse
Tyler Hepworth wrote:   From: Jesse [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 06, 2004 6:04 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Making Customers Only able to Send tickets to certainqueue's Tyler Hepworth wrote:

Re: [otrs] Deleting Language Options

2004-06-06 Thread Jesse
Tyler Hepworth wrote:   From: Jesse [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 06, 2004 5:12 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Deleting Language Options Tyler Hepworth wrote: Jesse wrote: How do I

Re: [otrs] Making Customers Only able to Send tickets to certainq ueue's

2004-06-06 Thread Jesse
Tyler Hepworth wrote: Jesse wrote: Jeff Griffiths wrote: That's a queue permissions thing, I thought it was initially confusing as well. Just put the rest of of your queues as 'admin' with only the 'submission' queue as 'users

Re: [otrs] Deleting Language Options

2004-06-06 Thread Jesse
Robert Kehl wrote: On Sunday, June 06, 2004 9:08 AM Jesse <[EMAIL PROTECTED]> wrote: Robert Kehl wrote: On Sunday, June 06, 2004 8:34 AM Jesse <[EMAIL PROTECTED]> wrote: How do I delete languages in the FAQ section? I only want the

Re: [otrs] Deleting Language Options

2004-06-06 Thread Jesse
Tyler Hepworth wrote: Jesse wrote: How do I delete languages in the FAQ section? I only want the english one? Here is the (probably) unapproved way of doing it. There is table in the database called faq_language. It only holds four values: en, de, es, fr. Delete

[otrs] OTRS needs IRC

2004-06-06 Thread Jesse
Do you guys have an IRC channel? If so that would be a great addition for support and info on OTRS. marshall ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-

Re: [otrs] Deleting Language Options

2004-06-05 Thread Jesse
Robert Kehl wrote: On Sunday, June 06, 2004 8:34 AM Jesse <[EMAIL PROTECTED]> wrote: How do I delete languages in the FAQ section? I only want the english one? You cannot delete them. Set them to "invalid". Before you ask: you cannot delete users

Re: [otrs] Making Customers Only able to Send tickets to certain queue's

2004-06-05 Thread Jesse
Jeff Griffiths wrote: That's a queue permissions thing, I thought it was initially confusing as well. Just put the rest of of your queues as 'admin' with only the 'submission' queue as 'users'. cheers, JeffG Jesse wrote: I want to make it so that when when a

[otrs] Deleting Language Options

2004-06-05 Thread Jesse
How do I delete languages in the FAQ section? I only want the english one? thanks marshall ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Su

[otrs] Which Linux Distro. do you recommend?

2004-06-05 Thread Jesse
I'm curious which Linux Distro. you guys recommend for OTRS? which one has given you the most success? I've tried SuSE 9.0 but I seem to somehow make the mySQL service fail from starting and havn't found anyone who could help me. Overall which Linux Distro would you recommend? thanks marshall _

[otrs] KnowledgeBase Support

2004-06-03 Thread Jesse
I'm curious if anyone has implemented a knowledgebase into OTRS. I work for a non profit organization and have been researching the different open source trouble ticket software and am stuck between OTRS and HelpDesk OneZero (http://helpdesk.oneorzero.com/). On the other hand I enjoy the support/do

[otrs] Backing up OTRS

2004-06-02 Thread Jesse
What is the recommended method for backing up all of OTRS as well as apache and mySQL? Is there a solid system that is documented? What does everyone do? thanks marshall ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs

Re: [otrs] SMTP Mail Settings Question

2004-05-31 Thread Jesse
Robert Kehl wrote: On Tuesday, June 01, 2004 4:34 AM Jesse <[EMAIL PROTECTED]> wrote: Is this all I need to send e-mails out from otrs? This is one way, yes. Or do I need to configure sendmail? This were the other one, yes. SMTP is suff

[otrs] SMTP Mail Settings Question

2004-05-31 Thread Jesse
Is this all I need to send e-mails out from otrs? Or do I need to configure sendmail? $Self->{'SendmailModule'} = 'Kernel::System::Email:SMTP'; $Self->{'SendmailModule::Host'} = 'my.ispssmtp.server'; $Self->{'SendmailModule::Port'} = '25'; $Self->{'SendmailModule::AuthUser'} = '';

[otrs] Making Customers Only able to Send tickets to certain queue's

2004-05-31 Thread Jesse
I want to make it so that when when a customer creates a new ticket they can only post to a certain queue. right now I'm doing testing on a future ticket system and when I goto post with a user they can send a ticket to all the queue's. thanks marshall __

[otrs] Login Error message "login failed!"

2004-05-30 Thread Jesse
I recently installed otrs and followed the suse howto but when I login I get this error: "Login failed! Your username or password was entered incorrectly." I'm not sure how to add a user to get this to work, but I've tried the root user and the otrs user and get this message on both accounts.

[otrs] mysql fails to start

2004-05-30 Thread Jesse
Hello all, I am currently running mysql on a SuSE 9.0 machine. here is the mysql version Server version 4.0.15 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 23 min 0 sec The problem I