After I updated koha form 2.0 to 2.2.2, the marc_word table was empty. How to fix that so that I can get records in the old database. Thanks. -- View this message in context: http://www.nabble.com/marc_word-table-tp18798161p18798161.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Bobby703 a écrit :
After I updated koha form 2.0 to 2.2.2, the marc_word table was empty. How to fix that so that I can get records in the old database. Thanks.
A suggestion : go directly to 3.0. The marc_word table is useless in 3.0 so you don't have to care about it ;-) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08
Can I update from koha 2.0 directly to koha 3.0 ? I can only find the instruction of updating koha from 2.2 to 3.0 on http://wiki.koha.org/doku.php?id=22_to_30 Can I still follow that instruction to update koha from 2.0 to 3.0 ? Many thanks. Paul POULAIN-2 wrote:
Bobby703 a écrit :
After I updated koha form 2.0 to 2.2.2, the marc_word table was empty. How to fix that so that I can get records in the old database. Thanks.
A suggestion : go directly to 3.0. The marc_word table is useless in 3.0 so you don't have to care about it ;-)
-- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/marc_word-table-tp18798161p18803556.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Bobby703 a écrit :
Can I update from koha 2.0 directly to koha 3.0 ? I can only find the instruction of updating koha from 2.2 to 3.0 on http://wiki.koha.org/doku.php?id=22_to_30 Can I still follow that instruction to update koha from 2.0 to 3.0 ? Many thanks. It's totally untested. So the best solution I think is to do 2.0 => 2.2 => 3.0
-- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08
Yes, Paul. That's why I try to update it to 2.2 from 2.0 then go for 3.0. But I got the empty marc_word table problem which causes all catalog search return nothing. I can see there is no other error but just the SQL query (joint with marc_word table) returns nothing. I used MySQL 5 at the first but it seems koha 2.2 is not working properly with MySQL 5 and I get lots of syntax errors like unknown column or something. So I downgraded the database to MySQL4. Then there is no such kind of error but just no result returned. My biggest problem is how to get marc_word table rebuilt. I tried the script rebuild_marc_word.pl but it failed. How can I populate this marc_word table after update the database. Also, I ran koha2mac.pl and got "Framework can not be null" error. How can I fix these issues? Thanks. Paul POULAIN-2 wrote:
Bobby703 a écrit :
Can I update from koha 2.0 directly to koha 3.0 ? I can only find the instruction of updating koha from 2.2 to 3.0 on http://wiki.koha.org/doku.php?id=22_to_30 Can I still follow that instruction to update koha from 2.0 to 3.0 ? Many thanks. It's totally untested. So the best solution I think is to do 2.0 => 2.2 => 3.0
-- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/marc_word-table-tp18798161p18822216.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
As marc_word table will not be used in Koha3.0, does it mean I can just ignore this table when I update from 2.0 to 2.2 and then do 3.0? Maybe I can just update it from 2.0 to 2.2 and then go for 3.0. -- View this message in context: http://www.nabble.com/marc_word-table-tp18798161p18822449.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Bobby703 a écrit :
As marc_word table will not be used in Koha3.0, does it mean I can just ignore this table when I update from 2.0 to 2.2 and then do 3.0? Maybe I can just update it from 2.0 to 2.2 and then go for 3.0.
You've got it ! the marc_word (and auth_word) tables are used for indexing in 2.2 As we have other indexing tools in 3.0, this table is totally useless in your case you can continue your move to 3.0 without any question. Note : the marc_subfield_table is the important table. It contains your MARC datas. This one must have plenty rows ;-) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08
Hi Paul. Thank you for your tips. I am on the way to 3.0. But after I updated from 2.0 to 2.2.2b, I could not find anything in the table marc_subfield_table either. As you said this table was important, how can I rebuild the records in this table. There was no such table in koha 2.0. What can I do with this table. Also, I am on my way to 3.0, just going through scripts under misc/migration_tools/22_to_30. So far, it looks all right. Some errors about missing perl modules were fixed by myself. But I am really worried about missing records in the marc_subfield_table. So, my questions are: 1. How to rebuild marc_subfield_table? Run koha2marc.pl script? 2. If I couldn't rebuild marc_subfield_table, does it mean I still can't get it updated to 3.0 even I might successfully follow all the steps of the update instruction? Many thanks. Paul POULAIN-2 wrote:
Bobby703 a écrit :
As marc_word table will not be used in Koha3.0, does it mean I can just ignore this table when I update from 2.0 to 2.2 and then do 3.0? Maybe I can just update it from 2.0 to 2.2 and then go for 3.0.
You've got it !
the marc_word (and auth_word) tables are used for indexing in 2.2 As we have other indexing tools in 3.0, this table is totally useless in your case you can continue your move to 3.0 without any question.
Note : the marc_subfield_table is the important table. It contains your MARC datas. This one must have plenty rows ;-)
-- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/marc_word-table-tp18798161p18885716.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (2)
-
Bobby703 -
Paul POULAIN