# Can not send information from S7 to Database(MariaDB) via node-red (FAILED!)

**URL:** <https://discourse.nodered.org/t/can-not-send-information-from-s7-to-database-mariadb-via-node-red-failed/56249>\
**Category:** General\
**Created:** [7 January 2022 11:16 UTC](https://discourse.nodered.org/t/can-not-send-information-from-s7-to-database-mariadb-via-node-red-failed/56249 "2022-01-07T11:16:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sk\_riffat](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@sk\_riffat](https://discourse.nodered.org/u/sk_riffat)\
**Post date:** [7 January 2022 11:16 UTC](https://discourse.nodered.org/t/can-not-send-information-from-s7-to-database-mariadb-via-node-red-failed/56249/1 "2022-01-07T11:16:17Z")

</div>

Hello everyone,

I hope you are having a wonderful day. I am currently working at node red in a project. I am sending information from S7(TIA portal) to a Database(MariaDB) using node-red. I have succesfully connected S7 with node red, but unfortunately not able to send these S7 information to the database. I am getting an error . ["Error: ER\_BAD\_FIELD\_ERROR: Unknown column 'undefined' in 'field list'"].  
Is there anyone who could help? Thank you in advance.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [7 January 2022 15:28 UTC](https://discourse.nodered.org/t/can-not-send-information-from-s7-to-database-mariadb-via-node-red-failed/56249/2 "2022-01-07T15:28:28Z")

</div>

The error means that there is a problem with the database query. Add a debug node showing what you are feeding into the database node, and show us how you have configured the database.

---

<div class="post-metadata">

**Author:** ![sk\_riffat](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@sk\_riffat](https://discourse.nodered.org/u/sk_riffat)\
**Post date:** [10 January 2022 06:39 UTC](https://discourse.nodered.org/t/can-not-send-information-from-s7-to-database-mariadb-via-node-red-failed/56249/3 "2022-01-10T06:39:04Z")

</div>

Thank you for your reply Colin.I have found the solution and can succesfully send the information from s7 to maria DB via node-red after i used the CHANGE node into my flow.I was not familliar with CHANGE node thats why the error was showing. Thank you again

---

<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:** [24 January 2022 06:39 UTC](https://discourse.nodered.org/t/can-not-send-information-from-s7-to-database-mariadb-via-node-red-failed/56249/4 "2022-01-24T06:39:14Z")

</div>

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