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