[Koha] Problem after upgrade to 3.4.1

[Seth Mayo]

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...

Update errors :

   - [Mon Jun 20 22:07:21 2011] updatedatabase.pl: DBD::mysql::db do failed:
   Duplicate column name 'privacy' at
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3998.
   - [Mon Jun 20 22:07:21 2011] updatedatabase.pl: DBD::mysql::db do failed:
   Duplicate column name 'privacy' at
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
3999.
   - [Mon Jun 20 22:07:22 2011] updatedatabase.pl: DBD::mysql::db do failed:
   Can't DROP 'itemsstocknumberidx'; check that column/key exists at
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
4220.
   - [Mon Jun 20 22:07:22 2011] updatedatabase.pl: DBD::mysql::db do failed:
   Duplicate key name 'itemstocknumberidx' at
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.plline
4221.



Seth Mayo
IT Technical Manager
Email:  smayo at stpeters.nsw.edu.au
-------------------------------------------------------
St Peter's Anglican Primary School
Howe Street
Campbelltown NSW 2560
PH: 02 4627 2990
DID:  02 8203 1368
Website:  http://www.stpeters.nsw.edu.au




On 20 June 2011 21:52, Seth Mayo <smayo at stpeters.nsw.edu.au> wrote:

> 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?
>
> Regards,
>
>
> Seth Mayo
> IT Technical Manager
> Email:  smayo at stpeters.nsw.edu.au
> -------------------------------------------------------
> St Peter's Anglican Primary School
> Howe Street
> Campbelltown NSW 2560
> PH: 02 4627 2990
> DID:  02 8203 1368
> Website:  http://www.stpeters.nsw.edu.au
>
>
>
>
> On 20 June 2011 21:05, Seth Mayo <smayo at stpeters.nsw.edu.au> wrote:
>
>> 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.
>>
>>  misc/maintenance/remove_items_from_biblioitems.pl --run
>>  misc/migration_tools/rebuild_zebra.pl -b -r
>>
>> 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???
>>
>> Note: I ran these scripts from /usr/share/koha/maintenance &
>> /usr/share/koha/migration_tools as misc/ didn't have these there...
>>
>> Seth Mayo
>> IT Technical Manager
>> Email:  smayo at stpeters.nsw.edu.au
>> -------------------------------------------------------
>> St Peter's Anglican Primary School
>> Howe Street
>> Campbelltown NSW 2560
>> PH: 02 4627 2990
>> DID:  02 8203 1368
>> Website:  http://www.stpeters.nsw.edu.au
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110620/86403c07/attachment.htm