Affects Version/s: 1.9
Fix Version/s: 2.0
(Verified in 1.9.12432)
Go to CiviContribute >> Find Contribution.
Search for Contribution dates from Jan 1 2007 to Dec 31 2007 (probably not important)
Minimum amount 1 maximum amount 100,000 (the comma IS important)
Sorry. A non-recoverable error has occurred.
Database Error Code: Operand should contain 1 column(s), 1241
yada yada SELECT ... AND civicrm_contribution.total_amount <= 100,000 AND ... yada yada
Note absence of quotes around the amount!
If the comma is removed from the form, the query works correctly.