[Koha] Indexing not working after upgrade
Hugo Agud
hagud at orex.es
Thu Jul 12 01:52:19 NZST 2018
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.
More information about the Koha
mailing list