[Koha] Indexing not working after upgrade
Alvaro Cornejo
cornejo.alvaro at gmail.com
Thu Jul 12 02:45:50 NZST 2018
Hi
Marc data has been moved to biblio_metadata sometime between 16.x and 17.x.
There is a process to convert databases between both versions.
Check installation manual for details.
Sorry for not to be more specific.
Regards,
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
Visitenos en www.perusms.com
2018-07-11 9:05 GMT-05:00 Suresh Kumar Tejomurtula <tejoskumar at gmail.com>:
> Hi
>
> Thank you for the reply. Data is available in biblio and biblioitems.
>
> But, biblio_metadata table is empty.
>
>
>
> The same SQL dump is working fine upto 16.11 and 17.05 onwards this error.
>
> Regards
> T Suresh Kumar
>
>
>
>
>
> On Wed 11 Jul, 2018, 19:22 Hugo Agud, <hagud at orex.es> wrote:
>
> > Hi
> >
> > I think there are separate errors...
> >
> > club_enrollment is fixed with manual corrections.
> > on bug 17135 It not related with zebra index
> >
> > errors retreiving biblio, please checkif the data is in biblio,
> > biblioitems and biblio_metada -->, once the info is there check the Koha
> > framework, for a testing purpouses move all records framework to default
> > and try to reindex again
> >
> > I guess you know how to assing all records to default framework right?
> >
> > reindex again
> >
> > 2018-07-11 15:40 GMT+02:00 Suresh Kumar Tejomurtula <
> tejoskumar at gmail.com>
> > :
> >
> >> Dear all,
> >>
> >> Could any one help me on how to solve the below issue with my database:
> >>
> >>
> >> ------------------------------------------------------------
> --------------------------------------------------
> >>
> >> I installed koha 17.11 in a fresh PC as per the instructions at -
> >> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages and
> >> successfully installed. When I try to index it is working after creating
> >> few test records.
> >>
> >> Iam able to import data from koha version 16.05(Installed on 14.04
> ubuntu
> >> and with mysql) to 17.11(16.04 ubuntu and mariadb) and issue / returns
> >> etc...are working and during installation the following warnings /
> errors
> >> i
> >> noticed during import / upgrade.
> >>
> >> -----
> >>
> >> Attempting upgrade to 16.06.00.028 (Bug 17135) ...
> >> DBD::mysql::st execute failed: Unknown column 'me.no_auto_renewal_after'
> >> in
> >> 'field list' [for Statement "SELECT `me`.`categorycode`,
> `me`.`itemtype`,
> >> `me`.`restrictedtype`, `me`.`rentaldiscount`, `me`.`reservecharge`,
> >> `me`.`fine`, `me`.`finedays`, `me`.`maxsuspensiondays`,
> >> `me`.`firstremind`,
> >> `me`.`chargeperiod`, `me`.`chargeperiod_charge_at`, `me`.`accountsent`,
> >> `me`.`chargename`, `me`.`maxissueqty`, `me`.`maxonsiteissueqty`,
> >> `me`.`issuelength`, `me`.`lengthunit`, `me`.`hardduedate`,
> >> `me`.`hardduedatecompare`, `me`.`renewalsallowed`, `me`.`renewalperiod`,
> >> `me`.`norenewalbefore`, `me`.`auto_renew`, `me`.`no_auto_renewal_after`,
> >> `me`.`no_auto_renewal_after_hard_limit`, `me`.`reservesallowed`,
> >> `me`.`holds_per_record`, `me`.`branchcode`, `me`.`overduefinescap`,
> >> `me`.`cap_fine_to_replacement_price`, `me`.`onshelfholds`,
> >> `me`.`opacitemholds`, `me`.`article_requests` FROM `issuingrules` `me`
> >> WHERE ( ( `branchcode` IN ( ?, ? ) AND `categorycode` IN ( ?, ? ) AND
> >> `itemtype` IN ( ?, ? ) ) ) ORDER BY `branchcode` DESC, `categorycode`
> >> DESC,
> >> `itemtype` DESC LIMIT ?" with ParamValues: 0='IC-ARDC', 1='*', 2='PT',
> >> 3='*', 4='BK', 5='*', 6=1] at /usr/share/perl5/DBIx/Class/
> Storage/DBI.pm
> >> line 1834.
> >> DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
> >> 'me.no_auto_renewal_after' in 'field list' at
> >> /usr/share/koha/lib/Koha/Objects.pm
> >> line 191
> >> Upgrade to 16.06.00.028 done (Bug 17135 - Fine for the previous overdue
> >> may
> >> get overwritten by the next one)
> >> WARNING: There is a possibility (= just a possibility, it's
> configuration
> >> dependent etc.) that - due to regression introduced by Bug 15675 - some
> >> old
> >> fine records for overdued items (items which got renewed 1+ time while
> >> being overdue) may have been overwritten in your production 16.05+
> >> database. See Bugzilla reports for Bug 14390 and Bug 17135 for more
> >> details.
> >> WARNING: Please note that this upgrade does not try to recover such
> >> overwitten old fine records (if any) - it's just an follow-up for Bug
> >> 14390, its sole purpose is preventing eventual further-on overwrites
> from
> >> happening in the future. Optional recovery of the overwritten fines
> >> (again,
> >> if any) is like, totally outside of the scope of this particular
> upgrade!
> >> Upgrade to 16.06.00.029 done (Bug 14707 - Change UsageStatsCountry from
> >> free text to a dropdown list)
> >>
> >> --------------------------------------------------------------------
> >>
> >> Upgrade to 16.06.00.038 done (Bug 14874 - Add ability to search for
> >> patrons
> >> by date of birth from checkout and patron quick searches)
> >> item-level_itypes set but no itype defined for item (201671) at
> >> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> >> line
> >> 13447.
> >> item-level_itypes set but no itype defined for item (39020) at
> >> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> >> line
> >> 13447.
> >> item-level_itypes set but no itype defined for item (90632) at
> >> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> >> line
> >> 13447.
> >> item-level_itypes set but no itype defined for item (1967) at
> >> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> >> line
> >> 13447.
> >> Upgrade to 16.06.00.039 done (Bug 14598: itemtype is not set on
> statistics
> >> by C4::Circulation::AddReturn)
> >>
> >> -------------------------
> >> U
> >> pgrade to 16.12.00.003 done (Bug 17486 - Remove 'Mozilla Persona' as an
> >> authentication method)
> >> DBD::mysql::db do failed: Duplicate entry '700-marcxml-CHANGEME' for key
> >> 'biblio_metadata_uniq_key' [for Statement "
> >> INSERT INTO biblio_metadata ( biblionumber, format, marcflavour,
> >> metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM
> >> biblioitems;
> >> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
> >> edatabase.pl line 13819.
> >> DBD::mysql::db do failed: Cannot add or update a child row: a foreign
> key
> >> constraint fails (`koha_library`.`deletedbiblio_metadata`, CONSTRAINT
> >> `deletedbiblio_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES
> >> `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE)
> [for
> >> Statement "
> >> INSERT INTO deletedbiblio_metadata ( biblionumber, format,
> >> marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME',
> >> marcxml
> >> FROM deletedbiblioitems;
> >> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
> >> edatabase.pl line 13822.
> >> Upgrade to 16.12.00.004 done (Bug 17196 - Move marcxml out of the
> >> biblioitems table)
> >>
> >> -----------------------------------------------------------------
> >>
> >> Upgrade to 16.12.00.026 done (Bug 18427 - Add a primary key to
> >> serialitems)
> >> DBD::mysql::db do failed: Invalid default value for 'date_created' [for
> >> Statement "
> >> CREATE TABLE IF NOT EXISTS club_enrollments (
> >> id int(11) NOT NULL AUTO_INCREMENT,
> >> club_id int(11) NOT NULL,
> >> borrowernumber int(11) NOT NULL,
> >> date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
> >> date_canceled timestamp NULL DEFAULT NULL,
> >> date_created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
> >> date_updated timestamp NULL DEFAULT NULL,
> >> branchcode varchar(10) NULL DEFAULT NULL,
> >> PRIMARY KEY (id),
> >> KEY club_id (club_id),
> >> KEY borrowernumber (borrowernumber),
> >> KEY branchcode (branchcode),
> >> CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id)
> >> REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE,
> >> CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY
> (borrowernumber)
> >> REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE
> CASCADE,
> >> CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode)
> >> REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE
> >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
> >> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
> >> edatabase.pl line 14194.
> >> DBD::mysql::db do failed: Can't create table
> >> `koha_library`.`club_enrollment_fields`
> >> (errno: 150 "Foreign key constraint is incorrectly formed") [for
> >> Statement "
> >> CREATE TABLE IF NOT EXISTS club_enrollment_fields (
> >> id int(11) NOT NULL AUTO_INCREMENT,
> >> club_enrollment_id int(11) NOT NULL,
> >> club_template_enrollment_field_id int(11) NOT NULL,
> >> `value` text NOT NULL,
> >> PRIMARY KEY (id),
> >> KEY club_enrollment_id (club_enrollment_id),
> >> KEY club_template_enrollment_field_id
> (club_template_enrollment_
> >> field_id),
> >> CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY
> >> (club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE
> ON
> >> UPDATE CASCADE,
> >> CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY
> >> (club_template_enrollment_field_id) REFERENCES
> >> club_template_enrollment_fields
> >> (id) ON DELETE CASCADE ON UPDATE CASCADE
> >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
> >> "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat
> >> edatabase.pl line 14227.
> >> Upgrade to 16.12.00.027 done (Bug 12461 - Add patron clubs feature)
> >>
> >>
> >> ---------------------------------------------
> >>
> >> During upgrade Club_enrollments table was not added.
> >> So I added the table manually using the above mysql statement in the
> >> error.
> >> Then I was able to go to do transactions in koha.
> >>
> >> --------------------------------
> >>
> >> Then after running the below command iam getting the below error and
> >> indexing not working.
> >>
> >> ----------------------------------------------
> >>
> >> sudo su
> >> sudo koha-rebuild-zebra -b -f -v library
> >>
> >> ----------------------------------------------
> >>
> >> Zebra configuration information
> >>
> >> ================================
> >>
> >> Zebra biblio directory = /var/lib/koha/library/biblios
> >> Zebra authorities directory = /var/lib/koha/library/authorities
> >> Koha directory = /usr/share/koha/intranet/cgi-bin
> >> Lockfile = /var/lock/koha/library/
> rebuild/rebuild..LCK
> >> BIBLIONUMBER in : 999$c
> >> BIBLIOITEMNUMBER in : 999$d
> >> ================================
> >>
> >> skipping authorities
> >>
> >> ====================
> >>
> >> exporting biblio
> >>
> >> ====================
> >>
> >> 1error retrieving biblio 1 at /usr/share/koha/bin/migration_tools/
> >> rebuild_zebra.pl line 683
> >> .
> >>
> >> .
> >> .
> >> error retrieving biblio 303876 at /usr/share/koha/bin/migration_tools/
> >> rebuild_zebra.pl line 683.
> >> ....
> >>
> >> Records exported: 0
> >> ====================
> >> REINDEXING zebra
> >> ====================
> >> ====================
> >> CLEANING
> >> ====================
> >> Zebra configuration information
> >> ================================
> >> Zebra biblio directory = /var/lib/koha/library/biblios
> >> Zebra authorities directory = /var/lib/koha/library/authorities
> >> Koha directory = /usr/share/koha/intranet/cgi-bin
> >> Lockfile = /var/lock/koha/library/
> rebuild/rebuild..LCK
> >> BIBLIONUMBER in : 999$c
> >> BIBLIOITEMNUMBER in : 999$d
> >> ================================
> >> ====================
> >> exporting authority
> >> ====================
> >> 1............
> >> Records exported: 13
> >> ====================
> >> REINDEXING zebra
> >> ====================
> >> skipping biblios
> >> ====================
> >> CLEANING
> >> ====================
> >>
> >> After this i installed koha 16.05 in 16.04 ubuntu, imported the data
> into
> >> the installation and then from that i tried to port it to 17.11
> >> installation and still the same iam getting the same error. Could any
> one
> >> help me on how to resolve this.
> >>
> >> Thanks in advance.
> >>
> >>
> >>
> >> --
> >> Regards
> >> T. Suresh Kumar
> >> _______________________________________________
> >> Koha mailing list http://koha-community.org
> >> Koha at lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> >
> >
> > --
> >
> > *Hugo Agud - Orex Digital *
> >
> > *www.orex.es <http://www.orex.es>*
> >
> >
> > <http://www.orex.es/> [image: www.orex.es/koha]
> > <http://www.orex.es/koha> [image: www.orex.es/vufind]
> > <http://www.orex.es/vufind>
> >
> >
> > Director
> >
> > Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 -
> Barcelona
> > - Tel: 933 856 138 hagud at orex.es · http://www.orex.es/
> >
> >
> >
> > No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
> > implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
> >
> >
> >
> > Aviso de confidencialidad
> > Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
> > RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
> > está autorizado a recibirlo por el remitente), no está autorizado a
> > copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido
> este
> > mensaje
> > por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
> > sistema.
> >
> >
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
More information about the Koha
mailing list