Forum OpenACS Q&A: Problem in cataegory tree map

Collapse
Posted by amit singh on
I was able to create catagories in the catagories module, sub
categories also. But when i click on the catagorey tree i get an error
log as

"6/Dec/2000:11:36:09]
    Error: dbinit: error(localhost::iigpdb,ERROR:  parser: parse error
at or near "("
    ): 'SELECT c.category_id, c.category, c.category_type,
c.profiling_weight, c.enabled_p, cat_tree.rownum_col,
cat_tree.level_col, COUNT(ui.user_id) AS n_interested_users
    FROM users_interests ui, categories c,
    (SELECT h.child_category_id, ROWNUM as rownum_col, LEVEL AS
level_col
    FROM category_hierarchy h
    START WITH h.parent_category_id IS NULL
    CONNECT BY PRIOR h.child_category_id = h.parent_category_id)
cat_tree
    WHERE c.category_id = cat_tree.child_category_id
    AND c.category_id = ui.category_id (+)
    GROUP BY c.category_id,    c.category, c.category_type,
c.profiling_weight, c.enabled_p, cat_tree.rownum_col,
cat_tree.level_col
    ORDER BY cat_tree.rownum_col'

[16/Dec/2000:11:36:09]
    Error: Database operation "select" failed (exception NSDB, "Query
was not a statement returning rows.")
    Database operation "select" failed (exception NSDB, "Query was not
a statement returning rows.")
        while executing
    "ns_db select $db "SELECT c.category_id, c.category,
c.category_type, c.profiling_weight, c.enabled_p, cat_tree.rownum_col,
cat_tree.level_col, COUNT(u ..."
        invoked from within
    "set selection [ns_db select $db "SELECT c.category_id,
c.category, c.category_type, c.profiling_weight, c.enabled_p,
cat_tree.rownum_col, cat_tree.lev ..."
        (file "/web/iig.org.in/www/admin/categories/tree.tcl" line 13)
        invoked from within
    "source $script"
        invoked from within
    "if ![file exists $script] {
                ns_returnnotfound $conn
        } else {
                source $script
        }"
        (procedure "ns_sourceproc" line 3)
        invoked from within
    "ns_sourceproc cns104 {}"
    Notice: Querying 'select ad_group_member_p(1,
system_administrator_group_id()) from dual;'

I can not get a head an tail out of the log.

Other thing is how can i reflect these catagories in the news module.

Collapse
Posted by Don Baccus on
PG 7.0 doesn't support subselects in the "from" clause (the upcoming
PG 7.1 does), so you've found a query that wasn't ported over from
Oracle to PostgreSQL.

I may have time tomorrow to dig into this and a handful of other
problems...