Forum .LRN Q&A: New User Add Error

Collapse
Posted by William Painter on
Everything seemed to be working fine until I came across this error today when adding a new user:

Request Error

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: more than one row returned by a subquery used as an expression

SQL:
select sn1.object_id
from site_nodes sn1,
apm_packages
where sn1.parent_id = (select sn2.node_id
from site_nodes sn2
where sn2.object_id = '1388')
and sn1.object_id = apm_packages.package_id
and apm_packages.package_key = 'file-storage'

while executing
"ns_pg_bind 0or1row nsdb0 {

And so on. It's just happened so I don't know what has changed.

How can I track this thing down?

Collapse
2: Re: New User Add Error (response to 1)
Posted by William Painter on
Found a solution.

http://mytlc.com/bug/bug?bug_number=11

It appears to be an issue of mounting applications. I unmounted one and it unbroke itself.