<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
OK, I've discovered the answer to my own question, it should be useful
information for other people out there.<br>
<br>
The upgrading process from MySQL 4.0 to 4.1 changed the length of text
fields!<br>
<br>
<blockquote cite="mid464C38CB.7000707@caboose.org.uk" type="cite">
<ol>
<li>
<h3>Login Error</h3>
You are accessing Koha from a different ip address! Please login again.</li>
</ol>
</blockquote>
This is because the 'sessions' table had its 'ip' field truncated to 5
characters.<br>
<br>
The other problems had similar causes.<br>
<br>
I've got Koha working again by dropping all the tables in the Koha
database and re-importing the data from my backup. The 'mysqldump'
command defaults to creating backups that don't specify character
encodings for the tables, so they've all defaulted to UTF-8 on import.<br>
<br>
I'm very glad I made that backup!<br>
<br>
<pre class="moz-signature" cols="72">--
Kevin O'Rourke
ICT Coordinator, National Teachers' Institute, Kaduna, Nigeria
062 316972</pre>
</body>
</html>