I get an error after i upgraded to postgres 7.2 (as pltcl does not
work on redhat 7.2 and pg 7.1.3)
[02/May/2002:12:17:14]
Error: dbinit: error(localhost::acs2,ERROR: value too long for
type character(1)
): '
SELECT c.category_id,
lpad('',
48*(category_hierarchy_level(c.category_id, '', 0) - 1),' ') as
indent,
c.category,
c.category_type
FROM categories c,
category_hierarchy h,
category_hierarchy h1
WHERE c.category_id = h.child_category_id
AND h1.parent_category_id IS NULL
AND category_hierarchy_level(h.child_category_id,
h1.child_category_id, 0) is not null
ORDER BY category_type,
category_hierarchy_sortkey(h.child_category_id,
h1.child_category_id, ''),
category_hierarchy_level(c.category_id, '', 0)'
[02/May/2002:12:17:14]
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,
lpad('',
48*(category_hierarchy_level(c.category_id, '', 0) - 1),' ') as
inden..."
(procedure "ad_categorization_widget" line 50)
invoked from within
"ad_categorization_widget -db $db -which_table "news_items"
-what_id $link_id -size 25"
invoked from within
"set category_select [ad_categorization_widget -db $db
-which_table "news_items" -what_id $link_id -size 25]"
(file
"/var/lib/aolserver/servers/defaultacs/www/news/post-new.tcl" line 32)
invoked from within
"source $script"
(procedure "ns_sourceproc" line 6)
invoked from within
Any inputs