IRC log for #koha, 2008-01-14

All times shown according to UTC.

Time S Nick Message
13:27 martinmorris afternoon all
13:27 martinmorris i'm about to upgrade my test installation of koha 2.2 to koha 3 alpha
13:27 martinmorris and had one question before i got going
13:29 martinmorris ...which was merely, i've got the upgrade instructions from the koha website but am unsure about how i actually go about installing the koha 3 files themselves as opposed to upgrading yaz and zebra (which i have already done) - won't the installer ask me about databases and the like or do I just install the files and then go back to the upgrade instructions rather than gothrough the web installer?
15:34 martinmorris hi well i've made progress and updating the database from 2.2 to 3.0 - got a problem when running misc/migration_tools/22_to_3​0/move_marc_to_authheader.pl
15:34 martinmorris i get this error message:
15:34 martinmorris moving MARC record to marc_header table
15:34 martinmorris DBD::mysql::db do failed: Duplicate column name 'marcxml' at misc/migration_tools/22_to_3​0/move_marc_to_authheader.pl line 24.
15:34 martinmorris substr outside of string at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 498.
15:34 martinmorris Use of uninitialized value in string eq at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 500.
15:34 martinmorris Use of uninitialized value in string eq at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 500.
15:34 martinmorris Use of uninitialized value in string eq at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 500.
15:34 martinmorris Use of uninitialized value in concatenation (.) or string at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 505.
15:34 martinmorris Use of uninitialized value in concatenation (.) or string at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 505.
15:34 martinmorris Unsupported UNIMARC character encoding [] for XML output for UNIMARCAUTH; 100 -> Ne k at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 505.
15:34 martinmorris any ideas gratefully received
16:23 [K] *** join #koha@FreeNode: zsh n=zsh@41.223.57.33
16:42 martinmorris hello did anybody see my earlier question?
16:50 [K] *** part FreeNode!#koha: zsh n=zsh@41.223.57.33
16:59 hdl martinmorris ?
16:59 martinmorris hi hdl
16:59 hdl hi
17:00 hdl what is your marcflavour ?
17:00 martinmorris marc21
17:01 hdl is this set in your system prefrences ?
17:01 hdl Can you check ?
17:01 martinmorris i doubt i'll be able to log in n ow, i'm halfway through upgrading the database
17:01 martinmorris i'll try some sql and see though, but i'm 99.99% certain that was set in the previous database
17:01 hdl check it via mysql commandline.
17:02 martinmorris actually that was easier than i thought, yes it's marc21
17:02 hdl So
17:02 hdl Unsupported UNIMARC character encoding [] for XML output for UNIMARCAUTH; 100 -> Ne k at /usr/local/share/perl/5.8.8/MARC/File/XML.pm line 505.
17:02 hdl this error is UNIMARC specific.
17:03 hdl I donot think you should have it.
17:03 martinmorris it's weird isn't it
17:03 martinmorris mysql> select * from systempreferences where variable='marcflavour';
17:03 martinmorris +-------------+--------+---------------​-+-------------------------------------​-----------------------------+--------+
17:03 martinmorris | variable    | value  | options        | explanation                                                      | type   |
17:03 martinmorris +-------------+--------+---------------​-+-------------------------------------​-----------------------------+--------+
17:03 martinmorris | marcflavour | MARC21 | MARC21|UNIMARC | your MARC flavor (MARC21 or UNIMARC) used for character encoding | Choice |
17:03 martinmorris +-------------+--------+---------------​-+-------------------------------------​-----------------------------+--------+
17:03 martinmorris 1 row in set (0.00 sec)
17:06 hdl shoot.
17:06 hdl Found it.
17:06 hdl OK.
17:07 martinmorris oh yes?
17:07 hdl this is quite a weird thing.
17:08 hdl string is used quite an unusual way.
17:08 martinmorris in the perl program?
17:08 hdl Try and comment what concerns field 100 on lines 45-48
17:09 hdl and
17:09 hdl delete UNIMARCAUTH on line 64
17:09 martinmorris two secs
17:09 hdl delete "UNIMARCAUTH" on line 64
17:10 martinmorris do you  mean comment lines 45-47?  48 starts a new clause
17:10 hdl (talking about move_marc_2_authheader.
17:10 hdl martinmorris: yes
17:10 martinmorris ok done those, let's try again
17:12 martinmorris i think that may be ok, got an error because of column name marcxml (duplicate column name) but assume that's because it got that far before and was successful
17:12 martinmorris said 'done' at the end :) thanks
17:12 martinmorris while you're there, looks like a problem with the next command too
17:13 martinmorris root@daz:/home/martin/koha-3.00.00-alpha# misc/migration_tools/22_to​_30/rebuild_unimarc_100.pl
17:13 martinmorris Creating/updating field 100 if needed
17:13 martinmorris Wide character in null operation at /usr/local/share/perl/5.8.8/MARC/Charset/Table.pm line 96.
17:13 martinmorris that's becuse it's a unimarc command - ignore me :)
17:15 hdl yeah rebuild_unimarc_100 is UNIMARC only.
17:15 martinmorris hope running it hasn't damaged anything
17:18 hdl I hope for you too.
17:18 hdl did it take long to fail ?
17:19 hdl (100 for you is not coded field but authors.)
17:20 martinmorris no it failed pretty quickly
17:20 martinmorris and i've logged in to koha :)
17:21 martinmorris although i'm noticing that little info box on the left hadn side of the first page isn't there, and it was in my previous test install
17:22 hdl maybe a default text was not defined.
17:22 martinmorris i'm also noticing nothing is returned when i search the catalogue, hmm
17:45 martinmorris any ideas why that might be?
20:39 masonj morning #koha
07:22 [K] *** join #koha@FreeNode: zsh n=zsh@41.223.57.33
08:25 [K] *** join #koha@FreeNode: zsh n=zsh@41.223.57.34

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary