Forum OpenACS Q&A: Errors reported on PG 7.2 and open acs 3.2.5

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
Collapse
Posted by Peter Alberer on
I realized the following: If you supply a value that is longer than 1 character to a table field that is defined to be one character -> PG7.1 truncated the input to be one character and did not return an error. PG7.2 returns an error. Dont know if this helps here...