Forum OpenACS Q&A: Re: xowiki V0.118 - exception NSINT, Query returned more than one row

Collapse
3: Re: xowiki V0.118 - exception NSINT, Query returned more than one row (response to 1)
Posted by Malte Sussdorff on 02/13/11 10:11 PM
in your installation you can execute the following commands:

select * from cr_text (make sure it shows more than one row, otherwise the problem lies somewhere else)

alter table cr_text disable trigger cr_text_tr;
delete from cr_text;
insert into cr_text (text_data) values ('');
alter table cr_text enable trigger cr_text_tr;

Collapse
4: Re: xowiki V0.118 - exception NSINT, Query returned more than one row (response to 3)
Posted by Klaus Hofeditz on 02/13/11 11:19 PM
Hi Malte,

confirmed - table cr_text had two records. Deleting them and creating a new one, resolved the problem.

Until we we haven't figured out the cause, the following patch might contribute to a more stable environment:

**********************************************

[projop@project-open-v34 tcl]$ cvs diff cr-procs.tcl
Index: cr-procs.tcl
===================================================================
RCS file: /cvsroot/openacs-4/packages/xotcl-core/tcl/cr-procs.tcl,v
retrieving revision 1.44
diff -r1.44 cr-procs.tcl
469c469,470
< and o.object_id = i.item_id"
---

and o.object_id = i.item_id
limit 1"

**********************************************

Thanks again!
Klaus