Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Error adding an item

omfgppc
2011-09-14
2013-03-08
  • omfgppc
    omfgppc
    2011-09-14

    I get this error when I try to add an item. Any ideas on how to fix this?

    "ERROR:  SELECT DISTINCT ON expressions must match initial ORDER BY expressions
    LINE 4:  SELECT  DISTINCT ON ( item_number ) item.*, classcode.*, uo…
                                   ^"
    Please visit: http://www.xtuple.org/node/4450 for the changed document