* Rachel Hollis (Rachel.Hollis@stevenshenager.edu) wrote:

Greetings friends, approximately two weeks ago one or more of the staff removed data from our Koha 3.01 database. We now have items separated from borrowers. As far as I can guess, the delete all items function was used while viewing biblios and items that were checked out were also deleted.

When viewing an affected borrower record, a due date appears but not item information. When browsing the catalog, the total number of items displays along with numbers available and numbers checked out but the numbers are not correct.

We can restore from a backup but we'd lose about two weeks worth of work. Is there another solution?

Yeah, you don't want to do that. For the immediate situation, set up a database (ie make a new one) mysqladmin -uroot -p create koha_restore Load the backup into there Now you have the items in a db, if you know the itemnumbers already you can just do this mysql -uroot -p koha_restore mysql> select * from items where itemnumber in (numbers,go,here) into outfile '/tmp/missingitems.txt'; mysql> quit; mysql -uroot -p koha mysql> load data infile '/tmp/missingitems.txt' into items; mysql> quit; Now you have the items in the items table, the borrower record will show the item. The only problem is, these items wont be in the MARC, so you wont be able to edit them etc. If you want them in the MARC there is a script in misc/maintenance called sync_items_in_marc_bib.pl which should fix that up for you. Please run that when the library is closed and after taking a backup. If you dont have a list of itemnumbers, you can get that list this way mysql -uroot -p koha mysql> select issues.itemnumber from issues left join items on (issues.itemnumber = items.itemnumber) where items.itemnumber is null; Hope this helps Chris

Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

-- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand