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.