Hello, I've tried to register at to otrs bugzilla for the last days but received no mail (registration) response from there so far, so I report my problem here:
With OTRS 2.2.1, ITSM 1.0.1 on Debian Etch i get the following problem when using LDAP for Customer Information and Agent authentication: [Mon Aug 6 14:19:38 2007] -e: DBD::mysql::st execute failed: 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 ') ORDER BY st.create_time_unix DESC LIMIT 10' at line 1 at /usr/share/otrs//Kernel/System/DB.pm line 483. ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Mon Aug 6 14:19:38 2007 Message: 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 ') ORDER BY st.create_time_unix DESC LIMIT 10' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq WHERE sq.id = st.queue_id AND sq.group_id IN (1, 2, 3) AND LOWER(st.customer_id) IN ( ) ORDER BY st.create_time_unix DESC LIMIT 10' Traceback (21061): Module: Kernel::System::Ticket::TicketSearch (v1.264) Line: 3612 Module: Kernel::Modules::AgentTicketPhone::Run (v1.6) Line: 598 Module: Kernel::System::Web::InterfaceAgent::Run (v1.22) Line: 670 Module: ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 47 Module: (eval) (v1.81) Line: 203 Module: ModPerl::RegistryCooker::run (v1.81) Line: 203 Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 169 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Mon Aug 6 14:19:38 2007] -e: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/otrs//Kernel/System/DB.pm line 542. Additionally, but this may be unrelated, i don't get any additional Customer Information displayed. If you need additional information, feel free to ask, either on the list or via PM. Yours, Karsten -- Karsten Heymann Server-Administrator IP [EMAIL PROTECTED] infocity GmbH Schillerstraße 58, D-10627 Berlin Tel: +49 (0)30 3388 1981 Fax: +49 (0)30 3388 9 1981 -------------------------------------------- Amtsgericht Hannover, HRB 58487 Geschäftsführer: Robert E. Fowler III, Paul Stodden Sitz der Gesellschaft: Peiner Straße 8 - 30519 Hannover _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
