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

We are having a similar problem: After updating from 3.0 to 3.2, items that were barcode-searchable are no longer found. Older items seem to be unaffected while newer items all show up missing. However I can find the item using a php-based custom script. However the item will not search by title or barcode. Odd, huh? -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-after-upgrade-to-3-4-1-tp4505942p4... Sent from the Koha - Discuss mailing list archive at Nabble.com.