Forum .LRN Q&A: WP-Slim Package

Collapse
Posted by Nima Mazloumi on
Hi everybody,

wimpy point is not delivered with .lrn 2.0b.
does someone know if the current version available under cvs is compatible to openacs 5.0 and .lrn 2.0b?

Greetings,
Nima

Collapse
2: Re: WP-Slim Package (response to 1)
Posted by Nima Mazloumi on
got the package from cvs...sorry ;)
Collapse
3: Wimpy-Point Error (response to 1)
Posted by Nima Mazloumi on
Unfortunately I get the following message if I want to see a simple slide:

Request Error
Query did not return any rows.
    while executing
"db_1row get_presentation {
select pres_title
from cr_wp_presentations p,
    cr_items i
where i.item_id = :pres_item_id
and  i.live_revision = ..."
    ("uplevel" body line 22)
    invoked from within
"uplevel {
          # /packages/wp/www/create-slide.tcl
ad_page_contract {

    # This file presents the form for users to create a slide.
    ..."
    (procedure "code::tcl::/www/unima0/packages/wp-slim/www/create-slide" 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..."

--------------------------------------------------------------------------------

AOLserver/3.3.1+ad13

Collapse
4: Re: WP-Slim Package (response to 1)
Posted by Rocael Hernández Rizzardini on
I'll check this out, are you using oracle or PG?
Collapse
5: Re: WP-Slim Package (response to 4)
Posted by Nima Mazloumi on
I am using postgres ;)
Collapse
6: Re: WP-Slim Package (response to 1)
Posted by Rocael Hernández Rizzardini on
Hello Nima, just wondering what could be happening in you installations, in a new fresh oacs /wp-slim install everything worked fine ...
Can you try to install again ...?
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

Collapse
8: Re: WP-Slim Package (response to 1)
Posted by Nima Mazloumi on
I executed the drop.sql manually and deleted all the view, tables, functions from the database. Also I had to go through cr_folder_type_map and delete all the entries there. Now the installation worked out.
I created an instance but now i get lots of MESSAGE KEY MISSING's on the website.

Any idea why this happens? I looked inside the catalog folder and there are at least two xml files for english and spanish.

Greetings,
Nima

Collapse
9: Re: WP-Slim Package (response to 1)
Posted by Rocael Hernández Rizzardini on
Seems that for some reason the catalogs where not loaded when you installed the package ?? ...

Maybe, you can go to the APM/wp-slim, then on the internationalization link press:

Import messages from catalog files to the database

Collapse
10: Re: WP-Slim Package (response to 1)
Posted by Nima Mazloumi on
cool...it works now. I will test if I can create new presentations... greetings