# Cronjob Refresh search index mit MySQL-Errors

**URL:** <https://forum.shopware.com/t/cronjob-refresh-search-index-mit-mysql-errors/42728>\
**Category:** Administration\
**Created:** [12. Januar 2017 um 09:35 UTC](https://forum.shopware.com/t/cronjob-refresh-search-index-mit-mysql-errors/42728 "2017-01-12T09:35:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![R4M](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/r4m/32/9983_2.png) [@R4M](https://forum.shopware.com/u/R4M)\
**Post date:** [12. Januar 2017 um 09:35 UTC](https://forum.shopware.com/t/cronjob-refresh-search-index-mit-mysql-errors/42728/1 "2017-01-12T09:35:47Z")

</div>

Nach dem Update auf 5.2.9 läuft der Cronjon bei Refresh search index nicht mehr korrekt. Im Backend bei den Ereignisdaten steht dann nur noch:

```
array (
  'error' => 'An exception occurred while executing \'INSERT IGNORE INTO s_search_index (keywordID, elementID, fieldID)

SELECT sk.id as keywordID, as elementID, 12 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (\'aufkleber\')

... hunderte solcher Zeilen ...

... am Ende:

SQLSTATE[42000]: 
Syntax error or access violation: 
1064 You have an error in your SQL syntax; 
check the manual that corresponds to your MariaDB server version for the right syntax to use near \'as elementID, 12 as fieldID FROM s_search_keywords sk WHERE sk.keyword IN (\'aust\' at line 163',)

```

**Wie kann ich den Fehler beheben?**

&nbsp;

---

<div class="post-metadata">

**Author:** ![R4M](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/r4m/32/9983_2.png) [@R4M](https://forum.shopware.com/u/R4M)\
**Post date:** [13. Januar 2017 um 07:49 UTC](https://forum.shopware.com/t/cronjob-refresh-search-index-mit-mysql-errors/42728/2 "2017-01-13T07:49:03Z")

</div>

Bis jetzt konnte ich heraus finden, dass diese Query aus der Klasse SearchIndexer kommen. **Aber was verursacht die Fehlermeldung am Ende?**