Hi All, I am getting the below error in System log Mysql when using Dashboard. version 2.4.6 OTRS
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 st.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.until_time FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25' Please suggest what could be the problem, because of this my lock tickets are not getting unlock getting same error. Regards, Ruzwan On Sat, Oct 16, 2010 at 5:30 PM, <[email protected]> wrote: > Send otrs mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.otrs.org/cgi-bin/listinfo/otrs > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of otrs digest..." > > > Today's Topics: > > 1. Re: otrs Digest, Vol 25, Issue 35 (Ruzwan Abdul) > 2. Re: Customer with multiple email addresses (Broderick Wood) > 3. Comparing OTRS with other ticket system (Darshak) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 16 Oct 2010 08:55:29 +0530 > From: Ruzwan Abdul <[email protected]> > Subject: Re: [otrs] otrs Digest, Vol 25, Issue 35 > To: [email protected] > Message-ID: > <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi All, > > I am getting the below error in System log Mysql when using Dashboard. > version 2.4.6 OTRS > > > 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 > st.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25' at line 1, > SQL: 'SELECT DISTINCT st.id, st.tn, st.until_time FROM ticket st, queue sq > WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.until_time > >= > 1286808536 ORDER BY st.until_time ASC LIMIT 25' > > > Please suggest what could be the problem, because of this my lock tickets > are not getting unlock getting same error. > > Regards, > Ruzwan > On Fri, Oct 15, 2010 at 5:30 PM, <[email protected]> wrote: > > > Send otrs mailing list submissions to > > [email protected] > > > > To subscribe or unsubscribe via the World Wide Web, visit > > http://lists.otrs.org/cgi-bin/listinfo/otrs > > or, via email, send a message with subject or body 'help' to > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of otrs digest..." > > > > > > Today's Topics: > > > > 1. Link to reopen a ticket (Pradumna Maheshwari) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Fri, 15 Oct 2010 16:40:28 +0530 > > From: Pradumna Maheshwari <[email protected]> > > Subject: [otrs] Link to reopen a ticket > > To: [email protected], [email protected] > > Message-ID: > > < > of7d3402d4.a7b0b5ce-on652577bc.003d0ce9-652577bd.003d6...@tcs.com> > > Content-Type: text/plain; charset="us-ascii" > > > > Hello, > > > > I want to give a link in Survey, so that Customer can re-open the ticket. > > > > I tried this : > > <OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias> > > customer.pl?Action=CustomerTicketZoom&TicketID=<http://customer.pl/?Action=CustomerTicketZoom&TicketID=> > <http://customer.pl/?Action=CustomerTicketZoom&TicketID=> > > <OTRS_TICKET_ID> > > > > but not working. It is giving error : "Message: No Permission! " > > > > What to do..? > > > > Thanks... > > > > Pradumna Maheshwari > > =====-----=====-----===== > > Notice: The information contained in this e-mail > > message and/or attachments to it may contain > > confidential or privileged information. If you are > > not the intended recipient, any dissemination, use, > > review, distribution, printing or copying of the > > information contained in this e-mail message > > and/or attachments to it are strictly prohibited. If > > you have received this communication in error, > > please notify us by reply e-mail or telephone and > > immediately and permanently delete the message > > and any attachments. Thank you > > > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: < > > > http://lists.otrs.org/pipermail/otrs/attachments/20101015/5e16b562/attachment-0001.html > > > > > > > ------------------------------ > > > > --------------------------------------------------------------------- > > 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 > > > > End of otrs Digest, Vol 25, Issue 34 > > ************************************ > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.otrs.org/pipermail/otrs/attachments/20101016/96d1af1e/attachment-0001.html > > > > ------------------------------ > > Message: 2 > Date: Fri, 15 Oct 2010 12:03:11 -0600 > From: Broderick Wood <[email protected]> > Subject: Re: [otrs] Customer with multiple email addresses > To: "User questions and discussions about OTRS." <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=windows-1252 > > Has there been a response to this? This sounds exactly like what I need. > > We have users that tell us what their (multiple) e-mail addresses are > and we need to assign those to their single login ID which is against > our LDAP authentication system. > > I see this listed as a possible solution that was posted by "Torsten > Thau" previously: > > (1) create additional table columns (e.g. via SQL-Box in Admin area): > ALTER TABLE customer_user ADD COLUMN email_ext00 varchar(300); > ALTER TABLE customer_user ADD COLUMN email_ext01 varchar(300); > > (2) add new columns to customer backend configuration in Config.pm: > > (2a) Edit the customer backend definition related to the data source for > table "customer_data". Just add following rows to the Map-array (e.g. > directly below the definition for the default email-field): > [ 'UserEmail0', 'Further Email', 'email_ext00', 1, 0, 'var', '', 0 ], > [ 'UserEmail1', 'Further Email', 'email_ext01', 1, 0, 'var', '', 0 ], > > (2b) add new table columns as postmaster-search columns > CustomerUserPostMasterSearchFields => ['email', 'email_ext00', > 'email_ext01'], > > (3) If applicable, extend customeruser-import-export mappings in the > ImportExport backend. > > > > On Thu, Jul 1, 2010 at 5:38 AM, Nuno Miguel da Cruz Neves > <[email protected]> wrote: > > Thanks for the reply, as I could only come back here now. > > > > As for your suggestion, the problem is which field I map to customerID. > > > > I'll try to give a scenario: > > > > My username (sAMAccountName) is nneves > > > > So, my email address is [email protected] > > > > But I also have as aliases [email protected] and > [email protected] > > > > What I would like to do in OTRS is that an email coming from any of these > addresses would be mapped to my OTRS username. > > > > Can I map several email fields to one users (and then mapping them to the > proxyAddresses field of Active Directory)? > > > > Thank you, > > > > -----Original Message----- > > From: [email protected] [mailto:[email protected]] On Behalf Of > Michiel Beijen > > Sent: ter?a-feira, 1 de Junho de 2010 08:02 > > To: User questions and discussions about OTRS. > > Subject: Re: [otrs] Customer with multiple email addresses > > > > Hi Nuno, > > > > If you have the alias stored in your Active Directory, which I'm sure > > you will, then you can just map this to the Customer ID field and > > you'd be good! > > > > ((enjoy)) > > > > Michiel Beijen > > R&D > > > > Follow me on Twitter: @otrsnl [https://twitter.com/otrsnl] > > > > OTRS AG > > Norsk-Data-Str. 1 > > 61352 Bad Homburg > > GERMANY > > > > T: +31 (0) 6457 42418 > > F: +49 (0) 9421 56818-18 > > I: ?http://www.otrs.com > > > > Business Location: Bad Homburg, Country Court: Bad Homburg, HRB 10751, > > VAT ID: DE256610065 > > Chairman: Burchard Steinbild, Managing Board: Andr? Mindermann > > > > GET OTRS::ITSM 2.0 NOW - including the brand new change management > > module! It?s the only ITIL? V3 compatible open-source IT Service > > Management solution certified by PinkVERIFY worldwide! - > > http://bit.ly/dv4CJF > > > > > > > > > > On Mon, May 31, 2010 at 5:08 PM, Nuno Miguel da Cruz Neves > > <[email protected]> wrote: > >> Hello. > >> > >> > >> > >> I am setting up OTRS against an Active Directory backend for customers. > >> > >> > >> > >> The thing is, my AD username is my CustomerID, but, when sending emails, > my > >> email address is an alias. Is there a way I can specify multiple > CustomerID > >> for the same user? > >> > >> > >> > >> I?ll try to write an example: > >> > >> > >> > >> My AD username is nneves . So, my email address is [email protected] > >> > >> > >> > >> But I use an alias [email protected] > >> > >> > >> > >> Is there a way I can say that if I receive an email with a request from > >> [email protected], it should stay in [email protected] queue, so > that > >> when I login as a customer, I can see all my requests? > >> > >> > >> > >> Thank you, > >> > >> > >> > >> Nuno Miguel Neves > >> > >> Partner > >> > >> PKF Sistemas de Informa??o, S.A. > >> > >> Edificio Atrium Saldanha l Pra?a Duque de Saldanha, n?1 4? Piso H l > 1050-094 > >> Lisboa l Portugal > >> > >> Tel: +351 213 182 720 l Fax: +351 213 146 114 l Tlm: + 351 964 803 152 > >> > >> email: [email protected] l ?http://www.pkf.pt > >> > >> > >> > >> > >> > >> A PKF ? Sistemas de Informa??o,SA ? membro da PKF International Limited, > uma > >> associa??o de sociedades membro legalmente independentes, a qual n?o > aceita > >> quaisquer responsabilidades pelos actos ou omiss?es de qualquer > sociedade ou > >> sociedades membro. Uma qualquer sociedade membro n?o aceita quaisquer > >> responsabilidades pelos actos ou omiss?es de qualquer outra sociedade ou > >> sociedades membro. > >> > >> PKF ? Sistemas de Informa??o,SA is a member of PKF International > Limited, an > >> association of legally independent member firms which does not accept > any > >> responsibility or liability for the actions or inactions on the part of > any > >> individual member firm or firms. Individual member firms do not accept > >> responsibility or liability for actions or inactions on the part of any > >> other individual member firm or firms. > >> > >> > >> > >> Este e-mail pode conter informa??o privilegiada e confidencial. Se n?o ? > o > >> destinat?rio pretendido, n?o deve copiar ou distribuir este e-mail. Se > >> recebeu este e-mail por engano, por favor notifique imediatamente o > >> remetente. Deve certificar-se que este e-mail e os seus anexos n?o se > >> encontram infectados por v?rus. O envio de e-mails n?o ? um meio de > >> comunica??o completamente seguro. Apelamos a que reconhe?a essa falta de > >> seguran?a e que tome todas as precau??es necess?rias quando comunicar > >> connosco via e-mail. > >> > >> A PKF reserva-se do direito de ler sem pr?-aviso qualquer e-mail e > >> respectivos anexos que nos sejam enviados. > >> > >> This e-mail may contain privileged and confidential information. If you > are > >> not the intended recipient, you must not copy or distribute it. If you > have > >> received this e-mail in error, please notify the sender and delete the > >> e-mail immediately. You should ensure that this e-mail and any > attachments > >> are virus free. E-mail is not a 100% secure communications medium. We > advise > >> that you understand this lack of security and take any necessary > measures > >> when e-mailing us. > >> We reserve the right to read any e-mail or attachment entering or > leaving > >> our systems from any source without prior notice. > >> > >> > >> > >> --------------------------------------------------------------------- > >> 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 > >> > >> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > >> http://www.otrs.com/en/support/enterprise-subscription/ > >> > > --------------------------------------------------------------------- > > 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 > > > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > > http://www.otrs.com/en/support/enterprise-subscription/ > > > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > > SISTEMA DE ANTI-VIRUS e FILTRAGEM DE CONTEUDOS DE E-MAIL > > PKF > > > > Esta mensagem for verificada pelo sistema de Controlo de > > Anti-Virus e Filtragem de Conteudos de mensagens de E-Mail. > > Embora nao tenha sido detectado qualquer virus no seu conteudo, > > aconselha-se atencao especial aos ficheiros em anexo que > > possam existir. > > > > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > > http://www.otrs.com/en/support/enterprise-subscription/ > > > > -- > ------------------------------------------------ > Broderick Wood > HelpDesk Co-Ordinator > Technical Services Team > #205 Athabasca Hall > Department of Computer Science > The University of Alberta > Edmonton, AB > T6G 2E8 > (780) 492-5018 > > > ------------------------------ > > Message: 3 > Date: Sat, 16 Oct 2010 11:18:53 +0530 > From: Darshak <[email protected]> > Subject: [otrs] Comparing OTRS with other ticket system > To: "User questions and discussions about OTRS." <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1"; Format="flowed" > > Dear All, > > I have to propose a ticket system to my company. I have gone thru > different ticket systems. > > Can you tell me what are unique features in OTRS over other systems like > RT,OSTicket,KAYAKO etc. > > Any benchmark by OTRS? Can it handle daily 10000 tickets and 1000 > agents on single box [ good quality hardware]? > > -- > Best Regards, > Darshak Modi > +91 9909008245 > [email protected] > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.otrs.org/pipermail/otrs/attachments/20101016/e3903221/attachment-0001.html > > > > ------------------------------ > > --------------------------------------------------------------------- > 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 > > End of otrs Digest, Vol 25, Issue 36 > ************************************ > -- Regards, Ruzwan Technical Lead Product Development & Delivery Pyro Networks Pvt. Ltd, Hyderabad - 500033, INDIA Mobile: +91 9642333207 http://www.pyrogroup.com
--------------------------------------------------------------------- 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
