Hi, we are using koha version 2.1.2 and after some time (the weekend) we can't login with the kohaadmin user. The apache logs claims the following: DBD::mysql::db selectrow_array failed: MySQL server has gone away at /usr/local/koha/intranet/modules/C4/Context.pm line 361. and Context.pm sais: sub preference { my $self = shift; my $var = shift; # The system preference to return my $retval; # Return value my $dbh = C4::Context->dbh; # Database handle my $sth; # Database query handle # Look up systempreferences.variable==$var
> $retval = $dbh->selectrow_array(<<EOT); <<<<<<<<<<< 361 SELECT value FROM systempreferences WHERE variable='$var' LIMIT 1 EOT return $retval; }
Aparently the database conection is lost, any ideas? WARN: we are using mod_perl !!!! (with quite a performance improvement) Some of the database settings... key_buffer = 64M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M net_buffer_length = 64K interactive_timeout = 240 wait_timeout = 240 myisam_sort_buffer_size = 16M Regards, -- Ernesto Silva - Webmaster - Universidad ORT Uruguay Cuareim 1451. Montevideo. Montevideo - 11100. Uruguay. Email: silva@ort.edu.uy "Men and nations will act rationally when all other possibilities have been exhausted." Katz law.