Forum OpenACS Development: Problem Deleting package from APM

Collapse
1: Problem Deleting package from APM
Posted by Jack Purswani on 09/05/01 02:48 AM
Hi folks. Im pretty sure I have finished porting the datamodel for the wimpy point. So I installed it on my APM. It doesnt actually work So I tried to remove it from the APM to load a revised version. I keep on getting an error message such as follows and I dont know what the problem might be. 

Request Error

       Database operation "0or1row" failed (exception NSDB, "Query was
not a statement returning rows.")
           while executing
       "ns_pg_bind 0or1row nsdb0 {
             
               select 1 from apm_package_types 
               where package_key = :package_key
           
             }"
           ("uplevel" body line 1)
           invoked from within
       "uplevel $ulevel [list ns_pg_bind $type $db $sql"
           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 apm_package_registered_p {
               select 1 from apm_package_types 
               where package_key = :package_key
           } -default 0"
           (procedure "apm_package_registered_p" line 3)
           invoked from within
       "apm_package_registered_p $package_key"
           ("uplevel" body line 1)
           (procedure "db_transaction" line 1)
           invoked from within
       "db_transaction {
           apm_package_delete -callback apm_doc_body_callback
$package_key
       } on_error {
           if {[apm_package_registered_p $package_key] } {
       ..."
           ("uplevel" body line 44)
           invoked from within
       "uplevel {
                 ad_page_contract {

           Deletes a package from the database and the filesystem.

           @author Bryan Quinn (bquinn@arsdigita.com)
           @..."
           (procedure
"code::tcl::/web/purswami4/packages/acs-admin/www/apm/package..." 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 31)
           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..."
Sorry about that length of it. So would anyone know what this error message is trying to tell me? I must have done something wrong. But what it is I dont know. I woudl appreciate any help. Thanks. Jack.
Collapse
2: Response to Problem Deleting package from APM (response to 1)
Posted by Jack Purswani on 09/05/01 03:15 AM 
OK. I basically solved this problem by dropping my database and creating it anew. I still dont know what I did wrong and there must be a better way?

So I re-Installed wp-slim again and now when I goto the wp-slim application it is giving me this message:


Security Violation
       You don't have permission to wp_view_presentation Untitled. 
       This incident has been logged. 


I have set the permissions to :


Direct Permissions
       Registered Users, wp_view_presentation () 
       The Public, wp_view_presentation () 


So I guess I should have the permission to view the file? 
I guess what I am trying to ask is where do I start looking for the problem? In the datamodel or xql files? 

Thanks.
Jack
Collapse
3: Response to Problem Deleting package from APM (response to 1)
Posted by Tilmann Singer on 09/05/01 11:14 AM
Concerning the datamodel drop problem: you might have been run in bug #1072 that prevented deletion of packages with registered parameters on the postgresql version. This bug has been fixed recently, so if you have done an upgrade and recreated the database (re-installed acs) it has propably been eliminated.

Btw, for quick testing it's easier to load the datamodel create and drop scripts directly in psql/sqlplus, using i <bla-drop.sql> (that should read backslash-i) / @ <bla-drop.sql>