Forum OpenACS Q&A: uninstalled bookmarks module and ACS 3.2.4

On a fresh install of ACS 3.2.4, I got the following errors:

[22/Sep/2000:23:30:23]
    Error: Ns_PgExec: result status: 7 message: ERROR:  Relation
'bm_list' does not exist
    
    Notice: ad_summarize_user_contributions got an error calling
bm_user_contributions:  Database operation "1row" failed (exception
NSDB, "Query was not a statement returning rows.")

I understand that the bookmarks module is not ready yet for prime time, and hence the data model for the bookmarks module is not loaded by default. Should the bookmarks-def.tcl be left unloaded, too (when aolserver initializes)? I got rid of the above errors (or rather, I haven't gotten the same errors yet) when I put "return" as the first command in bookmarks-def.tcl.

This probably belongs to SDM, but there is no bookmarks module entry in SDM.

I wish I saw the development of ACS 3.2.4 on cvs, but I must be missing something obvious: how do I access the cvs of OpenACS?

I just about have the bookmarks module ported over - I'm hoping to have it finished this afternoon... we'll see. If it's up to snuff and there's interest in having it, perhaps it can be added to the 3.2.4 release.

-Alex

I'm sure someone much brighter than I is working on the bookmarks issues, but to get it working (the index page anyway) I converted the bookmark_query statement in /bookmarks/index.tcl from an outer join to a union. The order by is different here as well as PG doesn't support '||' for varchars (?). If this has already been done I couldn't find in the CVS.

select
    bl1.bookmark_id,
    bl1.url_id,
    coalesce (bl1.local_title, bu1.url_title) as bookmark_title,
    bl1.hidden_p,
    bu1.complete_url,
    bu1.last_live_date,
    bu1.last_checked_date,
    bl1.folder_p,
    bl1.closed_p,
    length (bl1.parent_sort_key) * 8 as indent_width
from
    bm_list bl1, bm_urls bu1
where
    bl1.url_id = bu1.url_id
    and owner_id = 3
    and in_closed_p = 'f'
union all
select
    bl2.bookmark_id,
    bl2.url_id,
    bl2.local_title as bookmark_title,
    bl2.hidden_p,
    null as complete_url,
    null as last_live_date,
    null as last_checked_date,
    bl2.folder_p,
    bl2.closed_p,
    length (bl2.parent_sort_key) * 8 as indent_width
from
    bm_list bl2
where
    bl2.url_id not in
        (select url_id from bm_urls bu2)
    and owner_id = 3
    and in_closed_p = 'f'
order by
    parent_sort_key, local_sort_key
;

We've had recent postings about completed ports of the bookmarks module, though after checking in cvs, it appears that neither one has been checked in(?).

Pg does support '||' on varchar, but you sometimes need to add a cast to get things to work correctly. You can also do something like:

select parent_sort_key || local_sort_key as sort_key, 

	...

order by sort_key