# History show nothing expect sql-syntax

**URL:** <https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109>\
**Category:** Icinga Web\
**Tags:** markdown, history, icingaweb2\
**Created:** [July 29, 2020, 6:11am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109 "2020-07-29T06:11:53Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![TsJu00](https://community.icinga.com/letter_avatar_proxy/v4/letter/t/22d042/32.png) [@TsJu00](https://community.icinga.com/u/TsJu00)\
**Post date:** [July 29, 2020, 6:11am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/1 "2020-07-29T06:11:53Z")

</div>

Here I am again, when I click on the web interface on history I only get sql-syntax … that´s not what I would like to see … anybody have some ideas?

 ![image](https://community.icinga.com/uploads/default/original/2X/d/dcd684299324f0640500d4de1f83e90af37c7e9a.png)

Greetings

---

<div class="post-metadata">

**Author:** ![rsx](https://community.icinga.com/user_avatar/community.icinga.com/rsx/32/2094_2.png) [@rsx](https://community.icinga.com/u/rsx)\
**Post date:** [July 29, 2020, 7:15am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/2 "2020-07-29T07:15:28Z")

</div>

You have been trying so many changes during your [session](https://community.icinga.com/t/satellite-doesn-t-check-clients/5092) and maybe your database(s) got screwed up. I’d recommend to to drop them all and recreate a empty but clean database:

```auto
# systemctl stop icinga2
# mysql -u root -p
DROP DATABASE icinga;
CREATE DATABASE icinga;
exit

# mysql -u root -p icinga < /usr/local/share/icinga2-ido-mysql/schema/mysql.sql
# systemctl start icinga2

```

(adapt the name of the database to your needs)

---

<div class="post-metadata">

**Author:** ![TsJu00](https://community.icinga.com/letter_avatar_proxy/v4/letter/t/22d042/32.png) [@TsJu00](https://community.icinga.com/u/TsJu00)\
**Post date:** [July 29, 2020, 7:20am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/3 "2020-07-29T07:20:47Z")

</div>

What will happening with my monitoring, when i do this?

All of my configuration will be away, or?

---

<div class="post-metadata">

**Author:** ![rsx](https://community.icinga.com/user_avatar/community.icinga.com/rsx/32/2094_2.png) [@rsx](https://community.icinga.com/u/rsx)\
**Post date:** [July 29, 2020, 7:27am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/4 "2020-07-29T07:27:13Z")

</div>

You will lose your history. Your config is not defined in the database but conf files, right?

---

<div class="post-metadata">

**Author:** ![nilmerg](https://community.icinga.com/user_avatar/community.icinga.com/nilmerg/32/277_2.png) [@nilmerg](https://community.icinga.com/u/nilmerg)\
**Post date:** [July 29, 2020, 7:27am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/5 "2020-07-29T07:27:30Z")

</div>

Wait a moment. I didn’t follow the previous discussion, but before you purge your database please tell me the following:

- which Icinga Web 2 version is this?
- have you entered a charset for the IDO resource, and which if so?
  - please try changing the charset to `latin1` if not

---

<div class="post-metadata">

**Author:** ![TsJu00](https://community.icinga.com/letter_avatar_proxy/v4/letter/t/22d042/32.png) [@TsJu00](https://community.icinga.com/u/TsJu00)\
**Post date:** [July 29, 2020, 7:30am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/6 "2020-07-29T07:30:30Z")

</div>

- My Icinga Web Version is 2.8.1
- I don´t have any charset for my ido ressource (I will try latin1)

---

<div class="post-metadata">

**Author:** ![TsJu00](https://community.icinga.com/letter_avatar_proxy/v4/letter/t/22d042/32.png) [@TsJu00](https://community.icinga.com/u/TsJu00)\
**Post date:** [July 29, 2020, 7:32am UTC](https://community.icinga.com/t/history-show-nothing-expect-sql-syntax/5109/7 "2020-07-29T07:32:47Z")

</div>

It works, thank you!