Forum OpenACS Q&A: some failure with openacs-4

Collapse
Posted by eugene kim on
from https://openacs.org/doc/openacs-4/nextsteps.html
----------------------
Click on the "Main Site" link to get back to the home page. Now,
click on the "ACS Service Contract" link near the bottom of the home
page.
Click on the link to "install" the FtsEngineDriver.
what i got when i click ACS Service Contact
there's no FtsEngineDriver
----------------------------
ACS Service Contract
Your Workspace : Main Site : ACS Service Contract
Installed Bindings

    * 841 FtsContentProvider, 879 content_revision [Uninstall]
    * 841 FtsContentProvider, 881 content_template [Uninstall]
* 841 FtsContentProvider, 880 image [Uninstall]

Valid Uninstalled Bindings

    * None

from https://openacs.org/doc/openacs-4/nextsteps.html
-----------------------
Also, click the link to install the Note content provider.

result
when i click the link.. there is an error shown below..
-----------------
Request Error

Database operation "select" failed (exception NSDB, "Query was not a
statement returning rows.")
    while executing
"ns_pg_bind select nsdb0 {
  select note_id, owner_id, title, body,
        case when
acs_permission__permission_p(note_id,:user_id,'write')='t'
    ..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec select $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
    set selection [db_exec select $db $full_statement_name $sql]
        set local_counter 0

    while { [db_getrow $db $selection] } {..."
    (procedure "db_multirow" line 40)
    invoked from within
"db_multirow notes notes {
  select note_id, owner_id, title, body,
        decode(acs_permission.permission_p(note_id,
                              ..."
    ("uplevel" body line 21)
    invoked from within
"uplevel {
          # main index page for notes.

ad_page_contract {

  @author mailto:rhs@mit.edu
  @creation-date 2000-10-23
  @cvs-id $Id: index.tcl,v 1.1.1...."
    (procedure "code::tcl::/web/beautiful/packages/notes/www/index"
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 3)
    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..."

Collapse
Posted by Dave Bauer on
Eugene,

Please wrap all code samples and log snippets in <pre> </pre> html tags.

Anyway, did you install the openfts-driver package? If you followed all the steaps in the install guide for OpenFTS search and did not receive any errors, it should have been there.

Collapse
Posted by eugene kim on
from installation document

Click on the "Main Site" link to get back to the home page. Now, click on the "ACS Service Contract" link near the bottom of the home page. Click on the link to "install" the FtsEngineDriver.

when i got when i click ACS Service Contact there's no FtsEngineDriver

from installation document

Also, click the link to install the Note content provider.

there is an error shown below.. -----------------

Request Error Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") while executing "ns_pg_bind select nsdb0 { select note_id, own

Collapse
Posted by eugene kim on
 from https://openacs.org/doc/openacs-4/nextsteps.html    
----------------------   
Click on the "Main Site" link to get back to    
the home page. Now, click on the "ACS Service Contract" link near    
the bottom of the home page. Click on the link to "install" the    
FtsEngineDriver.   
  
when i click ACS Service Contact there's  no FtsEngineDriver  
----------------------------   
ACS Service Contract  
  
Your Workspace : Main Site : ACS Service Contract   
  
Installed Bindings  
  
None  
  
Valid Uninstalled Bindings  
  
841 FtsContentProvider, 879 content_revision [Install]   
841 FtsContentProvider, 880 image [Install]   
841 FtsContentProvider, 881 content_template [Install]   
  
Invalid Uninstalled Bindings  
  
None  
  
Orphan Implementations  
  
None  
  
..  
another error when i click note 
---------------- 
Request Error 
 
Database operation "select" failed (exception NSDB, "Query was not a 
statement returning rows.") 
    while executing 
"ns_pg_bind select nsdb0 { 
  select note_id, owner_id, title, body, 
         case when 
acs_permission__permission_p(note_id,:user_id,'write')='t'  
    ..." 
    ("uplevel" body line 1) 
    invoked from within 
"uplevel $ulevel [list ns_pg_bind $type $db $sql" 
    invoked from within 
"db_exec select $db $full_statement_name $sql" 
    invoked from within 
"set selection [db_exec select $db $full_statement_name $sql]" 
    ("uplevel" body line 2) 
    invoked from within 
"uplevel 1 $code_block " 
    invoked from within 
"db_with_handle db { 
        set selection [db_exec select $db $full_statement_name $sql] 
        set local_counter 0 
 
        while { [db_getrow $db $selection] } {..." 
    (procedure "db_multirow" line 40) 
    invoked from within 
Collapse
Posted by eugene kim on
 
maybe installation process is the problem? 
 
i had postgres7.2 rpm installed 
and installed openacs4.5 and aolserver 
 
couldn't figure out the way to install openfts with rpm 
(it was postgres7.2 not rpm by the way) 
 
uninstalled rpms and installed tarbal postgres7.2 
 
installed openfts with changing include dir to 
/usr/local/pgsql/include/server 
 
.... 
is there any problem with this? 
thank you 
Collapse
Posted by Neophytos Demetriou on
Eugene, no problem with that. Make sure that you initialized the openfts-driver package. The FtsEngineDriver will only appear at the acs-service-contract index page once there's at least one implementation of that contract and openfts-driver provides such an implementation.