[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[lojban] Re: jbovlaste got a bug
- To: Gleki Arxokuna <gleki.is.my.name@gmail.com>
- Subject: [lojban] Re: jbovlaste got a bug
- From: Robin Lee Powell <rlpowell@digitalkingdom.org>
- Date: Sun, 19 Aug 2018 22:24:50 -0700
- Arc-authentication-results: i=2; 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.mailfrom=rlpowell@digitalkingdom.org
- Arc-authentication-results: i=1; 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.mailfrom=rlpowell@digitalkingdom.org
- Arc-message-signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=list-unsubscribe:list-subscribe:list-archive:list-help:list-post :list-id:mailing-list:precedence:reply-to:user-agent:in-reply-to :content-disposition:mime-version:references:mail-followup-to :message-id:subject:cc:to:from:date:arc-authentication-results :arc-message-signature:sender:dkim-signature :arc-authentication-results; bh=A6FoTKRiW+sPEecnyTD8zGLgKc7L0X/gZKi7nKrRadY=; b=zPbxlcOCi5dTy9IJeQoLUj2uamyfCkieTRm+u/l23+Tnmn4xOIaWljf8CVwM+FWDlD iwszu3vBf4Y+/HmVxdIgNV4I4qdVEWOXwLLZJLioZzEWzfoXmRNhtVez8L5VSTWNzPIh ZDNe+o4Gf7czBZioLWw9EuLN9kvIdy9zjno2hIrX937n9opKHDB6OjYtm/WW4pBpCc0j CfQP37CZ+JIP9xYhFRumaJblRBiJP0HNOCpbq9t54zp7NMD1VGAojzNw1twyAcnNo9Ih 1OD70wjAAagkVrCgUztEyzG6YWXlMDomYENfRfaSBXgNB6OmJ6w587DxfIPzY1bC7WE7 kA0w==
- Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=user-agent:in-reply-to:content-disposition:mime-version:references :mail-followup-to:message-id:subject:cc:to:from:date :arc-authentication-results; bh=4MKyDpFwkHDEMndoxoswr+RmnwtsmKRli/jTBd2c4QA=; b=uOeDpnrdmpHMx2KxGh4NW570/QfiEGpQ7UQCd5CK6hmOjjEntUIIUlwNJPnp3aZBvX JCsA+KM8StMoyZvKYB+3VLjyjAMtjPygcXITNdd0SMbf8bK+3oyxKIWBEdhSBjpV2NEK Ei2VajK0M4IJOWfgiaE6UhJa/W3kmtyehUbK7bsLgXlUbjh6/UfKYabkRLZ0kf48FHIO wYwod2TQbmrbid0l7MB2ieQM+txDESQr5RXYrZuzX3MPJPfX5t4DQzljDZD/G+MKsTZ+ aNlPkJ/Gf43htds2aMKseveOfnCmr8ovEUqUKXnQ/zynK5WgG+2jiAnWTL56WbqmJpx5 TIdA==
- Arc-seal: i=2; a=rsa-sha256; t=1534742692; cv=pass; d=google.com; s=arc-20160816; b=kyIlb9PTLQI/YB4da2iajz2mW1fq5Y9eERo3bq1eOD7DSLc7wyftZpdJCckpzcu9KS vpX87nHzK1iO2QrQihTNr+tn994N+qSyJZnyakmSV2H+P0Uye8Azpo4nOYAG1qoqkTw/ NVW4gij+FvNf1iibqkkz1AhiGDPPbwikVmsbRMRwF1LkZVCVwxi7GJOWkZ9YMnEE9mCn b33luGbCyyCd3x+WUfh+5XnhZzDKKFLoQ+vr1lQqC59YTxP1un118aIfQoYNlOk/oOr3 fuK/phTF3VuZZyBrdgsow/JBTKS4H0hLDmWI0wFA2Z6NcwW6JElDJDPHOLAtZL1MoLxQ 0rbQ==
- Arc-seal: i=1; a=rsa-sha256; t=1534742691; cv=none; d=google.com; s=arc-20160816; b=M2b/WtRT4UCIuLy4J1/URBP6pQE5Xc34Yw7t6/oV20bs3PSNfd05uuM8Ch41kXqpwb 38KEuHLtuUC3+HBSsmxPx0xrZN1X2E3QPqpzTVeDI1ztyJ+QoQRJ+zD90WL9QmTYSZ0R Vif7e2dRrX07xWtiIVrJ97DEZ+/KzWS2NoEf4gEWQTU5hak8AcwNXhGNtWjySdLMGx2b v/e0+X4919dPom2YfCjZ8vU1DBoi6+/VuSH2dziaS6g0vGLvjXE6Ddky8diRTIE/ucFz ApX+7i1ffnDQgg+1FznlQJNO5dfeORFiMvcWeq6xWOSoe3/RRARwBqIxUmU1IuXMOYxq z92A==
- Cc: lojban@googlegroups.com
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20161025; h=sender:date:from:to:cc:subject:message-id:mail-followup-to :references:mime-version:content-disposition:in-reply-to:user-agent :x-original-sender:x-original-authentication-results:reply-to :precedence:mailing-list:list-id:list-post:list-help:list-archive :list-subscribe:list-unsubscribe; bh=A6FoTKRiW+sPEecnyTD8zGLgKc7L0X/gZKi7nKrRadY=; b=CYnh/pdLx9pM8NsRHUdzXcHdrMvmyAVO6dTMhWXfYhdFAHO2W/nGIj1sAg+6iOt81H eN6EzH1ZkRTVDwWSrX3jzcqENSJnspu3IqwsKFJwd/BKPuLli/LHCjl2w9hlVA16JCyT 8TujsFPqe2W6exfZKKdwONCiup51cR/0Frm7EUPNDHe5ivyI6vdsK98Qmn+JsYddzdQV gPQ4PfyaKt3XU4nCuDIascAr1H+SG4WfRV12icHv4IV/IjSZWPRuVNfPpTFr74r8Whf7 9qqwfUGS/F5ZUJr3TFvqS20VWJJ9WeRyYS33t0PXWIxJSRezohg/u76H1XP1AvkK8ZVl Ff9A==
- In-reply-to: <CAO7bV+gdRSVgg2Qjvmtkvm-EG4fWAS=Sk0BK-mHU67fzMWOiWA@mail.gmail.com>
- List-archive: <https://groups.google.com/group/lojba>
- List-help: <https://groups.google.com/support/>, <mailto:lojban+help@googlegroups.com>
- List-id: <lojban.googlegroups.com>
- List-post: <https://groups.google.com/group/lojban/post>, <mailto:lojban@googlegroups.com>
- List-subscribe: <https://groups.google.com/group/lojban/subscribe>, <mailto:lojban+subscribe@googlegroups.com>
- List-unsubscribe: <mailto:googlegroups-manage+1004133512417+unsubscribe@googlegroups.com>, <https://groups.google.com/group/lojban/subscribe>
- Mail-followup-to: Gleki Arxokuna <gleki.is.my.name@gmail.com>, lojban@googlegroups.com
- Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com
- References: <CAO7bV+gdRSVgg2Qjvmtkvm-EG4fWAS=Sk0BK-mHU67fzMWOiWA@mail.gmail.com>
- Reply-to: lojban@googlegroups.com
- Sender: lojban@googlegroups.com
- User-agent: Mutt/1.10.0 (2018-05-17)
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.