September 2012 - otrs - OTRS mailing lists

Thorsten Kocher/Spirit21 ist außer Haus.
by TKocher＠spirit21.de 19 Apr '17

19 Apr '17

Ich werde ab 13.05.2005 nicht im Büro sein. Ich kehre zurück am 30.05.2005. Vielen Dank für Ihre Email. Leider befinde ich mich bis Montag, 30. Mai 2005 außer Haus und kann daher Ihre Nachricht nicht bearbeiten. Bitte rufen Sie mich in dringenden Fällen mobil unter 0172 6377392 an. Vielen Dank für Ihr Verständnis. Thorsten Kocher Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.

36 63

MSSQL, CS_OPT_TEXTSIZE failed and the solution mentioned in the CHANGELOG
by Johannes Scholz 06 Aug '13

06 Aug '13

Hello, I am using MSSQL as customer backend and I am getting the infamous CS_OPT_TEXTSIZE error. The CHANGELOG suggests to set the "Attribute => {}" option of the database backend, in order to prevent LongReadLen being set. This is what I did: Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:Sybase:server=XXX; database=XXX', User => 'xxx', Password => 'xxx', Table => 'XXX', Attribute => {}, ... } Despite the "Attribute" var being set it seems to be ignored, as I am still getting a lot of "Setting of CS_OPT_TEXTSIZE failed. at /opt/otrs/Kernel/cpan-lib/Apache/DBI.pm line 319." errors. PRODUCT = OTRS VERSION = 3.1.2 BUILDDATE = Fri Mar 2 08:35:30 CET 2012 BUILDHOST = otrsbuild.otrs.com Compile-time settings (established with the "configure" script) Version: freetds v0.82 freetds.conf directory: /etc/freetds MS db-lib source compatibility: no Sybase binary compatibility: yes Thread safety: yes iconv library: yes TDS version: 4.2 iODBC: no unixodbc: yes The MSSQL server is 2008 R2, TDS protocol version is set to 8.0. Any ideas? Regards, Johannes Scholz

2 1

Enable CC ?
by Hussein E. Hijazi 28 Mar '13

28 Mar '13

Hi Is it possible for enabling CC'ing when a customer creates a ticket? Sometimes folks are making a ticket and they want other people to know that. Thanks, Hussein

3 4

Can I use ACLs to hide a certain state transition in GUI while allowing it for the Generic Agent
by Bogdan Iosif 05 Oct '12

05 Oct '12

Hi, Same question, reformulated to use an example: Can I use ACLs to hide the "pending auto close-" state (of type "pending auto") in all agent GUIs while keeping the ability to set this state from Generic Agent jobs? AFAIK, the hiding in GUI part is possible but I'm not sure if the ACLs also apply to the Generic Agent. Thanks, Bogdan P.S: I'm just starting ACLs investigation and I'm not yet able to create my own test. Google hasn't yielded a response.

6 14

Query regarding CustomerTicketMessage
by Abdul Mohammed 05 Oct '12

05 Oct '12

Hi All, I have setup OTRS as our ticketing tool. I am currently trying to remove the default ( - ) from drop down menu of To: address in CustomerTicketMessage to a created queue. With regards, Abdul

6 10

can´t see history ticket
by DM_Julio Angulo 04 Oct '12

04 Oct '12

hi guys, checking the log I find this message: [Tue Sep 25 13:05:01 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' [Tue Sep 25 13:05:01 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' [Tue Sep 25 13:05:01 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' [Tue Sep 25 13:05:01 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' [Tue Sep 25 13:05:01 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' [Tue Sep 25 13:05:01 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' [Tue Sep 25 13:05:02 2012][Error][Kernel::System::Ticket::HistoryAdd][6265] Table '.\otrs\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' Now when I see the history of the ticket not displayed I do not understand the message, any help thanks Julio Angulo Telf.: +51 1 4150300 anexo: 1468 Movil: +51 997066155

3 4

Should I ask user questions on this mailing list or on http://forums.otterhub.org/
by Bogdan Iosif 28 Sep '12

28 Sep '12

Hi, I'm confused about the proper place where I should ask a user question. Should I ask on: a) this mailing list b) http://forums.otterhub.org c) all of the above d) either a) OR b) but never both Thanks, Bogdan

2 1

Apache closed connection while updating ITSM
by Juan Manuel Clavero Almirón 26 Sep '12

26 Sep '12

Hello, I was upgrading ITSM (from 3.0.5 to 3.1.5) using AdminPackageManager but Apache closed connection. Afterwards, ITSM appeared upgraded but all its submodules not (ITSM was in 3.1.5, ITSM-Core and others where in 3.0.5). Anyone has any clue as to why it happened and how to prevent it? Kind regards, Juan Clavero

1 0

Mysql Help
by Andrew Meyer 25 Sep '12

25 Sep '12

I need to close about 25,000 tickets all with the same email address. I was hoping to do this within the MySQL Workbench or at the command line. Can anyone assist me in executing this command? Thanks, Andrew Meyer Unix Systems Administrator Precision Practice Management The business behind the practice. [Description: http://www.precisionpractice.com/EmailSignature/images/logoTeamLeader.jpg] D: 314-881-5265 C: 314-565-0868 F: 314-881-5365 689 Craig Road, Creve Coeur, MO 63141 Main Phone: 314-787-0681 www.PrecisionPractice.com<http://www.PrecisionPractice.com> Email: ameyer(a)precisionpractice.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, may include protected health information (PHI), confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed or the individuals designated to view such information per federal HIPAA regulations. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

5 9

Fehlermeldung nach Update auf 3.1.10
by S.Krueger＠aswo.com 25 Sep '12

25 Sep '12

Hi ! seit Update auf 3.1.10 können keine Telefon-tickets mehr erstelt werden. Im Log erscheint folgender Fehler. Sep 25 15:46:08 support-test OTRS-CGI-68[16271]: [Error][Kernel::System::DynamicField::DynamicFieldUpdate][Line:356]: Need ID! Ich habe im Admin-Handbuch gelesen, dass aus den FreetextFelder jetzt Dynamische Felder geworden sind. Wir hatten Freetextfelder im Einsatz, wenn ich im ADMIN-Bereich unter "Dynamic Fields" gucke, wird mir nichts angezeigt. Hätten die alten FreetextFelder nicht migriert werden müssen ?! Oder muss ich noch an anderer Stelle etwas aktivieren ?! Jeder Tip ist gern genommen. Steffi

1 0