[Koha-devel] 3.18 install [was: koha-common install]

[Paul A]

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 at hood:/usr/share/koha$ find -iname koha-rebuild-zebra
./koha-3.18.02/debian/scripts/koha-rebuild-zebra
koha at 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>