Forum .LRN Q&A: Error installing .LRN 2.3.0

Collapse
Posted by vivian Aguilar on
Hello I am getting the following error during the install. I am trying with the tar from here https://openacs.org/projects/dotlrn/download/one-revision?revision_id=976988
and checking out from cvs.

Database operation "0or1row" failed (exception ERROR, "ERROR: column u.oid does not exist
")

ERROR: column u.oid does not exist

SQL:
select u.email_verified_p as email_verified_p_old,
mr.member_state as member_state_old,
per.first_names || ' ' || per.last_name as name,
part.email, mr.rel_id, u.oid as row_id
from users u
JOIN parties part on (part.party_id = u.user_id)
JOIN persons per on (per.person_id = u.user_id)
LEFT JOIN membership_rels mr on (mr.rel_id = u.user_id)
where u.user_id = '567'

Collapse
Posted by Dave Bauer on
You need to enable OID support in postgreql.conf.

Overall I don't see any need for the oid in their query in particular, so you can try removing it, but there might be other places that still require the oid.

Collapse
Posted by vivian Aguilar on
thank you Dave.
I edit the file and turn on the following flags:
add_missing_from = on
regex_flavor = extended
default_with_oids = on

Vivian