At 03:11 AM 12/28/2014 -0500, Mark Tompsett wrote:
Greetings, [snip]
Mark and all others, thanks. 3.18 now installed, OPAC and Staff pages appear as expected. "Web installer > Step 3 Updating database structure" appeared to go well (285 lines of updates) but with the five errors (minor?) at the end of this email. However, much more importantly, Zebra is non functional. Firstly, I tried the Wiki recommendation "koha-rebuild-zebra -v -f" but: Can't open perl script "koha-rebuild-zebra": No such file or directory [The file with it's dependences is still in the install directory, wasn't transferred during make install and will obviously not run from there: koha@hood:/usr/share/koha$ find -iname koha-rebuild-zebra ./koha-3.18.02/debian/scripts/koha-rebuild-zebra koha@hood:/usr/share/koha$ ./koha-3.18.02/debian/scripts/koha-rebuild-zebra -v -f Error: /usr/share/koha/bin/koha-functions.sh not present. ] So I reverted to the "old 3.8.5" method ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x (with and without the '-x') and ./bin/migration_tools/rebuild_zebra.pl -a -r -v, and after fixing the missing ..LCK directories and files, reindexing appears perfect (right number of biblios and authorities, goes through all the stages "exporting biblio", 35301.................................................................................................... Records exported: 35379 REINDEXING zebra CLEANING But -- both Staff and OPAC get _No results found_ (Staff gives the added "No results match your search for 'kw,wrdl: smith' in NMA Catalog" whereas 3.8.5 has "568 result(s) found for 'kw,wrdl: smith' in NMA Catalog. Thoughts anyone? Update db errors: Version: mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.3 [Mon Dec 29 10:50:01 2014] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'SuspendHoldsIntranet' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5335. [Mon Dec 29 10:50:01 2014] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'SuspendHoldsOpac' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5336. [Mon Dec 29 10:50:01 2014] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha18`.`message_transports`, CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5361. [Mon Dec 29 10:50:11 2014] updatedatabase.pl: DBD::mysql::db do failed: BLOB/TEXT column 'issn' used in key specification without a key length at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 8424. [Mon Dec 29 10:50:11 2014] updatedatabase.pl: DBD::mysql::db do failed: Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 8428. Best regards all round -- Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>