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
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
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
Seth Mayo <smayo@stpeters.nsw.edu.au> writes:
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.pl line 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.pl line 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.pl line 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.pl line 4221.
I got only the first two ... I was upgrading from from 3.000.107 to 3.4.1. -- Mahesh T. Pai ||
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.
We lost our ability to search on barcodes after updating to 3.4 Still haven't regained it. Titles work, thank goodness. On Mon, Jun 20, 2011 at 3:56 PM, Fred Pierre <fred.pierre@smfpl.org> wrote:
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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Seth Mayo <smayo@stpeters.nsw.edu.au> writes:
The second needed to be run in sudo because of permission errors.
Isn't that supposed to be run as same user as owner of the koha database?
misc/maintenance/remove_items_from_biblioitems.pl --run misc/migration_tools/rebuild_zebra.pl -b -r
-- Mahesh T. Pai || Man's most judicious trait, is a good sense of what not to believe. --Euripides
participants (4)
-
Elaine Bradtke -
Fred Pierre -
Mahesh T Pai -
Seth Mayo