Forum .LRN Q&A: Re: WP-Slim Package

Collapse
7: Re: WP-Slim Package (response to 1)
Posted by Nima Mazloumi on
Hi Roacel,

I unmounted my wp-slim instance and deleted it from the site-map. Then in the package manager I selected Uninstall this package from server. I was asked if I want to run the drop.sql file which I affirmed.

Now I got the following message.

Request Error
psql:wp-slim-drop.sql:91: ERROR:  cr_folder_type_map_typ_fk referential integrity violation - key in acs_object_types still referenced from cr_folder_type_map
psql:wp-slim-drop.sql:371: ERROR:  RemoveFunction: function wp_attachment__delete(integer) does not exist
psql:wp-slim-drop.sql:375: ERROR:  RemoveFunction: function wp_attachment__new_revision(integer) does not exist
psql:wp-slim-drop.sql:393: ERROR:  RemoveFunction: function wp_slide__new(integer, timestamp without time zone, integer, character varying, character varying, integer, integer, integer, character varying, character varying, character varying, boolean, boolean, integer) does not exist
psql:wp-slim-drop.sql:397: ERROR:  RemoveFunction: function wp_slide__delete_preamble(integer) does not exist
psql:wp-slim-drop.sql:401: ERROR:  RemoveFunction: function wp_slide__delete_postamble(integer) does not exist
psql:wp-slim-drop.sql:405: ERROR:  RemoveFunction: function wp_slide__delete_bullet_items(integer) does not exist
psql:wp-slim-drop.sql:409: ERROR:  RemoveFunction: function wp_slide__delete(integer) does not exist
psql:wp-slim-drop.sql:413: ERROR:  RemoveFunction: function wp_slide__get_preamble_revision(integer) does not exist
psql:wp-slim-drop.sql:416: ERROR:  RemoveFunction: function wp_slide__get_preamble(integer) does not exist
psql:wp-slim-drop.sql:432: ERROR:  RemoveFunction: function wp_presentation__new(timestamp without time zone, integer, character varying, character varying, character varying, character varying, integer, boolean, boolean, character varying, character varying, integer) does not exist
psql:wp-slim-drop.sql:436: ERROR:  RemoveFunction: function wp_presentation__delete_audience(integer) does not exist
psql:wp-slim-drop.sql:440: ERROR:  RemoveFunction: function wp_presentation__delete_background(integer) does not exist
psql:wp-slim-drop.sql:444: ERROR:  RemoveFunction: function wp_presentation__delete(integer) does not exist
psql:wp-slim-drop.sql:448: ERROR:  RemoveFunction: function wp_presentation__get_ad_revision(integer) does not exist
psql:wp-slim-drop.sql:452: ERROR:  RemoveFunction: function wp_presentation__get_bg_revision(integer) does not exist
psql:wp-slim-drop.sql:455: ERROR:  RemoveFunction: function wp_presentation__get_audience(integer) does not exist
psql:wp-slim-drop.sql:459: ERROR:  RemoveFunction: function wp_presentation__get_background(integer) does not exist
psql:wp-slim-drop.sql:474: ERROR:  RemoveFunction: function wp_slide__new_revision(timestamp without time zone, integer, character varying, integer, character varying, text, character varying, character varying, integer, integer, integer, boolean, boolean) does not exist
psql:wp-slim-drop.sql:488: ERROR:  RemoveFunction: function wp_presentation__new_revision(timestamp without time zone, integer, character varying, integer, character varying, character varying, character varying, integer, boolean, boolean, character varying, character varying) does not exist
psql:wp-slim-drop.sql:491: ERROR:  Cannot drop table cr_wp_presentations_aud because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:492: ERROR:  Cannot drop table cr_wp_presentations_back because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:493: ERROR:  Cannot drop table cr_wp_slides_preamble because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:494: ERROR:  Cannot drop table cr_wp_slides_postamble because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:495: ERROR:  Cannot drop table cr_wp_slides_bullet_items because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:497: ERROR:  view "cr_wp_image_attachmentsi" does not exist
psql:wp-slim-drop.sql:498: ERROR:  view "cr_wp_image_attachmentsx" does not exist
psql:wp-slim-drop.sql:499: ERROR:  table "cr_wp_image_attachments" does not exist
psql:wp-slim-drop.sql:501: ERROR:  view "cr_wp_file_attachmentsi" does not exist
psql:wp-slim-drop.sql:502: ERROR:  view "cr_wp_file_attachmentsx" does not exist
psql:wp-slim-drop.sql:503: ERROR:  table "cr_wp_file_attachments" does not exist
psql:wp-slim-drop.sql:505: ERROR:  view "cr_wp_slidesi" does not exist
psql:wp-slim-drop.sql:506: ERROR:  view "cr_wp_slidesx" does not exist
psql:wp-slim-drop.sql:507: ERROR:  Cannot drop table cr_wp_slides because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:508: ERROR:  view "cr_wp_presentationsi" does not exist
psql:wp-slim-drop.sql:509: ERROR:  view "cr_wp_presentationsx" does not exist
psql:wp-slim-drop.sql:510: ERROR:  Cannot drop table cr_wp_presentations because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too
psql:wp-slim-drop.sql:512: ERROR:  RemoveFunction: function wp_slide__get_bullet_items_revision(integer) does not exist
psql:wp-slim-drop.sql:513: ERROR:  RemoveFunction: function wp_slide__get_postamble_revision(integer) does not exist
psql:wp-slim-drop.sql:514: ERROR:  RemoveFunction: function wp_slide__get_bullet_items(integer) does not exist
psql:wp-slim-drop.sql:515: ERROR:  RemoveFunction: function wp_slide__get_postamble(integer) does not exist
psql:wp-slim-drop.sql:517: ERROR:  RemoveFunction: function wp_presentation__set_live_revision(integer) does not exist
psql:wp-slim-drop.sql:519: ERROR:  sequence "wp_style_seq" does not exist
psql:wp-slim-drop.sql:522: ERROR:  RemoveFunction: function wp_style__delete(integer) does not exist
psql:wp-slim-drop.sql:524: ERROR:  RemoveFunction: function wp_style__image_delete(integer) does not exist
psql:wp-slim-drop.sql:525: ERROR:  table "wp_style_images" does not exist
psql:wp-slim-drop.sql:526: ERROR:  Cannot drop table wp_styles because other objects depend on it
    Use DROP ... CASCADE to drop the dependent objects too

    invoked from within
"db_source_sql_file -callback apm_doc_body_callback "[acs_package_root_dir $package_key]/$path""
    ("foreach" body line 3)
    invoked from within
"foreach path $sql_drop_scripts {
    doc_body_append "<li><pre>"
    db_source_sql_file -callback apm_doc_body_callback "[acs_package_root_dir $package_key]..."
    invoked from within
"if {![empty_string_p $sql_drop_scripts]} {

    doc_body_append "Now executing drop scripts.
<ul>
"
    foreach path $sql_drop_scripts {
    doc_body..."
    ("uplevel" body line 54)
    invoked from within
"uplevel {
          ad_page_contract {

    Deletes a package from the database and the filesystem.

    @author Bryan Quinn (mailto:bquinn@arsdigita.com)
    @..."
    (procedure "code::tcl::/www/unima0/packages/acs-admin/www/apm/package-de..." 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..."

Any idea why this happens?

Greetings,
Nima