Forum OpenACS Q&A: Error with Static Pages in openacs4.6

1: Error with Static Pages in openacs4.6

Posted by Richard Hamilton on 07/19/03 03:14 PM

I have OpenFTS, General Comments and the Static Pages module installed (in that order although I cannot delete previous attempts to mount Static Pages for some reason), and I get this error when I try to search for pages:

Request Error
no such array: .
    while executing
"nsv_get . {sp_sync_cr_fs_mutex}"
    (procedure "sp_sync_cr_with_filesystem_unlock" line 2)
    invoked from within
"sp_sync_cr_with_filesystem_unlock $package_id"
    (procedure "sp_sync_cr_with_filesystem" line 12)
    invoked from within
"sp_sync_cr_with_filesystem  -file_unchanged_proc sp_old_item  -file_add_proc sp_new_item  -file_change_proc sp_changed_item  -file_read_error_proc sp_..."
    invoked from within
"ns_write "

[sp_sync_cr_with_filesystem  -file_unchanged_proc sp_old_item  -file_add_proc sp_new_item  -file_change_proc sp_changed_item  -file_rea..."
    ("uplevel" body line 54)
    invoked from within
"uplevel {
    	  # packages/static-pages/www/admin/fs-scan-progress.tcl
ad_page_contract {
    Scan the file system for static pages.  If there are ma..."
    (procedure "code::tcl::/web/militaria-exchange/packages/static-pages/www..." 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..."

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Before I installed openFTS and General Comments I installed Static Pages on its own and the file search worked perfectly. I then unmounted it, installed openFTS and General Comments and now it is not working.
Richard

2: Re: Error with Static Pages in openacs4.6 (response to 1)

Posted by Richard Hamilton on 07/19/03 03:26 PM

I have diabled the Static Pages package, restarted the server, enabled the package, restarted the server - and now I get this :

Request Error Database operation "dml" failed while executing "ns_pg_bind dml nsdb0 { insert into cr_mime_types (mime_type, file_extension) values (:..." ("uplevel" body line 1) invoked from within "uplevel $ulevel [list ns_pg_bind $type $db $sql" invoked from within "db_exec dml $db $full_statement_name $sql" ("uplevel" body line 2) invoked from within "uplevel 1 $code_block " invoked from within "db_with_handle db { db_exec dml $db $full_statement_name $sql }" (procedure "db_dml" line 37) invoked from within "db_dml new_mime_type { insert into cr_mime_types (mime_type, file_extension) values (:..." (procedure "sp_maybe_create_new_mime_type" line 41) invoked from within "sp_maybe_create_new_mime_type $sp_filename" (procedure "sp_sync_cr_with_filesystem_internal" line 252) invoked from within "sp_sync_cr_with_filesystem_internal -file_add_proc $file_add_proc -file_change_proc $file_change_proc -file_unchanged_p..." (procedure "sp_sync_cr_with_filesystem" line 7) invoked from within "sp_sync_cr_with_filesystem -file_unchanged_proc sp_old_item -file_add_proc sp_new_item -file_change_proc sp_changed_item -file_read_error_proc sp_..." invoked from within "ns_write "

[sp_sync_cr_with_filesystem -file_unchanged_proc sp_old_item -file_add_proc sp_new_item -file_change_proc sp_changed_item -file_rea..." ("uplevel" body line 54) invoked from within "uplevel { # packages/static-pages/www/admin/fs-scan-progress.tcl ad_page_contract { Scan the file system for static pages. If there are ma..." (procedure "code::tcl::/web/militaria-exchange/packages/static-pages/www..." 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..."

3: Re: Error with Static Pages in openacs4.6 (response to 2)

Posted by Richard Hamilton on 07/19/03 04:16 PM

OK, I have managed to sort this out by manually deleting entries in the sp_folders and static_pages tables where a static page was entered when I first mounted Static Pages. This initial attempt was made without having mounted General Comments onto a url and seems to have caused problems that the Package Manager cannot fix. Specifically the integrity constraints between the content repository and the static pages tables end up blocking the removal of the static pages instances even when an instance shows that there are no static pages found.

I must say that a 'remove all references to this particular package because I have screwed up the installation and want to start again' button would be extremely good news!

4: Re: Error with Static Pages in openacs4.6 (response to 1)

Posted by Don Baccus on 07/19/03 06:16 PM

General comments is set up to auto-mount when installed, but it probably didn't make it into 4.6.3 ...