From chris@katipo.co.nz Sat May 7 03:00:34 2005 Return-Path: <chris@katipo.co.nz> Delivered-To: chris@wilbur.katipo.co.nz Received: (qmail 10039 invoked from network); 6 May 2005 15:00:34 -0000 Received: from unknown (HELO shelob.katipo.co.nz) (202.50.109.222) by wilbur.katipo.co.nz with SMTP; 6 May 2005 15:00:34 -0000 Received: by shelob.katipo.co.nz (Postfix, from userid 1001) id 6C6B984A3D; Sat, 7 May 2005 03:00:34 +1200 (NZST) X-Original-To: chris@katipo.co.nz Delivered-To: chris@katipo.co.nz Received: from localhost (localhost [127.0.0.1]) by shelob.katipo.co.nz (Postfix) with ESMTP id 2A3FD84A3C; Sat, 7 May 2005 03:00:23 +1200 (NZST) Received: from shelob.katipo.co.nz ([127.0.0.1]) by localhost (staff.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13335-07; Sat, 7 May 2005 03:00:23 +1200 (NZST) Received: from daddy-mx.katipo.co.nz (daddy.katipo.co.nz [202.50.109.200]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by shelob.katipo.co.nz (Postfix) with ESMTP; Sat, 7 May 2005 03:00:23 +1200 (NZST) Received: from localhost (localhost.katipo.co.nz [127.0.0.1]) by daddy-mx.katipo.co.nz (Postfix) with ESMTP id 3E75DE6EDC; Sat, 7 May 2005 02:57:58 +1200 (NZST) Received: from daddy-mx.katipo.co.nz ([127.0.0.1]) by localhost (daddy.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01430-05; Sat, 7 May 2005 02:57:57 +1200 (NZST) Received: from localhost.katipo.co.nz (localhost.katipo.co.nz [127.0.0.1]) by daddy-mx.katipo.co.nz (Postfix) with ESMTP; Sat, 7 May 2005 02:57:57 +1200 (NZST) Received: from localhost (localhost.katipo.co.nz [127.0.0.1]) by daddy-mx.katipo.co.nz (Postfix) with ESMTP id 235B7E6E83 for <koha@lists.katipo.co.nz>; Sat, 7 May 2005 02:57:52 +1200 (NZST) Received: from daddy-mx.katipo.co.nz ([127.0.0.1]) by localhost (daddy.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01651-04 for <koha@lists.katipo.co.nz>; Sat, 7 May 2005 02:57:50 +1200 (NZST) Received: from mplcat1.meadvillelibrary.org (mail.meadvillelibrary.org [162.39.22.227]) by daddy-mx.katipo.co.nz (Postfix) with SMTP for <koha@lists.katipo.co.nz>; Sat, 7 May 2005 02:57:50 +1200 (NZST) Received: (qmail 62773 invoked from network); 6 May 2005 15:00:04 -0000 Received: from localhost (HELO mplcat1.meadvillelibrary.org) (127.0.0.1) by localhost with SMTP; 6 May 2005 15:00:04 -0000 Received: from shadowfax (tapeserver.lib [162.39.22.226]) by mplcat1.meadvillelibrary.org (tmda-ofmipd) with ESMTP; Fri, 06 May 2005 11:00:03 -0400 (EDT) To: koha@lists.katipo.co.nz Date: Fri, 6 May 2005 11:00:02 -0400 User-Agent: KMail/1.7.2 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200505061100.02605.cmurdock@ccfls.org> From: "c. murdock" <cmurdock@ccfls.org> X-Delivery-Agent: TMDA/0.80 (Determine) X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz Subject: [Koha] cleaning materials out of database? X-BeenThere: koha@lists.katipo.co.nz X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussion list for the Koha Library system <koha.lists.katipo.co.nz> List-Unsubscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=unsubscribe> List-Archive: <http://lists.katipo.co.nz/pipermail/koha> List-Post: <mailto:koha@lists.katipo.co.nz> List-Help: <mailto:koha-request@lists.katipo.co.nz?subject=help> List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>, <mailto:koha-request@lists.katipo.co.nz?subject=subscribe> Sender: koha-bounces@lists.katipo.co.nz Errors-To: koha-bounces@lists.katipo.co.nz X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on shelob.katipo.co.nz X-Spam-Level: X-Spam-Status: No, hits=-2.6 required=5.0tests=BAYES_00 autolearn=ham version=3.0.2 Status: RO Content-Length: 1130
Hello list, Well, I have 2.2.2 running on Woody--many thanks to all of those who helped me out earlier. I think the main reason I was having trouble getting the installer to run completely was that I had a # in my root mysql password. Once I got rid of that, it completed the install, at least on mysql 3.2.3. Phew! Anyway, I actually got some material records imported into Koha (YES!), but on my first couple of attempts I didn't have the mapping set up properly and I tried deleting the data from the 3 main tables (biblio, biblioitems, and items) so I could start from scratch, but apparently I missed deleting something somewhere, because now I have duplicate records. Can anyone tell me what other tables I need to delete the data from in order to completely empty out all material records? Thanks! c. -- _________________________ Cindy Murdock Network Administrator Meadville Public Library | Crawford County Federated Library System meadvillelibrary.org | ccfls.org _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha