# Easy Chart: Database pen

**URL:** <https://forum.inductiveautomation.com/t/easy-chart-database-pen/66510>\
**Category:** Ignition\
**Tags:** ignition81, database, vision\
**Created:** [November 15, 2022, 8:20am UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen/66510 "2022-11-15T08:20:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aljon\_Tanteo](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Aljon\_Tanteo](https://forum.inductiveautomation.com/u/Aljon_Tanteo)\
**Post date:** [November 15, 2022, 8:20am UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen/66510/1 "2022-11-15T08:20:08Z")

</div>

Hi everyone,

I am trying to use the database pen functionality in Easy chart. I'm getting the following error

"Error running query: SQLQuery(query=SELECT t\_stamp, AT 107 FROM analyzer WHERE t\_stamp \>= ? AND t\_stamp \<= ? ORDER BY t\_stamp, database=MySQL)@0ms On: Z4 TRENDS (1).Root Container.Easy Chart"

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/6255b38c09b868b6f8fef3cfaa0067d72fc119f7.png)

Did I miss something here:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/349ecd45da12a83c5e2c8ba6e96d4ebcd127c695.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c0c3b309f34d8ea346b4bb53cda7fec09cdb7c15.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/9/798c03788ce09fd78a5cab5e82770ab8ddb88858.png)

Thanks in advance

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [November 15, 2022, 12:23pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen/66510/2 "2022-11-15T12:23:25Z")

</div>

Having a space in the column names is not considered good practice.

You didn't specify which db you're using, but try putting it in quotes, e.g. `"AT 107" `

---

<div class="post-metadata">

**Author:** ![Aljon\_Tanteo](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Aljon\_Tanteo](https://forum.inductiveautomation.com/u/Aljon_Tanteo)\
**Post date:** [December 5, 2022, 12:53pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen/66510/3 "2022-12-05T12:53:36Z")

</div>

Thank you @JordanCClark , I Just removed the spaces and it worked. 👍
