[ic] Cant Edit Items from UI

Mark Johnson interchange-users@lists.akopia.com
Mon Aug 6 14:43:00 2001


Admin Account wrote:
> 
> I am getting the following error when I
> try to edit items in UI.
> 
> Bad SQL, query was: select DISTINCT category, category FROM products ORDER
> BY category

Some databases will not tolerate the column repetition, and it may be
that SQL::Statement also gets confused with column repetition. I am
pretty sure Mike addressed this and patched it. However, it may not have
been done as of the date of your install.


-- 
Mark Johnson
Senior Systems Architect - Professional Services
Red Hat, Inc.
E-Business Solutions
markj@redhat.com
703-456-2912