Try: rebuild_zebra.pl -b -a -r -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request@lists.katipo.co.nz Sent: Wednesday, September 15, 2010 11:40 AM To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 59, Issue 28 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: branchcodes and case sensitivity (Galen Charlton) 2. rebuild_zebra errors (Ata ur Rehman) 3. Re: rebuild_zebra errors (Zico) ---------------------------------------------------------------------- Message: 1 Date: Wed, 15 Sep 2010 12:01:51 -0400 From: Galen Charlton <gmc@esilibrary.com> Subject: Re: [Koha] branchcodes and case sensitivity To: Chris Hobbs <chobbs@nhusd.k12.ca.us> Cc: koha@lists.katipo.co.nz Message-ID: <1993A2CD-DAB0-4462-95CD-4CDEBAF24324@esilibrary.com> Content-Type: text/plain; charset=us-ascii Hi, On Sep 3, 2010, at 4:03 PM, Chris Hobbs wrote:
The obvious fix would be to simply set branchcode to LOWER(branchcode) in the back end, but the foreign key constraint prevents me from doing so through mysql.
A longer-term fix would be to figure out why it's not setting the branchcode correctly, but as far as cascading the update of branchcode is concerned, you could either alter the constraints to cascade updates or take advantage of MySQL's ability to disable foreign key checks temporarily: SET FOREIGN_KEY_CHECKS = 0; update branches set branchcode = lower(branchcode); -- update tables that reference to branchcode SET FOREIGN_KEY_CHECKS = 1; Obviously something like this would call for doing a full backup first. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/ ------------------------------ Message: 2 Date: Wed, 15 Sep 2010 23:33:49 +0500 From: Ata ur Rehman <ata.rehman@gmail.com> Subject: [Koha] rebuild_zebra errors To: Koha Mailing List <koha@lists.katipo.co.nz> Message-ID: <AANLkTi=wRYJavWPQs=Yh2nPChxi5ELbeE96fiAHGb8dd@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Dear All I imported records using Koha Tool>Staged utility. It was successful witout any error. When I rebuil_zebra using the following command I got the un expected output that is given below. Can someone tell me what it means? I am using Koha 3.00.06.010 with Ubuntu 10.04 Ata p:~/bin/migration_tools$ ./rebuild_zebra.pl -b -w -r 23:17:30-15/09 zebraidx(7735) [warn] Unknown register type: 0 23:17:30-15/09 zebraidx(7735) [warn] Unknown register type: n 23:17:30-15/09 zebraidx(7735) [warn] Unknown register type: y 23:17:30-15/09 zebraidx(7735) [warn] Unknown register type: d *** stack smashing detected ***: zebraidx terminated ======= Backtrace: ========= /lib/tls/i686/cmov/libc.so.6(__fortify_fail+0x50)[0xf4b390] /lib/tls/i686/cmov/libc.so.6(+0xe233a)[0xf4b33a] /usr/lib/libidzebra-2.0.so.0(+0x71fd4)[0x59ffd4] /usr/lib/libidzebra-2.0.so.0(+0x17b45)[0x545b45] [0x0] ======= Memory map: ======== 00110000-00234000 r-xp 00000000 08:05 180423 /usr/lib/libxml2.so.2.7.6 00234000-00238000 r--p 00123000 08:05 180423 /usr/lib/libxml2.so.2.7.6 00238000-00239000 rw-p 00127000 08:05 180423 /usr/lib/libxml2.so.2.7.6 00239000-0023a000 rw-p 00000000 00:00 0 0023a000-0024b000 r-xp 00000000 08:05 168742 /usr/lib/libexslt.so.0.8.15 0024b000-0024c000 r--p 00010000 08:05 168742 /usr/lib/libexslt.so.0.8.15 0024c000-0024d000 rw-p 00011000 08:05 168742 /usr/lib/libexslt.so.0.8.15 00251000-00252000 r-xp 00000000 00:00 0 [vdso] 00252000-0030f000 r-xp 00000000 08:05 168764 /usr/lib/libyaz.so.3.0.0 0030f000-00310000 r--p 000bd000 08:05 168764 /usr/lib/libyaz.so.3.0.0 00310000-003b1000 rw-p 000be000 08:05 168764 /usr/lib/libyaz.so.3.0.0 003b1000-00447000 r-xp 00000000 08:05 169256 /usr/lib/libgnutls.so.26.14.12 00447000-0044b000 r--p 00095000 08:05 169256 /usr/lib/libgnutls.so.26.14.12 0044b000-0044c000 rw-p 00099000 08:05 169256 /usr/lib/libgnutls.so.26.14.12 0044c000-00482000 r-xp 00000000 08:05 169287 /usr/lib/libxslt.so.1.1.26 00482000-00483000 r--p 00035000 08:05 169287 /usr/lib/libxslt.so.1.1.26 00483000-00484000 rw-p 00036000 08:05 169287 /usr/lib/libxslt.so.1.1.26 00484000-004f4000 r-xp 00000000 08:05 3799 /lib/libgcrypt.so.11.5.2 004f4000-004f5000 r--p 00070000 08:05 3799 /lib/libgcrypt.so.11.5.2 004f5000-004f7000 rw-p 00071000 08:05 3799 /lib/libgcrypt.so.11.5.2 004f7000-0050a000 r-xp 00000000 08:05 170151 /lib/tls/i686/cmov/ libnsl-2.11.1.so 0050a000-0050b000 r--p 00012000 08:05 170151 /lib/tls/i686/cmov/ libnsl-2.11.1.so 0050b000-0050c000 rw-p 00013000 08:05 170151 /lib/tls/i686/cmov/ libnsl-2.11.1.so 0050c000-0050e000 rw-p 00000000 00:00 0 0050e000-0052b000 r-xp 00000000 08:05 2685 /lib/libgcc_s.so.1 0052b000-0052c000 r--p 0001c000 08:05 2685 /lib/libgcc_s.so.1 0052c000-0052d000 rw-p 0001d000 08:05 2685 /lib/libgcc_s.so.1 0052e000-005a9000 r-xp 00000000 08:05 167960 /usr/lib/libidzebra-2.0.so.0.0.1 005a9000-005aa000 r--p 0007a000 08:05 167960 /usr/lib/libidzebra-2.0.so.0.0.1 005aa000-005ab000 rw-p 0007b000 08:05 167960 /usr/lib/libidzebra-2.0.so.0.0.1 005ab000-005ac000 rw-p 00000000 00:00 0 005ac000-006e3000 r-xp 00000000 08:05 173309 /usr/lib/libicuuc.so.42.1 006e3000-006e4000 ---p 00137000 08:05 173309 /usr/lib/libicuuc.so.42.1 006e4000-006ec000 r--p 00137000 08:05 173309 /usr/lib/libicuuc.so.42.1 006ec000-006ee000 rw-p 0013f000 08:05 173309 /usr/lib/libicuuc.so.42.1 006ee000-006f0000 rw-p 00000000 00:00 0 006f0000-006f3000 r-xp 00000000 08:05 169270 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 006f3000-006f4000 r--p 00002000 08:05 169270 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 006f4000-006f5000 rw-p 00003000 08:05 169270 /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 006f5000-00719000 r-xp 00000000 08:05 3718 /lib/libexpat.so.1.5.2 00719000-0071b000 r--p 00024000 08:05 3718 /lib/libexpat.so.1.5.2 0071b000-0071c000 rw-p 00026000 08:05 3718 /lib/libexpat.so.1.5.2 0071c000-00720000 r-xp 00000000 08:05 200384 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 00720000-00721000 r--p 00004000 08:05 200384 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 00721000-00722000 rw-p 00005000 08:05 200384 /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 00722000-00737000 r-xp 00000000 08:05 170159 /lib/tls/i686/cmov/ libpthread-2.11.1.so 00737000-00738000 r--p 00014000 08:05 170159 /lib/tls/i686/cmov/ libpthread-2.11.1.so 00738000-00739000 rw-p 00015000 08:05 170159 /lib/tls/i686/cmov/ libpthread-2.11.1.so 00739000-0073b000 rw-p 00000000 00:00 0 0073b000-0073e000 r-xp 00000000 08:05 169262 /usr/lib/idzebra-2.0/modules/mod-alvis.so 0073e000-0073f000 r--p 00002000 08:05 169262 /usr/lib/idzebra-2.0/modules/mod-alvis.so 0073f000-00740000 rw-p 00003000 08:05 169262 /usr/lib/idzebra-2.0/modules/mod-alvis.so 00740000-00746000 r-xp 00000000 08:05 168558 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 00746000-00747000 r--p 00005000 08:05 168558 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 00747000-00748000 rw-p 00006000 08:05 168558 /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 00798000-007bc000 r-xp 00000000 08:05 170149 /lib/tls/i686/cmov/ libm-2.11.1.so 007bc000-007bd000 r--p 00023000 08:05 170149 /lib/tls/i686/cmov/ libm-2.11.1.so 007bd000-007be000 rw-p 00024000 08:05 170149 /lib/tls/i686/cmov/ libm-2.11.1.so 00855000-0085e000 r-xp 00000000 08:05 170147 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 0085e000-0085f000 r--p 00008000 08:05 170147 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 0085f000-00860000 rw-p 00009000 08:05 170147 /lib/tls/i686/cmov/ libcrypt-2.11.1.so 00860000-00887000 rw-p 00000000 00:00 0 00887000-00937000 r-xp 00000000 08:05 200380 /usr/lib/libtcl8.4.so.0 00937000-00938000 ---p 000b0000 08:05 200380 /usr/lib/libtcl8.4.so.0 00938000-00939000 r--p 000b0000 08:05 200380 /usr/lib/libtcl8.4.so.0 00939000-0093e000 rw-p 000b1000 08:05 200380 /usr/lib/libtcl8.4.so.0 0095d000-00978000 r-xp 00000000 08:05 6164 /lib/ld-2.11.1.so 00978000-00979000 r--p 0001a000 08:05 6164 /lib/ld-2.11.1.so 00979000-0097a000 rw-p 0001b000 08:05 6164 /lib/ld-2.11.1.so 0097a000-00a63000 r-xp 00000000 08:05 169043 /usr/lib/libstdc++.so.6.0.13 00a63000-00a64000 ---p 000e9000 08:05 169043 /usr/lib/libstdc++.so.6.0.13 00a64000-00a68000 r--p 000e9000 08:05 169043 /usr/lib/libstdc++.so.6.0.13 00a68000-00a69000 rw-p 000ed000 08:05 169043 /usr/lib/libstdc++.so.6.0.13 00a69000-00a70000 rw-p 00000000 00:00 0 00b04000-00b0b000 r-xp 00000000 08:05 4244 /lib/libwrap.so.0.7.6 00b0b000-00b0c000 r--p 00006000 08:05 4244 /lib/libwrap.so.0.7.6 00b0c000-00b0d000 rw-p 00007000 08:05 4244 /lib/libwrap.so.0.7.6 00b76000-00b86000 r-xp 00000000 08:05 29 /lib/libbz2.so.1.0.4 00b86000-00b87000 r--p 0000f000 08:05 29 /lib/libbz2.so.1.0.4 00b87000-00b88000 rw-p 00010000 08:05 29 /lib/libbz2.so.1.0.4 00b9d000-00bb0000 r-xp 00000000 08:05 2858 /lib/libz.so.1.2.3.3 00bb0000-00bb1000 r--p 00012000 08:05 2858 /lib/libz.so.1.2.3.3 00bb1000-00bb2000 rw-p 00013000 08:05 2858 /lib/libz.so.1.2.3.3 00cac000-00cae000 r-xp 00000000 08:05 170148 /lib/tls/i686/cmov/libdl-2.11.1 p:~/bin/migration_tools$