Hi Folks, Linux Fedora Core 2 Kernel 2.6.8.1 Apache 2.0.52 manuell mod_perl 2.0.0 RC1 manuell PostgreSQL 7.4.5 manuell setpermissions sind ok im apache2-perl-startup.pl "use DBD::mysql" gegen "use DBD::Pg" getauscht. alles tut soweit, nur die 2 oberen Statistiken nicht, die Untere tut. das error.log des apache spricht folgendes: (an den rechten liegt es nicht, das gleiche mit mysql tut aber) [Tue Dec 21 14:10:51 2004] [error] [client 10.1.101.5] File does not exist: /opt/otrs/var/httpd/htdocs/favicon.ico ERROR: OTRS-CGI-10 Perl: 5.8.3 OS: linux Time: Tue Dec 21 14:10:53 2004 Message: Can't open: /opt/otrs/var/tmp/Kernel-System-Stats-TicketOverview-2004-10.cache: No such file or directory Traceback (12479): Module: Kernel::Modules::SystemStats::ReadResultCache (v1.13 ) Line: 478 Module: Kernel::Modules::SystemStats::Run (v1.13 ) Line: 140 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 638 Module: (eval) (v1.73) Line: 202 Module: ModPerl::RegistryCooker::run (v1.73) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.73) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Tue Dec 21 14:10:53 2004] -e: DBD::Pg::st execute failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at /opt/otrs//Kernel/System/DB.pm line 436. ERROR: OTRS-CGI-10 Perl: 5.8.3 OS: linux Time: Tue Dec 21 14:10:53 2004 Message: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list, SQL: 'SELECT DISTINCT(th.ticket_id) FROM ticket_history th WHERE th.create_time <= '2004-10-31 23:59:59' AND th.create_time >= '2003-10-01 00:00:01' ORDER BY th.create_time DESC LIMIT 50000' Traceback (12479): Module: Kernel::System::Ticket::HistoryTicketStatusGet (v1.19.2.1) Line: 2717 Module: Kernel::System::Stats::TicketOverview::Run (v1.1 ) Line: 117 Module: Kernel::Modules::SystemStats::Run (v1.13 ) Line: 148 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 638 Module: (eval) (v1.73) Line: 202 Module: ModPerl::RegistryCooker::run (v1.73) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.73) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Tue Dec 21 14:10:53 2004] -e: DBD::Pg::st fetchrow_array failed: no statement executing at /opt/otrs//Kernel/System/DB.pm line 474. ERROR: OTRS-CGI-10 Perl: 5.8.3 OS: linux Time: Tue Dec 21 14:10:53 2004 Message: Can't write: /opt/otrs/var/tmp/Kernel-System-Stats-TicketOverview-2004-10.cache: Permission denied Traceback (12479): Module: Kernel::Modules::SystemStats::WriteResultCache (v1.13 ) Line: 437 Module: Kernel::Modules::SystemStats::Run (v1.13 ) Line: 149 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 638 Module: (eval) (v1.73) Line: 202 Module: ModPerl::RegistryCooker::run (v1.73) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.73) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30 jemand eine idee ? gruß thomas börnert