# MySQL Data Logging Issue

**URL:** <https://discourse.nodered.org/t/mysql-data-logging-issue/42294>\
**Category:** General\
**Created:** [9 March 2021 02:44 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294 "2021-03-09T02:44:38Z")\
**Posts on this page:** 8\
**Page:** 2

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [9 March 2021 10:43 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/21 "2021-03-09T10:43:58Z")

</div>

> [@reachrao01](#):
>
> Error:  
> Error: ER\_WARN\_DATA\_OUT\_OF\_RANGE: Out of range value for column 'Word0' at row 1

The problem you have is you are trying to insert `70` in to a field you defined as `decimal(10,9)` which has one digit to the left of the decimal point and 9 to the right.

You can't stuff something bigger into the container you have defined.

(Don't you hate it when the computer does what you told it to do but not what you wanted to do 😁)

---

<div class="post-metadata">

**Author:** ![reachrao01](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@reachrao01](https://discourse.nodered.org/u/reachrao01)\
**Post date:** [9 March 2021 10:45 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/22 "2021-03-09T10:45:28Z")

</div>

WARN:

insert into tblDB1\_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy)  
values (25,53,60,29,90,Now(),'Admin')

Error:  
Error: ER\_WARN\_DATA\_OUT\_OF\_RANGE: Out of range value for column 'Word0' at row 1"

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [9 March 2021 10:52 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/23 "2021-03-09T10:52:07Z")

</div>

Check my previous post, you may have missed it.

---

<div class="post-metadata">

**Author:** ![reachrao01](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@reachrao01](https://discourse.nodered.org/u/reachrao01)\
**Post date:** [10 March 2021 12:56 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/24 "2021-03-10T12:56:00Z")

</div>

Sorry, Yesterday i could not respond to your post because per day i have limit of 20 post 🙂  
Issue has been fixed and it is related to SQL Data Type mapping.

Thank you so much for your support 🙂

---

<div class="post-metadata">

**Author:** ![reachrao01](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@reachrao01](https://discourse.nodered.org/u/reachrao01)\
**Post date:** [10 March 2021 12:56 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/25 "2021-03-10T12:56:31Z")

</div>

Hi Steve,  
Sorry, Yesterday i could not respond to your post because per day i have limit of 20 post 🙂  
Issue has been fixed and it is related to SQL Data Type mapping.

Thank you so much for your support 🙂

---

<div class="post-metadata">

**Author:** ![reachrao01](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@reachrao01](https://discourse.nodered.org/u/reachrao01)\
**Post date:** [11 March 2021 03:06 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/26 "2021-03-11T03:06:38Z")

</div>

# Hi Steve, For the following query, Hardware sending value of Float (like 19.657657666) but query converting this into INT. (Data type is Float in table) and 19 value is inserting to table. Data type may be STRING, INT, BOOL, FLOAT

# //Query

var data = msg.payload;  
msg.topic = `insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (${data.Word0},${data.Word2},${data.Word4},${data.Word6},${data.Word8},Now(),'Admin')`;  
return msg;

---

<div class="post-metadata">

**Author:** ![reachrao01](https://avatars.discourse-cdn.com/v4/letter/r/e495f1/32.png) [@reachrao01](https://discourse.nodered.org/u/reachrao01)\
**Post date:** [11 March 2021 03:28 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/27 "2021-03-11T03:28:28Z")

</div>

# For the following query, Hardware sending value of Float (like 19.657657666) but query converting this into INT. (Data type is Float in table) and 19 value is inserting to table.

Data type may be STRING, INT, BOOL, FLOAT

# //Query

var data = msg.payload;  
msg.topic = `insert into tblDB1_Test (Word0,Word2,Word4,Word6,Word8,LastUpdatedOn,LastUpdatedBy) values (${data.Word0},${data.Word2},${data.Word4},${data.Word6},${data.Word8},Now(),'Admin')` ;  
return msg;

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [10 May 2021 03:29 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294/28 "2021-05-10T03:29:01Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.

[Previous page](https://discourse.nodered.org/t/mysql-data-logging-issue/42294.md?page=1)