Forum .LRN Q&A: Re: LORS Management available on CVS

Collapse
Posted by Orzenil Silva Junior on
Olá Ernie,

Great work! I was very anxious for this news.

I followed your instructions here and update file-storage to 5.1 on my 2.0.3 dotlrn installation. All packages for LORS management installs ok. No problem, no pain.

But I fall into trouble when I activated applet for a dotlrn class. I had the following error:
------------

You have found a bug in our code.

Please notify the webmaster and include the following text. Thank You.

*** portal::evaluate_element callback Error! ***

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

ERROR:  No such attribute cp.course_name

SQL:
    select
          cp.man_id,
          cp.course_name,
          cp.identifier,
          cp.version,
    text '[view]' as course_structure,
          case
              when hasmetadata = 't' then 'Yes'
              else 'No'
          end as hasmetadata,
          case
              when isscorm = 't' then 'Yes'
              else 'No'
          end as isscorm,
          cp.fs_package_id,
          cp.folder_id,
      acs.creation_user,
      acs.creation_date,
      acs.context_id
    from
          ims_cp_manifests cp, acs_objects acs
    where
          cp.man_id = acs.object_id
    and
          acs.context_id = '2472'

-------

I see at database schema and ims_cp_manifest table is there but there is not a course_name atribute in it.

Thanks

Orzenil

Collapse
Posted by Ernie Ghiglione on
Bom dia Orzenil,

Como vai?

the ims_cp_manifest table must have a course_name column. Can you do the following for me?

$ psql your-database-name

your-database-name# \d ims_cp_manifests

that should give you a list of all the columns on this table. If for some reason it doesn't look like this:
          Table "public.ims_cp_manifests"
    Column    |          Type          | Modifiers
---------------+-------------------------+-----------
man_id        | integer                | not null
course_name  | character varying(1000) |
identifier    | character varying(1000) |
version      | character varying(100)  |
orgs_default  | character varying(100)  |
hasmetadata  | boolean                |
parent_man_id | integer                |
isscorm      | boolean                |
folder_id    | integer                |
fs_package_id | integer                |

Then, I think we might have had a problem while installing. What version of postgres are you using?

Thanks,

Ernie