Mautic Community Forums

Numeric field overflow

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 ?