Date: Sun, 21 Apr 2013 08:37:21 -0700 (PDT)
From: la gleki <gleki.is.my.name@gmail.com>
To: lojban@googlegroups.com
Message-Id: <0e5a82a0-717b-4554-a6a6-0308f24638a2@googlegroups.com>
In-Reply-To: <20130421130233.GH29096@stodi.digitalkingdom.org>
References: <20130325180820.GU6328@stodi.digitalkingdom.org>
 <3520631.PfPziTd2d6@caracal>
 <20130326231316.GH22685@stodi.digitalkingdom.org>
 <2679640.AmcDiyQbsE@caracal>
 <20130421130233.GH29096@stodi.digitalkingdom.org>
Subject: Re: [lojban] Need some jbovlaste programming help.
MIME-Version: 1.0
Reply-To: lojban@googlegroups.com
Precedence: list
Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com
Sender: lojban@googlegroups.com
Content-Type: multipart/alternative; 
	boundary="----=_Part_9_17488400.1366558641236"
X-Spam_score: -0.1
X-Spam_score_int: 0
X-Spam_bar: /

------=_Part_9_17488400.1366558641236
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


On Sunday, April 21, 2013 5:02:34 PM UTC+4, Robin Powell wrote:
>
> On Wed, Mar 27, 2013 at 06:34:00AM -0400, Pierre Abbat wrote:=20
> > On Tuesday, March 26, 2013 16:13:16 Robin Lee Powell wrote:=20
> > > The problems are mostly in Russian, due to an import script I=20
> > > fucked up.  You can see the issue thuswise:=20
> > >=20
> > > select word,meaning,langid from natlangwords where word in=20
> > > (select word from natlangwords group by word, meaning, langid=20
> > > having count(*) > 1) order by langid;=20
> >=20
> > I've loaded the database and verified the problem.=20
>
> Pierre then followed on by actually producing a working script which=20
> appears to have fixed the problem!  \o/=20
>

la .piER.  .iosai


> So awesome to have someone actually help with what I say I need=20
> around here!  :D=20
>
> The output, fwiw, is at=20
> http://users.digitalkingdom.org/~rlpowell/media/public/cikre_output.html=
=20
> , and for my own future reference the sql dumps, script, and=20
> before/after diffs are at /srv/jbovlaste/cikre_script_backup on the=20
> web server.=20
>

There is a minor bug (feature?) when you add a glossword without comment=20
and then add another same glossword but with comments.
e.g.
at first you add
"=D0=BA=D0=BE=D1=88=D0=BA=D0=B0"
and then wanna add
"=D0=BA=D0=BE=D1=88=D0=BA=D0=B0 ; =D0=BC=D0=B5=D1=85=D0=B0=D0=BD=D0=B8=D0=
=B7=D0=BC"

It gives an error.


> -Robin=20
>

--=20
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 e=
mail 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=3Den.
For more options, visit https://groups.google.com/groups/opt_out.


------=_Part_9_17488400.1366558641236
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br><br>On Sunday, April 21, 2013 5:02:34 PM UTC+4, Robin Powell wrote:<blo=
ckquote class=3D"gmail_quote" style=3D"margin: 0;margin-left: 0.8ex;border-=
left: 1px #ccc solid;padding-left: 1ex;">On Wed, Mar 27, 2013 at 06:34:00AM=
 -0400, Pierre Abbat wrote:
<br>&gt; On Tuesday, March 26, 2013 16:13:16 Robin Lee Powell wrote:
<br>&gt; &gt; The problems are mostly in Russian, due to an import script I
<br>&gt; &gt; fucked up. &nbsp;You can see the issue thuswise:
<br>&gt; &gt;=20
<br>&gt; &gt; select word,meaning,langid from natlangwords where word in
<br>&gt; &gt; (select word from natlangwords group by word, meaning, langid
<br>&gt; &gt; having count(*) &gt; 1) order by langid;
<br>&gt;=20
<br>&gt; I've loaded the database and verified the problem.
<br>
<br>Pierre then followed on by actually producing a working script which
<br>appears to have fixed the problem! &nbsp;\o/
<br></blockquote><div><br></div><div>la .piER. &nbsp;.iosai</div><div><br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin: 0;margin-left: 0.8e=
x;border-left: 1px #ccc solid;padding-left: 1ex;">
<br>So awesome to have someone actually help with what I say I need
<br>around here! &nbsp;:D
<br>
<br>The output, fwiw, is at
<br><a href=3D"http://users.digitalkingdom.org/~rlpowell/media/public/cikre=
_output.html" target=3D"_blank">http://users.digitalkingdom.<wbr>org/~rlpow=
ell/media/public/<wbr>cikre_output.html</a>
<br>, and for my own future reference the sql dumps, script, and
<br>before/after diffs are at /srv/jbovlaste/cikre_script_<wbr>backup on th=
e
<br>web server.
<br></blockquote><div><br></div><div>There is a minor bug (feature?) when y=
ou add a glossword without comment and then add another same glossword but =
with comments.</div><div>e.g.</div><div>at first you add</div><div>"=D0=BA=
=D0=BE=D1=88=D0=BA=D0=B0"</div><div>and then wanna add</div><div>"=D0=BA=D0=
=BE=D1=88=D0=BA=D0=B0 ; =D0=BC=D0=B5=D1=85=D0=B0=D0=BD=D0=B8=D0=B7=D0=BC"</=
div><div><br></div><div>It gives an error.</div><div><br></div><blockquote =
class=3D"gmail_quote" style=3D"margin: 0;margin-left: 0.8ex;border-left: 1p=
x #ccc solid;padding-left: 1ex;">
<br>-Robin
<br></blockquote>

<p></p>

-- <br />
You received this message because you are subscribed to the Google Groups &=
quot;lojban&quot; group.<br />
To unsubscribe from this group and stop receiving emails from it, send an e=
mail to lojban+unsubscribe@googlegroups.com.<br />
To post to this group, send email to lojban@googlegroups.com.<br />
Visit this group at <a href=3D"http://groups.google.com/group/lojban?hl=3De=
n">http://groups.google.com/group/lojban?hl=3Den</a>.<br />
For more options, visit <a href=3D"https://groups.google.com/groups/opt_out=
">https://groups.google.com/groups/opt_out</a>.<br />
&nbsp;<br />
&nbsp;<br />

------=_Part_9_17488400.1366558641236--