[Koha] Re: Problems with Koha 2.2.8 and MySQL 4.1
vnwebmail at hotmail.com
Fri May 18 05:23:56 NZST 2007
Kevin O'Rourke <lists at ...> writes:
> OK, I've discovered the answer to my own question, it should be useful
> information for other people out there.
> The upgrading process from MySQL 4.0 to 4.1 changed the length of text
> Login Error
> You are accessing Koha from a different ip address! Please login again.
> This is because the 'sessions' table had its 'ip' field truncated to 5
> The other problems had similar causes.
> 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.
> I'm very glad I made that backup!--
> Kevin O'Rourke
> ICT Coordinator, National Teachers' Institute, Kaduna, Nigeria
> 062 316972
THANKS for your post!
I ran into the same problem on a fresh install. Not being a MySQL expert how
would I correct this problem if I don't have any backup files to leverage?
THANKS in advance for any help you can provide!
More information about the Koha