I've also just noticed that I get the following when the web interface upgrade occurs...I don't know if it has any relation or not though as the interface works fine and records come up in results fine until the reindex occurs. I've also tried the two commands before the web install and it gives the same result - no results return on any searches...<br>
<br><p>Update errors :</p>
<ul><li class="update_error">[Mon Jun 20 22:07:21 2011]
<a href="http://updatedatabase.pl">updatedatabase.pl</a>: DBD::mysql::db do failed: Duplicate column name
'privacy' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/<a href="http://updatedatabase.pl">updatedatabase.pl</a>
line 3998.</li><li class="update_error">[Mon Jun 20 22:07:21 2011]
<a href="http://updatedatabase.pl">updatedatabase.pl</a>: DBD::mysql::db do failed: Duplicate column name
'privacy' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/<a href="http://updatedatabase.pl">updatedatabase.pl</a>
line 3999.</li><li class="update_error">[Mon Jun 20 22:07:22 2011]
<a href="http://updatedatabase.pl">updatedatabase.pl</a>: DBD::mysql::db do failed: Can't DROP
'itemsstocknumberidx'; check that column/key exists at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/<a href="http://updatedatabase.pl">updatedatabase.pl</a>
line 4220.</li><li class="update_error">[Mon Jun 20 22:07:22 2011]
<a href="http://updatedatabase.pl">updatedatabase.pl</a>: DBD::mysql::db do failed: Duplicate key name
'itemstocknumberidx' at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/<a href="http://updatedatabase.pl">updatedatabase.pl</a>
line 4221.</li></ul><br><br clear="all">Seth Mayo<br>IT Technical Manager<br>Email: <a href="mailto:smayo@stpeters.nsw.edu.au" target="_blank">smayo@stpeters.nsw.edu.au</a><br>-------------------------------------------------------<br>
St Peter's Anglican Primary School<br>Howe Street<br>Campbelltown NSW 2560<br>PH: 02 4627 2990<br>DID: 02 8203 1368<br>Website: <a href="http://www.stpeters.nsw.edu.au" target="_blank">http://www.stpeters.nsw.edu.au</a><br>
<br><br>
<br><br><div class="gmail_quote">On 20 June 2011 21:52, Seth Mayo <span dir="ltr"><<a href="mailto:smayo@stpeters.nsw.edu.au">smayo@stpeters.nsw.edu.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Alternatively - can anyone offer advice as to whether it is a problem to leave Koha in an upgraded state where these two commands have not been executed? I've noted that Koha seems fine before I execute these two commands...but would it be fine in the long term? Would there be any data mess created if the library was to start using it again without the items table removal and zebra re-indexed?<br>
<br>Regards,<div class="im"><br><br clear="all">Seth Mayo<br>IT Technical Manager<br>Email: <a href="mailto:smayo@stpeters.nsw.edu.au" target="_blank">smayo@stpeters.nsw.edu.au</a><br>-------------------------------------------------------<br>
St Peter's Anglican Primary School<br>Howe Street<br>Campbelltown NSW 2560<br>PH: 02 4627 2990<br>DID: 02 8203 1368<br>Website: <a href="http://www.stpeters.nsw.edu.au" target="_blank">http://www.stpeters.nsw.edu.au</a><br>
<br><br>
<br><br></div><div><div></div><div class="h5"><div class="gmail_quote">On 20 June 2011 21:05, Seth Mayo <span dir="ltr"><<a href="mailto:smayo@stpeters.nsw.edu.au" target="_blank">smayo@stpeters.nsw.edu.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I finished upgrading to Koha 3.4.1 and then realised that I had missed the following two lines in the README.ubuntu file. So I've now executed them. The second needed to be run in sudo because of permission errors.<br>
<br> misc/maintenance/<a href="http://remove_items_from_biblioitems.pl" target="_blank">remove_items_from_biblioitems.pl</a> --run<br> misc/migration_tools/<a href="http://rebuild_zebra.pl" target="_blank">rebuild_zebra.pl</a> -b -r<br>
<br>Now after running these, we have no records appearing in any searches anywhere! Any ideas or things to try? Considering that the second is a zebra rebuild I'm guessing it didn't rebuild correctly???<br>
<br>Note: I ran these scripts from /usr/share/koha/maintenance & /usr/share/koha/migration_tools as misc/ didn't have these there...<br><br clear="all">Seth Mayo<br>IT Technical Manager<br>Email: <a href="mailto:smayo@stpeters.nsw.edu.au" target="_blank">smayo@stpeters.nsw.edu.au</a><br>
-------------------------------------------------------<br>St Peter's Anglican Primary School<br>Howe Street<br>Campbelltown NSW 2560<br>PH: 02 4627 2990<br>DID: 02 8203 1368<br>Website: <a href="http://www.stpeters.nsw.edu.au" target="_blank">http://www.stpeters.nsw.edu.au</a><br>
<br><br>
</blockquote></div><br>
</div></div></blockquote></div><br>