February 2008 - otrs - OTRS mailing lists

windows update for OTRS
by pri pri 14 Feb '08

14 Feb '08

hi all I am currently using otrs version 2.2.1 on windows small business server 2003. I intend to upgrade it to 2.2.4 or 2.2.5 because of the bugs in the first version. i would to know how i can backup my mysql database. i went through the website and it was suggested to use the phpmyadmin or mysqldump. can somebody tell me how i can access my server remotely to perform the backup. thank you _________________________________________________________________ Tried the new MSN Messenger? It’s cool! Download now. http://messenger.msn.com/Download/Default.aspx?mkt=en-in

5 12

adding a Agent/User to 2.2.5
by Andrew Meyer 14 Feb '08

14 Feb '08

I get this when adding a Agent/User to OTRS 2.2.25 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ti.user_id = 1 AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_id' at line 1, SQL: 'SELECT ar.id, ar.article_sender_type_id, ti.id, ar.create_by, ti.create_time_unix, ti.until_time, tst.name, ar.article_type_id FROM ticket ti, article ar, ticket_state ts, ticket_state_type tst WHERE ti.ticket_lock_id NOT IN ( ) AND ti.user_id = 1 AND ar.ticket_id = ti.id AND ts.id = ti.ticket_state_id AND ts.type_id = tst.id ORDER BY ar.create_time DESC' Andrew Meyer Unix Systems Administrator 314-787-0681 x39 314-565-0868 (cell) 1300 Hampton Ave. Ste. 200 Saint Louis, MO 63139 http://www.precisionpractice.com/

1 0

OTRS 2.2.5
by Andrew Meyer 14 Feb '08

14 Feb '08

I have no icons at the top of OTRS 2.2.5, it just repeats the links. Is this a theme issue? Andrew Meyer Unix Systems Administrator 314-787-0681 x39 314-565-0868 (cell) 1300 Hampton Ave. Ste. 200 Saint Louis, MO 63139 http://www.precisionpractice.com/

1 0

Otrs 2.2.4 - FAQ
by Fabricio Cruz 14 Feb '08

14 Feb '08

Hi , I am trying to add an article without success, I do not see no option to make this. They can help me? PS: it forgives my English, it is very bad TKS Fabricio

3 2

Changing the customer interface (logo, company name, footer, etc)
by Nielson, Adam 14 Feb '08

14 Feb '08

How do I change the green bar for the customer interface where it says logo, company name, footer, etc? Thank you, Adam Nielson LJTL Systems Administrator work: 396.5669 cell: 283.4713

4 3

OTRS 2.2.5 error
by Andrew Meyer 14 Feb '08

14 Feb '08

I am getting this after installing OTRS 2.2.5 ERROR: OTRS-CGI-01 Perl: 5.8.8 OS: linux Time: Sun May 5 00:48:18 2002 Message: Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|maxdb|oracle|db2|mssql). Traceback (7122): Module: Kernel::System::DB::new (v1.75) Line: 150 Module: Kernel::System::Web::InterfaceAgent::Run (v1.23) Line: 144 Module: /var/www/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47 Andrew Meyer Unix Systems Administrator 314-787-0681 x39 314-565-0868 (cell) 1300 Hampton Ave. Ste. 200 Saint Louis, MO 63139 http://www.precisionpractice.com/

2 1

MIME::Parser: can't open tmpfile: Invalid argument
by ml＠bortal.de 14 Feb '08

14 Feb '08

Hello list, i get this error from my crontab: MIME::Parser: can't open tmpfile: Invalid argument i guess /usr/share/otrs/bin/PostMasterPOP3.pl is producing this error. Has anyone an idea why this is happening and how i can solve it? Thanks, Mario

1 0

Bad Gateway Error
by Jake Conk 13 Feb '08

13 Feb '08

Hello, Every time I log out of my system I get this error: "502 Bad Gateway The server returned an invalid or incomplete response. " Sometimes refreshing the page fixes it but usually I have to close my browser. Sometimes I get that error also when I am logged in with OTRS at some location with my laptop and move to another location and just click on a link. Is there anyway for me debug this issue or has anyone came across this already and has a fix? Thank you, - Jake

1 0

upgrading from 2.0.4 to 2.2.5
by Andrew Meyer 13 Feb '08

13 Feb '08

I am getting this when doing the Database upgrade. otrs2/var/www/otrs/scripts# cat DBUpdate-to-2.2.mysql.sql | mysql -u root -p -f otrs2 Enter password: ERROR 1146 (42S02) at line 103: Table 'otrs2.ticket_watcher' doesn't exist ERROR 1146 (42S02) at line 104: Table 'otrs2.ticket_watcher' doesn't exist Andrew Meyer Unix Systems Administrator 314-787-0681 x39 314-565-0868 (cell) 1300 Hampton Ave. Ste. 200 Saint Louis, MO 63139 http://www.precisionpractice.com/

2 1

Required fields when changing owner
by Lars Jørgensen 13 Feb '08

13 Feb '08

Hi. We have a supervisor who is responsible for assigning tickets to agents. She complains that she has to enter text in the box in the change owner screen. She usually just enters a single dot but it is still annoying to her. Is it possible to assign a new owner to a ticket without adding a note to the ticket? -- Lars Jørgensen Netværksadministrator Gyldendal A/S Tlf. 33 75 57 95

2 2