Sender: lojban@googlegroups.com
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;
Date: Sun, 19 Aug 2018 22:24:50 -0700
From: Robin Lee Powell <rlpowell@digitalkingdom.org>
To: Gleki Arxokuna <gleki.is.my.name@gmail.com>
Cc: lojban@googlegroups.com
Subject: [lojban] Re: jbovlaste got a bug
Message-ID: <20180820052450.GN15098@stodi.digitalkingdom.org>
Mail-Followup-To: Gleki Arxokuna <gleki.is.my.name@gmail.com>,
	lojban@googlegroups.com
References: <CAO7bV+gdRSVgg2Qjvmtkvm-EG4fWAS=Sk0BK-mHU67fzMWOiWA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Disposition: inline
In-Reply-To: <CAO7bV+gdRSVgg2Qjvmtkvm-EG4fWAS=Sk0BK-mHU67fzMWOiWA@mail.gmail.com>
User-Agent: Mutt/1.10.0 (2018-05-17)
Reply-To: lojban@googlegroups.com
Precedence: list
Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com
X-Spam_score: -2.7
X-Spam_score_int: -26
X-Spam_bar: --

On Sat, Aug 18, 2018 at 10:35:35PM +0300, Gleki Arxokuna wrote:
> http://jbovlaste.lojban.org/dict/coi
> 
> 
> no idea why is that happening. probably we need to roll back
> latest commits?

So it turns out the database needs to be cleaned more often; I've
fixed that.

This revealed some further corruption; there should never be two
valsi with the same name in the DB, but there were.

There were two "ue'i"; one of them is now http://jbovlaste.lojban.org/dict/xue'i

I would like y'all to move whatever useful data is there to the real
ue'i and then I'll delete xue'i; let me know when I can do that.

There were two "jboselbau"; one of them had no definitions and I've
deleted it.

jbovlaste=# select valsiid, word, typeid from valsi where word='ue''i';
 valsiid | word | typeid
---------+------+--------
   28921 | ue'i |      8
   32520 | ue'i |      8
(2 rows)

jbovlaste=# update valsi set word='xue''i' where valsiid=32520;
UPDATE 1
jbovlaste=# select valsiid, word, typeid from valsi where word='jboselbau';
 valsiid |   word    | typeid
---------+-----------+--------
   32454 | jboselbau |      4
   32513 | jboselbau |      4
(2 rows)

jbovlaste=# update valsi set word='jboselxau' where valsiid=32513;
UPDATE 1

jbovlaste=# select * from definitions where valsiid=32520;
 langid | valsiid | definitionnum | definitionid | definition  |    notes     | userid |    time    | selmaho | jargon
--------+---------+---------------+--------------+-------------+--------------+--------+------------+---------+--------
      1 |   32520 |         71019 |        71019 | sei ue'inmo | .i {ue'inmo} |    523 | 1533291649 | UI1     |
(1 row)

jbovlaste=# select * from definitions where valsiid=32513;
 langid | valsiid | definitionnum | definitionid | definition | notes | userid | time | selmaho | jargon
--------+---------+---------------+--------------+------------+-------+--------+------+---------+--------
(0 rows)

jbovlaste=# delete from valsi where valsiid=32513;
DELETE 1

-- 
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 https://groups.google.com/group/lojban.
For more options, visit https://groups.google.com/d/optout.