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

AttachmentSize
Screen shot 2011-09-14 at 10.43.53 AM.PNG32.06 KB
 
DTSI's picture
Offline
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!