Error adding an item
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.PNG||32.06 KB|
Thu, 09/15/2011 - 06:47#1
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!