Forum OpenACS Q&A: List Reference Data

Posted by Randy Ferrer on 02/20/03 03:51 PM

Hi - I have an instance of the ACS Reference Data package mounted and I have loaded all reference data. When I click on any of the links in the reference-data-list page, I get the following error:

Request Error

Database operation "0or1row" failed (exception NSINT, "Query returned more than one row.")
    while executing
"ns_pg_bind 0or1row nsdb0 {
    select repository_id,
    table_name,
    internal_data_p,
    package_name,
    last_update,
    source,
    source_ur..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"......

Has anyone run into this? Is there a particular order data should be loaded in? I'm running a recently checked out copy from oacs 4-6 branch & PG 7.2.4.

2: Re: List Reference Data - Request Error (response to 1)

Posted by Randy Ferrer on 02/20/03 10:09 PM

Ok - Fixed this by adding a distinct operator like so:

 select distinct repository_id,
    table_name,
    internal_data_p,
    package_name,
    last_update,
    source,
    source_url,
    effective_date,
    expiry_date,
    maintainer_id
    from acs_reference_repositories r,cc_users u
    where repository_id= :repository_id

Is anyone doing any work to complete the UI???

3: Re: List Reference Data - Request Error (response to 1)

Posted by Randy Ferrer on 02/20/03 11:51 PM

Sorry about the last post. I removed the cc_users view altogether along with the distinct operator. Not sure what cc_users was doing there...

Forum OpenACS Q&A: List Reference Data - Request Error