Error adding an item


DTSI's picture

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...

Screen shot 2011-09-14 at 10.43.53 AM.PNG32.06 KB
DTSI's picture
Joined: 06/22/2011
Using logs I traced the start

Using logs I traced the start of this (behavior) error back to a failed package install that apparently corrupted my database tables. Fortunately I was working in a test environment.

The moral here is backup your data before you try to install, or update!