# Issues with Elastic Search

**URL:** <https://forum.shopware.com/t/issues-with-elastic-search/102430>\
**Category:** Shopware 6 (English)\
**Created:** [6. Januar 2024 um 16:00 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430 "2024-01-06T16:00:44Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![odm](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/odm/32/16483_2.png) [@odm](https://forum.shopware.com/u/odm)\
**Post date:** [6. Januar 2024 um 16:00 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/1 "2024-01-06T16:00:44Z")

</div>

I have a prod. store running 6.5.7.3  
I have configured ES for admin like so:  
OPENSEARCH\_URL=127.0.0.1:32778  
SHOPWARE\_ES\_HOSTS=127.0.0.1:32778  
ADMIN\_OPENSEARCH\_URL=127.0.0.1:32778  
SHOPWARE\_ADMIN\_ES\_ENABLED=1  
SHOPWARE\_ADMIN\_ES\_REFRESH\_INDICES=1  
SHOPWARE\_ADMIN\_ES\_INDEX\_PREFIX=sw6\_admin

Admin shows ES is connected,  
When I run index i get the following error:  
Base table or view not found: 1146 Table ‚sw\_dmcas.elasticsearch\_index\_task‘ doesn’t exist"

The rest of the site is running as expected. What am i missing?

---

<div class="post-metadata">

**Author:** ![basti2017](https://avatars.discourse-cdn.com/v4/letter/b/839c29/32.png) [@basti2017](https://forum.shopware.com/u/basti2017)\
**Post date:** [15. Januar 2024 um 10:50 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/2 "2024-01-15T10:50:03Z")

</div>

We are having the same issue. Did you find a solution?

---

<div class="post-metadata">

**Author:** ![odm](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/odm/32/16483_2.png) [@odm](https://forum.shopware.com/u/odm)\
**Post date:** [15. Januar 2024 um 11:09 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/3 "2024-01-15T11:09:29Z")

</div>

Hi Basti  
Had to find the table in an old shopware 6.4.14.X and create the table manually in the 6.5.7.3 database - then everything worked again.  
Really strange that its not part of the installation script.

---

<div class="post-metadata">

**Author:** ![odm](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/odm/32/16483_2.png) [@odm](https://forum.shopware.com/u/odm)\
**Post date:** [15. Januar 2024 um 11:11 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/4 "2024-01-15T11:11:49Z")

</div>

CREATE TABLE `elasticsearch_index_task` (  
`id` binary(16) NOT NULL,  
`index` varchar(500) NOT NULL,  
`alias` varchar(500) NOT NULL,  
`entity` varchar(500) NOT NULL,  
`doc_count` int NOT NULL  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;  
COMMIT;

---

<div class="post-metadata">

**Author:** ![basti2017](https://avatars.discourse-cdn.com/v4/letter/b/839c29/32.png) [@basti2017](https://forum.shopware.com/u/basti2017)\
**Post date:** [17. Januar 2024 um 10:23 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/5 "2024-01-17T10:23:48Z")

</div>

That did it. Thank you!

---

<div class="post-metadata">

**Author:** ![odm](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/odm/32/16483_2.png) [@odm](https://forum.shopware.com/u/odm)\
**Post date:** [30. Januar 2024 um 13:33 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/6 "2024-01-30T13:33:14Z")

</div>

Corrected the SQL:  
CREATE TABLE `elasticsearch_index_task` (  
`id` binary(16) NOT NULL,  
`index` varchar(500) NOT NULL,  
`alias` varchar(500) NOT NULL,  
`entity` varchar(500) NOT NULL,  
`doc_count` int NOT NULL  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

---

<div class="post-metadata">

**Author:** ![odm](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/odm/32/16483_2.png) [@odm](https://forum.shopware.com/u/odm)\
**Post date:** [30. Januar 2024 um 13:34 UTC](https://forum.shopware.com/t/issues-with-elastic-search/102430/7 "2024-01-30T13:34:04Z")

</div>

well its removing formatting of the SQL which makes it fail…

```auto
CREATE TABLE `elasticsearch_index_task` (
  `id` binary(16) NOT NULL,
  `index` varchar(500) NOT NULL,
  `alias` varchar(500) NOT NULL,
  `entity` varchar(500) NOT NULL,
  `doc_count` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

```