Hi Christian, On Mon, May 05, 2003 at 01:34:44PM +0200, Christian Lox wrote:
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 [...]
This comes if the agent is in no group. But OTRS will work well anyway... I fixed this in CVS. If you don't want the error message, update to the current Kernel/System/Queue.pm from CVS. Thanks!
Christian
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972