
Hi! OTRS 1.1.1 is installed for evaluating purposes. Since it was an update and rpm -U did not seem to work, we deleted the old version and did fresh install. Now I find the following in the Log: [Mon May 5 12:49:27 2003] null: DBD::mysql::st execute failed: You have an error in your SQL syntax near ') AND sq.valid_id in ( 1 )' at line 1 at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 228. ERROR: OTRS-CGI-10 Perl: 5.8.0 OS: linux Time: Mon May 5 12:49:27 2003 Message: You have an error in your SQL syntax near ') AND sq.valid_id in ( 1 )' at line 1, SQL: 'SELECT sq.id, sq.name FROM queue sq, group_user sug, groups sg WHERE sug.user_id = 3 AND sug.group_id = sg.id AND sq.group_id = sg.id AND sg.id IN ( ) AND sq.valid_id in ( 1 )' Traceback (32640): Module: Kernel::System::Queue::GetAllQueues (v1.28) Line: 232 Module: Kernel::Modules::AgentPreferences::Form (v1.18) Line: 94 Module: Kernel::Modules::AgentPreferences::Run (v1.18) Line: 66 Module: Apache::ROOThelpdesk_2ewtal_2etrend_2dservice_2ede::otrs::index_2epl::handler (v1.58) Line: 608 Module: (eval) (v2.01) Line: 149 Module: Apache::Registry::handler (v2.01) Line: 149 [Mon May 5 12:49:27 2003] null: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 250. Any hint appreciated, Christian