Hi all, I'm having troubles upgrading our koha 2.2.5 to 3.0.4. I'll describe what I have done so far, and really hope someone here can help me out. So far I have: - installed a new debian machine - installed latest koha on it, nozebra. Everything seems to work well so far. Then, to migrate our database: - create mysqldatadump on the old machine - imported mysqldatadump on new machine, using a DIFFERENT databasename - adjusted /etc/koha/koha-conf.xml to use the new database settings - followed instructions from the wiki to upgrade from 22 to 30 (http://wiki.koha.org/doku.php?id=22_to_30) starting from "Koha datas to update and/or add" (=the database upgrading) Here I had to take all extra steps to succeed, such as: Solving the " Multiple primary key defined" error, solving the "used table type doesn't support FULLTEXT indexes", solving the "Duplicate entry 'XXXX' for key 1". I followed all instructions on the wiki to solve these issues. However, my librarian noticed that we are missing certain data in out database: the serial history and borrower history is not there. So my questions: - is there a better way to import the 2.2.5 data into 3.0.4, or is the way I described above *the* way? - is it possible to import the borrower / serials history as well? - I had to take all possible extra wiki steps to solve errors I encountered. Are there things I can do in my old (still running) installation, so make the transition smoother..? (extra database checks? add stuff to the database there, whatever..?) Hope someone here has some ideas. Kind regards, and thanks for taking the time to read this, Mourik Jan
Hi all, Can anyone offer a suggestion..? mourik jan c heupink wrote:
Hi all,
I'm having troubles upgrading our koha 2.2.5 to 3.0.4. I'll describe what I have done so far, and really hope someone here can help me out.
So far I have: - installed a new debian machine - installed latest koha on it, nozebra. Everything seems to work well so far.
Then, to migrate our database: - create mysqldatadump on the old machine - imported mysqldatadump on new machine, using a DIFFERENT databasename - adjusted /etc/koha/koha-conf.xml to use the new database settings - followed instructions from the wiki to upgrade from 22 to 30 (http://wiki.koha.org/doku.php?id=22_to_30) starting from "Koha datas to update and/or add" (=the database upgrading)
Here I had to take all extra steps to succeed, such as: Solving the " Multiple primary key defined" error, solving the "used table type doesn't support FULLTEXT indexes", solving the "Duplicate entry 'XXXX' for key 1".
I followed all instructions on the wiki to solve these issues.
However, my librarian noticed that we are missing certain data in out database: the serial history and borrower history is not there.
So my questions: - is there a better way to import the 2.2.5 data into 3.0.4, or is the way I described above *the* way?
- is it possible to import the borrower / serials history as well?
- I had to take all possible extra wiki steps to solve errors I encountered. Are there things I can do in my old (still running) installation, so make the transition smoother..? (extra database checks? add stuff to the database there, whatever..?)
Hope someone here has some ideas.
Kind regards, and thanks for taking the time to read this,
Mourik Jan _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
mourik jan c heupink a écrit :
However, my librarian noticed that we are missing certain data in out database: the serial history and borrower history is not there.
what do you call "serial history" and "borrower history" ? afaik, the issues history is migrated in update22to30.pl
So my questions: - is there a better way to import the 2.2.5 data into 3.0.4, or is the way I described above *the* way?
definetly no
- is it possible to import the borrower / serials history as well?
should be (but explain what are borrower/serials history) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
Hi Paul, thanks for taking the time to read and response!
what do you call "serial history" and "borrower history" ? With borrower history we mean: a Patrons Reading Record.
should be (but explain what are borrower/serials history) And with Serials History, we mean the 'log' of which issues for serials have been received.
We may have a more fundamental problem, though. Every menu seems to work, except for one: the 'Patrons' tab under 'administration', 'Global system preferences'. We are getting a 'production mode - trapped fatal error'. And in the apache logs it says: systempreferences.pl: The given value does not seem to be interpretable as a Boolean value at /usr/share/koha/lib/C4/Boolean.pm line 102., referer: http://192.87.143.104:8080/cgi-bin/koha/admin/systempreferences.pl And this menu is where you can turn on the 'intranetreadinghistory'. Maybe this is our problem? In the koha-error.log i also get the following error: moremember.pl: Illegal date specified (year = 0, month = 0, day = 00) at /usr/share/koha/intranet/cgi-bin/members/moremember.pl line 122, referer: http://192.87.143.104:8080/cgi-bin/koha/members/moremember.pl?borrowernumber... Maybe that is related to the received serials log not being there? Hope everything is a bit clearer now..?
participants (2)
-
mourik jan c heupink -
Paul Poulain