[otrs] Adding queues after upgrade to OTRS latest version
Title: Nombre emplead@ (Andago) Hi, I upgraded a month ago to OTRS's latest version. Everything was working fine until recently I had the need to add another queue (I know, I should've tested this before upgrading). When I try to add a new queue it seems that the data is not reaching the SQL insert command and I get the following error: ERROR: invalid input syntax for integer: "", SQL: 'INSERT INTO queue (name, group_id, unlock_timeout, system_address_id, calendar_name, default_sign_key, salutation_id, signature_id, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, follow_up_id, follow_up_lock, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' Is this an issue? Did somebody else get this problem? Thanks for your help -- Jorge Cabrera Mndez Departamento de IT T: +34 916 011 373 M: +34 637 741 034 F: +34 916 011 372 jorge.cabr...@andago.com www.andago.com Sguenos en: Twitter - Facebook - LinkedIn - YouTube NDAGO INGENIERA lcalde ngel Arroyo, 10, 1 28904, Getafe, Madrid (Spain) NDAGO LABS Bizkaia Technology Park Kanala Bidea, Edif-103, 1 izq. E-48170, Zamudio, Bizkaia (Spain) NDAGO INTERAMRICAS Ciudad del Saber Edificio 223, 3A. Ciudad de Panam (Panam) Antes de imprimir este mensaje, asegrese de que es necesario. El medio ambiente est en nuestra mano. Consider the environment before printing this mail. AVISO LEGAL ANDAGO CONSULTING SL / ANDAGO INGENIERA, SL le informa que los datos facilitados por Ud. y utilizados para el envo de esta comunicacin sern objeto de tratamiento automatizado o no en nuestros ficheros, con la finalidad de gestionar la agenda de contactos de nuestra empresa y para el envo de comunicaciones profesionales por cualquier medio electrnico o no. Vd. podr en cualquier momento ejercer el derecho de acceso, rectificacin, cancelacin y oposicin en los trminos establecidos en la Ley Orgnica 15/1999. El responsable del tratamiento es ANDAGO CONSULTING SL / ANDAGO INGENIERIA SL, con domicilio en C/ ALCALDE ANGEL ARROYO, 10, 28904, Getafe (Madrid). El contenido de esta comunicacin, as como el de toda la documentacin anexa, es confidencial y va dirigido nicamente al destinatario del mismo. En el supuesto de que usted no fuera el destinatario, le solicitamos que nos lo indique y no comunique su contenido a terceros, procediendo a su destruccin. DISCLAIMER The content of this communication and any attached information is confidential and exclusively for the use of the addressee. If you are not the addressee, we ask you to notify to the sender and do not pass its content to another person, and please be sure you destroy it. - 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
Re: [otrs] Adding queues after upgrade to OTRS latest version
Hi! I know that this is a known bug in 3.0.5... what version are you running? Cheers Phil -- It might be just possible, by lying very still in a cellar somewhere, to get through a day without committing a crime. But only just. And, even then, you were probably guilty of loitering. - Terry Pratchett: Feet of clay. GPG KEY ID (Philipp Bieber): 0x0185E301 FINGERPRINT: CA81 28C2 E63F DAF8 5ED4 DACB 7C26 EE5B 0185 E301 Philipp Bieber - philbie...@gmail.com On Wed, Mar 30, 2011 at 16:03, Jorge Cabrera jorge.cabr...@andago.comwrote: Hi, I upgraded a month ago to OTRS's latest version. Everything was working fine until recently I had the need to add another queue (I know, I should've tested this before upgrading). When I try to add a new queue it seems that the data is not reaching the SQL insert command and I get the following error: ERROR: invalid input syntax for integer: , SQL: 'INSERT INTO queue (name, group_id, unlock_timeout, system_address_id, calendar_name, default_sign_key, salutation_id, signature_id, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, follow_up_id, follow_up_lock, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' Is this an issue? Did somebody else get this problem? Thanks for your help -- *Jorge Cabrera Méndez* Departamento de IT T: +34 916 011 373 M: +34 637 741 034 F: +34 916 011 372 jorge.cabr...@andago.com www.andago.com Síguenos en: Twitter http://twitter.com/andago - Facebookhttp://www.facebook.com/pages/Andago/111911732048- LinkedIn http://www.linkedin.com/groups?gid=1479457 - YouTubehttp://www.youtube.com/andagotv *ÁNDAGO INGENIERÍA* Álcalde Ángel Arroyo, 10, 1º 28904, Getafe, Madrid (Spain) *ÁNDAGO LABS* Bizkaia Technology Park Kanala Bidea, Edif-103, 1º izq. E-48170, Zamudio, Bizkaia (Spain) [image: logotipo de Andago] *ÁNDAGO INTERAMÉRICAS* Ciudad del Saber Edificio 223, 3ºA. Ciudad de Panamá (Panamá) Antes de imprimir este mensaje, asegúrese de que es necesario. El medio ambiente está en nuestra mano. Consider the environment before printing this mail. AVISO LEGAL -- *ANDAGO CONSULTING SL / ANDAGO INGENIERÍA, SL* le informa que los datos facilitados por Ud. y utilizados para el envío de esta comunicación serán objeto de tratamiento automatizado o no en nuestros ficheros, con la finalidad de gestionar la agenda de contactos de nuestra empresa y para el envío de comunicaciones profesionales por cualquier medio electrónico o no. Vd. podrá en cualquier momento ejercer el derecho de acceso, rectificación, cancelación y oposición en los términos establecidos en la Ley Orgánica 15/1999. El responsable del tratamiento es ANDAGO CONSULTING SL / ANDAGO INGENIERIA SL, con domicilio en C/ ALCALDE ANGEL ARROYO, 10, 28904, Getafe (Madrid). El contenido de esta comunicación, así como el de toda la documentación anexa, es confidencial y va dirigido únicamente al destinatario del mismo. En el supuesto de que usted no fuera el destinatario, le solicitamos que nos lo indique y no comunique su contenido a terceros, procediendo a su destrucción. DISCLAIMER -- The content of this communication and any attached information is confidential and exclusively for the use of the addressee. If you are not the addressee, we ask you to notify to the sender and do not pass its content to another person, and please be sure you destroy it. - 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 logo_andago vectorizado_0.gifmedio-ambiente.jpg- 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
Re: [otrs] Adding queues after upgrade to OTRS latest version
Hi, On 03/30/2011 04:14 PM, Phil Bieber wrote: Hi! I know that this is a known bug in 3.0.5... what version are you running? Cheers Phil Thanks for your reply. Yes, it's 3.0.5. I found the bug report with number #6837 (http://bugs.otrs.org/show_bug.cgi?id=6837) with a patched file that has the solution. Sorry, found it after I ran the question. Thanks anyways -- It might be just possible, by lying very still in a cellar somewhere, to get through a day without committing a crime. But only just. And, even then, you were probably guilty of loitering. - Terry Pratchett: Feet of clay. GPG KEY ID (Philipp Bieber): 0x0185E301 FINGERPRINT: CA81 28C2 E63F DAF8 5ED4 DACB 7C26 EE5B 0185 E301 Philipp Bieber - philbie...@gmail.com mailto:philbie...@gmail.com On Wed, Mar 30, 2011 at 16:03, Jorge Cabrera jorge.cabr...@andago.com mailto:jorge.cabr...@andago.com wrote: Hi, I upgraded a month ago to OTRS's latest version. Everything was working fine until recently I had the need to add another queue (I know, I should've tested this before upgrading). When I try to add a new queue it seems that the data is not reaching the SQL insert command and I get the following error: ERROR: invalid input syntax for integer: , SQL: 'INSERT INTO queue (name, group_id, unlock_timeout, system_address_id, calendar_name, default_sign_key, salutation_id, signature_id, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify, follow_up_id, follow_up_lock, valid_id, comments, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)' Is this an issue? Did somebody else get this problem? - 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
Re: [otrs] Adding queues after upgrade to OTRS latest version
Hi, On 03/30/2011 04:22 PM, Leonardo Certuche wrote: Hello, I don't know about upgrade issues but if you need a new queue, you could try creating it directly into database: INSERT INTO queue VALUES (NULL, 'New queue', 1, 0, 0, 0, 0, 0, 0, 0, 1, '', '', 1, 1, 1, 1, '', 2, sysdate(), 1, sysdate(), 1), And then editing it using the front end Thanks for your reply, but the patch (http://source.otrs.org/viewvc.cgi/otrs/Kernel/Modules/AdminQueue.pm?revision=1.78view=markup) seemed to work fine. Best regards - 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