Forum .LRN Q&A: error after installing dotlrn

Collapse
Posted by Thelma Pinto on
We are using oracle 8.1.7.
At the stage when we type in the

http:////yourserver/dotlrn/admin.

  in the browser after completing the installation of dotlrn  we get the following error:

ora8.c:3930:ora_tcl_command: error in `OCIStmtExecute ()': ORA-00942: table or view does not exist

    SQL:
                select count(*)
                from dual
                where exists (select 1
                              from !>>>!dotlrn_users
                              where user_id = :user_id)

        while executing
    "ns_ora 0or1row nsdb0 {
                select count(*)
                from dual
                where exists (select 1
                              from dotlrn_user..."
        ("uplevel" body line 1)
        invoked from within
    "uplevel $ulevel [list ns_ora $type $db $sql] $args"
        invoked from within
    "db_exec 0or1row $db $full_name $sql"
        invoked from within
    "set selection [db_exec 0or1row $db $full_name $sql]"
        ("uplevel" body line 2)
        invoked from within
    "uplevel 1 $code_block "
        invoked from within
    "db_with_handle db {
            set selection [db_exec 0or1row $db $full_name $sql]
        }"
        (procedure "db_string" line 7)
        invoked from within
    "db_string select_count {
                select count(*)
                from dual
                where exists (select 1
                              from dotlrn_us..."
        (procedure "dotlrn::user_p" line 3)
        invoked from within
    "dotlrn::user_p -user_id $user_id"
        ("uplevel" body line 1)
        (procedure "code::tcl::/home/oracle/oradotlrn/openacs/elearn/packages/do..." line 1)
        invoked from within
    "code::tcl::$__adp_stub"
        invoked from within
    "if { [file exists $__adp_stub.tcl] } {

          # ensure that data source preparation procedure exists and is up-to-date
          adp_init tcl $__adp_stub
    ..."
        ("uplevel" body line 3)
        invoked from within
    "uplevel {

        if { [file exists $__adp_stub.tcl] } {

          # ensure that data source preparation procedure exists and is up-to-date
          adp_init t..."
        (procedure "adp_prepare" line 2)
        invoked from within
    "adp_prepare "
        (procedure "template::adp_parse" line 30)
        invoked from within
    "template::adp_parse $__adp_master  [concat [list __adp_slave $__adp_output] [array get __adp_properties]"
        (procedure "template::adp_parse" line 63)
        invoked from within
    "template::adp_parse $__adp_master  [concat [list __adp_slave $__adp_output] [array get __adp_properties]"
        (procedure "template::adp_parse" line 63)
        invoked from within
    "template::adp_parse [file root [ad_conn file]] {}"
        (procedure "adp_parse_ad_conn_file" line 7)
        invoked from within
    "$handler"
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
            $handler
          } ad_script_abort val {
            # do nothing
          }"
        invoked from within
    "rp_serve_concrete_file [ad_conn file]"
        (procedure "rp_serve_abstract_file" line 60)
        invoked from within
    "rp_serve_abstract_file "$root/$path""
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
            rp_serve_abstract_file "$root/$path"
            set tcl_url2file([ad_conn url]) [ad_conn file]
            set tcl_url2path_info([ad_conn url]) [ad_conn path_inf..."

Collapse
Posted by Don Baccus on
Did you get dotLRN from the CVS HEAD?  The dotlrn-1-0 tag?  What version of OpenACS 4.6 are you using?  Please use the 4.6.1 beta 2 tarball that can be found by clicking on the "download" link at the top of this page, not CVS HEAD or the oacs-4-6 tag.

This appears to be an installation issue.  If you use the 4.6.1 beta 2 tarball you should have no problem ...

Collapse
Posted by Thelma Pinto on
hi,
i tried installing dotlrn using the openacs 4.6.1 beta 2 tarball that u mentioned.

we got some missing packages and the dotlrn packages using the following cvs.

cvs -z3 -d :pserver:mailto:anonymous@openacs.org:/cvsroot co \
        acs-datetime acs-developer-support acs-events acs-mail-lite \
        attachments bulk-mail calendar faq file-storage forums general-comments \
        news notifications ref-timezones user-preferences

cvs -z3 -d :pserver:mailto:anonymous@dotlrn.openforce.net:/dotlrn-cvsroot co dotlrn-core

now we get a diff error while opening

http://servername/dotlrn/admin
we are using oracle 8.1.7

Request Error

    Invalid switch: "-localize"
        while executing
    "get__arg_parser"
        (procedure "parameter::get" line 1)
        invoked from within
    "parameter::get -localize -parameter dotlrn_admin_pretty_name"
        invoked from within
    "set admin_pretty_name [parameter::get -localize -parameter dotlrn_admin_pretty_name]"
        ("uplevel" body line 25)
        invoked from within
    "uplevel {
              #
    #  Copyright (C) 2001, 2002 MIT
    #
    #  This file is part of dotLRN.
    #
    #  dotLRN is free software; you can redistribute it and/or modi..."
        (procedure "code::tcl::/home/oracle/oradotlrn/openacs/elearn/packages/do..." line 2)
        invoked from within
    "code::tcl::$__adp_stub"
        invoked from within
    "if { [file exists $__adp_stub.tcl] } {

          # ensure that data source preparation procedure exists and is up-to-date
          adp_init tcl $__adp_stub
    ..."
        ("uplevel" body line 3)
        invoked from within
    "uplevel {

        if { [file exists $__adp_stub.tcl] } {

          # ensure that data source preparation procedure exists and is up-to-date
          adp_init t..."
        (procedure "adp_prepare" line 2)
        invoked from within
    "adp_prepare "
        (procedure "template::adp_parse" line 30)
        invoked from within
    "template::adp_parse [file root [ad_conn file]] {}"
        (procedure "adp_parse_ad_conn_file" line 7)
        invoked from within
    "$handler"
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
            $handler
          } ad_script_abort val {
            # do nothing
          }"
        invoked from within
    "rp_serve_concrete_file [ad_conn file]"
        (procedure "rp_serve_abstract_file" line 60)
        invoked from within
    "rp_serve_abstract_file "$root/$path""
        ("uplevel" body line 2)
        invoked from within
    "uplevel $code"
        invoked from within
    "ad_try {
            rp_serve_abstract_file "$root/$path"
            set tcl_url2file([ad_conn url]) [ad_conn file]
            set tcl_url2path_info([ad_conn url]) [ad_conn path_inf..."

Please help
-Thelma

Collapse
Posted by Tilmann Singer on
Please read

https://openacs.org/projects/dotlrn/dotlrn-doc/dotlrn-installation

When adding stuff to the beta tarball you should checkout with -r oacs-4-6-b2 from openacs, and with -r dotlrn-1-0 from dotlrn.

Collapse
Posted by Jeff Davis on
Thelma, I also checked and the modules you said were missing from OpenACS are in fact in the tarball so I am not at all sure why you would need to check them out of cvs.
Collapse
Posted by Thelma Pinto on
Thanx everybody!!

We finally succeeded installing dotlrn with oracle 8.1.7 .
We had installed dotlrn with postgres earlier , but the calendar and my files module wasnt working properly.

we used cvs of openacs-4.6.1 beta2 and cvs of dotlrn 1.0 with the -r option.

thanx everyone once again.

-Thelma