# Iademo

**URL:** <https://forum.inductiveautomation.com/t/iademo/3104>\
**Category:** Ignition\
**Created:** [July 16, 2011, 7:37am UTC](https://forum.inductiveautomation.com/t/iademo/3104 "2011-07-16T07:37:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![weng](https://avatars.discourse-cdn.com/v4/letter/w/bbce88/32.png) [@weng](https://forum.inductiveautomation.com/u/weng)\
**Post date:** [July 16, 2011, 7:37am UTC](https://forum.inductiveautomation.com/t/iademo/3104/1 "2011-07-16T07:37:05Z")

</div>

when I use the iademo ,I find two problems:  
1: easy chart show nothing  
2: there are errors when execute"system.db.runquery" and other commands on tables in databases  
thank you

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [July 18, 2011, 2:56pm UTC](https://forum.inductiveautomation.com/t/iademo/3104/2 "2011-07-18T14:56:34Z")

</div>

If you downloaded the IADemo project from our website you do have to make sure the MySQL database connection in the gateway is connected not faulted. It sounds like yours is faulted so of course Ignition cannot log data right now.

---

<div class="post-metadata">

**Author:** ![weng](https://avatars.discourse-cdn.com/v4/letter/w/bbce88/32.png) [@weng](https://forum.inductiveautomation.com/u/weng)\
**Post date:** [July 19, 2011, 7:12am UTC](https://forum.inductiveautomation.com/t/iademo/3104/3 "2011-07-19T07:12:24Z")

</div>

Thank you,I have connected to MySQL followed the reandme.txt in IADemo\_7.1.2 folder,The IAdemo executed well except what I mentioned.

---

<div class="post-metadata">

**Author:** ![weng](https://avatars.discourse-cdn.com/v4/letter/w/bbce88/32.png) [@weng](https://forum.inductiveautomation.com/u/weng)\
**Post date:** [July 19, 2011, 7:16am UTC](https://forum.inductiveautomation.com/t/iademo/3104/4 "2011-07-19T07:16:33Z")

</div>

for example ,when I click “?” in upper-right corner of window for help ,there is error :

Traceback (innermost last):

File “event:mouseClicked”, line 2, in ?

File “module:help”, line 5, in openHelp

java.lang.Exception: Error executing system.db.runScalarQuery(SELECT COUNT(\*) FROM WikiPages WHERE Pagename=‘Welcome’, , )

Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Gateway

Error 319: Panel Edition: unable to invoke function “RunQuery”

java.lang.Exception: java.lang.Exception: Error executing system.db.runScalarQuery(SELECT COUNT(\*) FROM WikiPages WHERE Pagename=‘Welcome’, , )

Ignition v7.2.7 (b170)  
Java: Sun Microsystems Inc. 1.6.0\_22

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [July 19, 2011, 3:21pm UTC](https://forum.inductiveautomation.com/t/iademo/3104/5 "2011-07-19T15:21:16Z")

</div>

You have a panel edition license which does not allow running SQL queries. You need to change your license to use that feature.