Continued 1.2.3 -> 2.x Migration Woes
Hi everyone, I'm still trying to figure out how to get an old 1.2.3 database into a current version of Koha. I cannot locate 2.0.x anywhere, so I'm still working with 2.2.7. I'd be happy to go with a 2.0.x release if that would help and someone could point me to where that might be (it does not appear to be on SourceForge any longer). The problem is that while database updater seemed to run fine, and in reports, Koha shows 1,800+ books, it cannot bring them up when searching, whether by title, author, barcode, etc. I'm at a loss to what to do to get our data into some kind of usable form. I'd appreciate any insight someone might be able to give me. Thanks, Tim
Perhaps this would explain something: I noticed that the marc_biblio table is empty, and that seems to be an important table in the SQL queries I've been looking at. Is there a good way to automatically populate it from the data in biblio? Thanks, Tim
On 30/04/2007, at 4:38 AM, Timothy R.Butler wrote:
Perhaps this would explain something: I noticed that the marc_biblio table is empty, and that seems to be an important table in the SQL queries I've been looking at. Is there a good way to automatically populate it from the data in biblio?
Hi Tim Im assuming all your data is backed up :) If so, what I would do is run the koha2marc.pl script this should populate the marc tables. But first you want to go to system administration in Koha and check that you have a default MARC framework set up. And also check the Koha to MARC links. If this is unclear, let me know, and ill dig up some screen shots Chris -- Chris Cormack chris.cormack@liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131
But first you want to go to system administration in Koha and check that you have a default MARC framework set up. And also check the Koha to MARC links.
Great, thank you Chris! I do have one problem on checking that though: I presume the MARC settings would be under parameters, and the white table on the parameters page is completely blank, so I cannot get to any of the settings. Any ideas on why that would be? I do have the data backed up, so that part is good at least. Thanks for your help. -Tim
Chris, Just for grins, I tried koha2marc.pl without checking the marc settings first (since I cannot get to them), and I got the following errors repeated for each entry. I'm not sure if this means marc was set incorrectly or something else. Thanks again for your help! -Tim DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 468. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldorder,subfieldvalue) values (,942,4, ,c,1,C) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 1284. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (,concat(942,c),4,1,C,soundex(C)) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 468. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldorder,subfieldvalue) values (,942,4, ,k,2,0.000000) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 1284. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (,concat(942,k),4,2,0,soundex(0)) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 1284. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (,concat(942,k),4,2,000000,soundex(000000)) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 468. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldorder,subfieldvalue) values (,245,5, ,b,1,) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/C4/Biblio.pm line 468. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldorder,subfieldvalue) values (,000,6,, ,1, )
Timothy R.Butler a écrit :
But first you want to go to system administration in Koha and check that you have a default MARC framework set up. And also check the Koha to MARC links.
Great, thank you Chris! I do have one problem on checking that though: I presume the MARC settings would be under parameters, and the white table on the parameters page is completely blank, so I cannot get to any of the settings. Any ideas on why that would be?
The marc def tables are filled when moving to 2.0 you can find what you're looking for in marc_datas & sql_datas directory, in misc/ HTH -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19
Paul POULAIN <paul.poulain@...> writes:
The marc def tables are filled when moving to 2.0
you can find what you're looking for in marc_datas & sql_datas directory, in misc/
Sorry for the slow reply. I appreciate your help! I tried filling in the table with the SQL files in those directories. The SQL files in marc_datas were refused by MySQL, which said that they conflicted with what was already in the table (I suppose that is a good sign). I did apply the ones in sql_datas. After that, I got the same errors as before when running koha2marc.pl: ----- DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/ C4/Biblio.pm line 1284. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (,concat(942,k),4,2,999999,soundex(999999)) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/ C4/Biblio.pm line 468. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldo rder,subfieldvalue) values (,942,4, ,l,3,00) DBD::mysql::st execute failed: Column 'bibid' cannot be null at /home/stpauls/koha/intranet/modules/ C4/Biblio.pm line 1284. ERROR ==> insert into marc_word (bibid, tagsubfield, ta gorder, subfieldorder, word, sndx_word) values (,concat(942,l),4,3,00,soundex(00)) DBD::mysql::st execute failed: Column 'bibid' cannot be n ull at /home/stpauls/koha/intranet/modules/ C4/Biblio.pm line 468. ERROR ==> insert into marc_subfield_table (bibid,tag,tagorder,tag_indicator,subfieldcode,subfieldo rder,subfieldvalue) values (,260,5, ,a,1,20) ---- (Of course, that repeats hundreds of times). Any other ideas? Thanks so much for your help!
participants (4)
-
Chris Cormack -
Paul POULAIN -
Timothy R.Butler -
Timothy R.Butler