Hi there,
I found a bug on categories, adding a new category tree. The error happens in the latest oacs core. See bellow my contribution! :) Happy new year!
The solution or fixes that I foresaw were whether amend the datatype substantially or write a quik casting fix to the .xql file. You may guess which one I applied!
<fullquery name="category_tree::add.insert_tree">
<querytext>
select category_tree__new (
:tree_id,
:locale,
:name,
:description,
CAST(:site_wide_p AS boolean),
current_timestamp,
:user_id,
:creation_ip,
:context_id
)
</querytext>
</fullquery>
Best wishes,
Iuri
Error in include template "/packages/categories/lib/tree-form": Transaction aborted: Database operation "0or1row" failed (exception ERROR, "ERROR: column "site_wide_p" is of type boolean but expression is of type character LINE 4: (v_tree_id, p_site_wide_p) ^ HINT: You will need to rewrite or cast the expression. QUERY: insert into category_trees (tree_id, site_wide_p) values (v_tree_id, p_site_wide_p) CONTEXT: PL/pgSQL function "category_tree__new" line 26 at SQL statement ") ERROR: column "site_wide_p" is of type boolean but expression is of type character LINE 4: (v_tree_id, p_site_wide_p) ^ HINT: You will need to rewrite or cast the expression. QUERY: insert into category_trees (tree_id, site_wide_p) values (v_tree_id, p_site_wide_p) CONTEXT: PL/pgSQL function "category_tree__new" line 26 at SQL statement SQL: select category_tree__new ( '425826', 'en_US', 'Geneve', 'Geneve Map. Regions and cartiers listed hierarquically ', 'f', current_timestamp, '667', '192.199.241.135', '6543' )