# Numeric field overflow

**URL:** https://forum.mautic.org/t/numeric-field-overflow/2823
**Category:** Product Support
**Created:** [November 22, 2015, 11:20am UTC](https://forum.mautic.org/t/numeric-field-overflow/2823 "2015-11-22T11:20:05Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![nickchernets](https://avatars.discourse-cdn.com/v4/letter/n/0ea827/32.png) [@nickchernets](https://forum.mautic.org/u/nickchernets)
#### Post date: [November 22, 2015, 11:20am UTC](https://forum.mautic.org/t/numeric-field-overflow/2823/1 "2015-11-22T11:20:05Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![nickchernets](https://avatars.discourse-cdn.com/v4/letter/n/0ea827/32.png) [@nickchernets](https://forum.mautic.org/u/nickchernets)
#### Post date: [November 22, 2015, 11:20am UTC](https://forum.mautic.org/t/numeric-field-overflow/2823/2 "2015-11-22T11:20:05Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [November 23, 2015, 1:35pm UTC](https://forum.mautic.org/t/numeric-field-overflow/2823/3 "2015-11-23T13:35:19Z")

</div>

That is clearly a bug. Could you report it to [https://github.com/mautic/mautic/issues](https://github.com/mautic/mautic/issues) ?

---

<div class="post-metadata">

### Author: ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)
#### Post date: [February 2, 2020, 10:56pm UTC](https://forum.mautic.org/t/numeric-field-overflow/2823/4 "2020-02-02T22:56:50Z")

</div>