Received: from mail-qa0-f55.google.com ([209.85.216.55]:37214) by stodi.digitalkingdom.org with esmtps (TLSv1:RC4-SHA:128) (Exim 4.76) (envelope-from ) id 1UTtul-00048o-22 for lojban-list-archive@lojban.org; Sun, 21 Apr 2013 06:03:06 -0700 Received: by mail-qa0-f55.google.com with SMTP id hg5sf138553qab.20 for ; Sun, 21 Apr 2013 06:02:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20120806; h=x-received:x-beenthere:x-received:received-spf:date:from:to:subject :message-id:mail-followup-to:references:mime-version:in-reply-to :user-agent:x-original-sender:x-original-authentication-results :reply-to:precedence:mailing-list:list-id:x-google-group-id :list-post:list-help:list-archive:sender:list-subscribe :list-unsubscribe:content-type:content-disposition; bh=V2RdAPlR12jCST6iDOUNG8OHFvO/dCE6f/KM1Xu/mLA=; b=KsdzOZy6sUaFq6sGt4ZZM+rdEZhoPq0RI3l6BSTKGCjG5ehqLZIAsNZQ1GthAOwNqS MILDc/rziQBKaNeuXfGRN7gkK8pLCQujNveQHEcslc4WKzLqyjFDj0xaIWslhg7jaGSV sDHnX1wWjvRADWqu009vm5Mw+NiGjkIKYMSJzBieVkCx8wKJdL9sRUMrOvSiPhHjKh8X uJ0bN0FBg4nkv4Q/+Cm/fhtB4NDWDFhdgSOGXPNiM9aYLEWvSleSIZ4PqMZtfEgoK9mV csTvZndYVeS3AsX6wF0CxZq1qRSZWtmpLVgs00YnHSdpuhVcmsRZ6sQNtnMGgfCT03G0 0Ngw== X-Received: by 10.50.112.105 with SMTP id ip9mr1980187igb.1.1366549356066; Sun, 21 Apr 2013 06:02:36 -0700 (PDT) X-BeenThere: lojban@googlegroups.com Received: by 10.50.85.231 with SMTP id k7ls1552946igz.25.gmail; Sun, 21 Apr 2013 06:02:35 -0700 (PDT) X-Received: by 10.66.191.130 with SMTP id gy2mr2437605pac.19.1366549355283; Sun, 21 Apr 2013 06:02:35 -0700 (PDT) Received: from stodi.digitalkingdom.org (mail.digitalkingdom.org. [173.13.139.236]) by gmr-mx.google.com with ESMTPS id qo12si3845567pbb.1.2013.04.21.06.02.34 (version=TLSv1 cipher=RC4-SHA bits=128/128); Sun, 21 Apr 2013 06:02:35 -0700 (PDT) Received-SPF: pass (google.com: best guess record for domain of rlpowell@digitalkingdom.org designates 173.13.139.236 as permitted sender) client-ip=173.13.139.236; Received: from rlpowell by stodi.digitalkingdom.org with local (Exim 4.76) (envelope-from ) id 1UTtuc-00048e-8c for lojban@googlegroups.com; Sun, 21 Apr 2013 06:02:34 -0700 Date: Sun, 21 Apr 2013 06:02:34 -0700 From: Robin Lee Powell To: lojban@googlegroups.com Subject: Re: [lojban] Need some jbovlaste programming help. Message-ID: <20130421130233.GH29096@stodi.digitalkingdom.org> Mail-Followup-To: lojban@googlegroups.com References: <20130325180820.GU6328@stodi.digitalkingdom.org> <3520631.PfPziTd2d6@caracal> <20130326231316.GH22685@stodi.digitalkingdom.org> <2679640.AmcDiyQbsE@caracal> MIME-Version: 1.0 In-Reply-To: <2679640.AmcDiyQbsE@caracal> User-Agent: Mutt/1.5.21 (2010-09-15) X-Original-Sender: rlpowell@digitalkingdom.org X-Original-Authentication-Results: gmr-mx.google.com; spf=pass (google.com: best guess record for domain of rlpowell@digitalkingdom.org designates 173.13.139.236 as permitted sender) smtp.mail=rlpowell@digitalkingdom.org Reply-To: lojban@googlegroups.com Precedence: list Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com List-ID: X-Google-Group-Id: 1004133512417 List-Post: , List-Help: , List-Archive: Sender: lojban@googlegroups.com List-Subscribe: , List-Unsubscribe: , Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline X-Spam-Score: -0.0 (/) X-Spam_score: -0.0 X-Spam_score_int: 0 X-Spam_bar: / On Wed, Mar 27, 2013 at 06:34:00AM -0400, Pierre Abbat wrote: > On Tuesday, March 26, 2013 16:13:16 Robin Lee Powell wrote: > > The problems are mostly in Russian, due to an import script I > > fucked up. You can see the issue thuswise: > > > > select word,meaning,langid from natlangwords where word in > > (select word from natlangwords group by word, meaning, langid > > having count(*) > 1) order by langid; > > I've loaded the database and verified the problem. Pierre then followed on by actually producing a working script which appears to have fixed the problem! \o/ So awesome to have someone actually help with what I say I need around here! :D The output, fwiw, is at http://users.digitalkingdom.org/~rlpowell/media/public/cikre_output.html , and for my own future reference the sql dumps, script, and before/after diffs are at /srv/jbovlaste/cikre_script_backup on the web server. -Robin -- You received this message because you are subscribed to the Google Groups "lojban" group. To unsubscribe from this group and stop receiving emails from it, send an email to lojban+unsubscribe@googlegroups.com. To post to this group, send email to lojban@googlegroups.com. Visit this group at http://groups.google.com/group/lojban?hl=en. For more options, visit https://groups.google.com/groups/opt_out.