Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.9
-
Fix Version/s: 2.0
-
Component/s: CiviContribute
-
Labels:None
Description
(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)
Click SEARCH
Error message:
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.