Hey there,
I’ve added custom numeric field,
When I tried to build a smart list using this field, I’ve received this error message:
Code:
[DoctrineDBALDBALException]
An exception occurred while executing 'SELECT count(distinct(l.id)) as lead_count, max(id) as max_id FROM leads l LEFT JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (l.id
NOT IN (SELECT new_check.lead_id FROM lead_lists_leads new_check WHERE (new_check.leadlist_id = 16) AND (new_check.lead_id = l.id))) AND ((to_number(l.refid, '9999.99') > ?) A
ND (to_number(l.refid, '9999.99') < ?) AND ((ll.lead_id IS NULL) OR (ll.date_added <= '2015-11-22 11:05:45')))' with params ["18954", "19750"]:
SQLSTATE[22003]: Numeric value out of range: 7 ERROR: numeric field overflow
DETAIL: A field with precision 4, scale 0 must round to an absolute value less than 10^4.
[PDOException]
SQLSTATE[22003]: Numeric value out of range: 7 ERROR: numeric field overflow
DETAIL: A field with precision 4, scale 0 must round to an absolute value less than 10^4.
Any ideas?
Hey there,
I’ve added custom numeric field,
When I tried to build a smart list using this field, I’ve received this error message:
[code][DoctrineDBALDBALException]
An exception occurred while executing ‘SELECT count(distinct(l.id)) as lead_count, max(id) as max_id FROM leads l LEFT JOIN lead_lists_leads ll ON l.id = ll.lead_id WHERE (l.id
NOT IN (SELECT new_check.lead_id FROM lead_lists_leads new_check WHERE (new_check.leadlist_id = 16) AND (new_check.lead_id = l.id))) AND ((to_number(l.refid, ‘9999.99’) > ?) A
ND (to_number(l.refid, ‘9999.99’) < ?) AND ((ll.lead_id IS NULL) OR (ll.date_added <= ‘2015-11-22 11:05:45’)))’ with params [“18954”, “19750”]:
SQLSTATE[22003]: Numeric value out of range: 7 ERROR: numeric field overflow
DETAIL: A field with precision 4, scale 0 must round to an absolute value less than 10^4.
[PDOException]
SQLSTATE[22003]: Numeric value out of range: 7 ERROR: numeric field overflow
DETAIL: A field with precision 4, scale 0 must round to an absolute value less than 10^4.[/code]
Any ideas?
That is clearly a bug. Could you report it to https://github.com/mautic/mautic/issues ?