# Shopware Import/Export Fehler bei Installation

**URL:** <https://forum.shopware.com/t/shopware-import-export-fehler-bei-installation/43685>\
**Category:** Allgemein\
**Created:** [14. Februar 2017 um 07:20 UTC](https://forum.shopware.com/t/shopware-import-export-fehler-bei-installation/43685 "2017-02-14T07:20:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![megadruck](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@megadruck](https://forum.shopware.com/u/megadruck)\
**Post date:** [14. Februar 2017 um 07:20 UTC](https://forum.shopware.com/t/shopware-import-export-fehler-bei-installation/43685/1 "2017-02-14T07:20:58Z")

</div>

Habt Ihr auch den Fehler, wenn Ihr versucht das Plugin Shopware Import/Export zu installieren ?

Error

Unable to install, got exception: An exception occurred while executing ’ INSERT IGNORE INTO s\_import\_export\_profile (`type`, `name`, `description`, `tree`, `hidden`, `is_default`) VALUES (?, ?, ?, ?, ?, ?) ’ with params [“categories”, “default\_categories\_minimal”, “default\_categories\_minimal\_description”, “{“id”:“root”,“name”:“Root”,“type”:“node”,“children”:[{“id”:“537359399c80a”,“name”:“Header”,“index”:“0”,“type”:“node”,“children”:[{“id”:“537385ed7c799”,“name”:“HeaderChild”,“index”:“0”,“type”:“node”,“shopwareField”:”"}]},{“id”:“537359399c8b7”,“name”:“categories”,“index”:“1”,“type”:“node”,“children”:[{“id”:“537359399c90d”,“name”:“category”,“index”:“0”,“type”:“iteration”,“adapter”:“default”,“attributes”:"",“children”:[{“id”:“53e9f539a997d”,“type”:“leaf”,“index”:“0”,“name”:“categoryId”,“shopwareField”:“categoryId”},{“id”:“53e0a853f1b98”,“type”:“leaf”,“index”:“1”,“name”:“parentID”,“shopwareField”:“parentId”},{“id”:“57ff840eab2d9”,“type”:“leaf”,“index”:“2”,“name”:“name”,“shopwareField”:“name”,“defaultValue”:""}]}]}]}", 0, 1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘description’ in ‘field list’

---

<div class="post-metadata">

**Author:** ![JanineOverhausKocan](https://avatars.discourse-cdn.com/v4/letter/j/65b543/32.png) [@JanineOverhausKocan](https://forum.shopware.com/u/JanineOverhausKocan)\
**Post date:** [14. Februar 2017 um 09:43 UTC](https://forum.shopware.com/t/shopware-import-export-fehler-bei-installation/43685/2 "2017-02-14T09:43:45Z")

</div>

Hallo,

hier fehlt eine Spalte in der Datenbank.

Description kann über dieses Insert-Statement angelegt werden:

```
ALTER TABLE `s_import_export_profile` CHANGE `description` `description1` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

```

Viele Grüße aus Schöppingen  
Janine

---

<div class="post-metadata">

**Author:** ![megadruck](https://avatars.discourse-cdn.com/v4/letter/m/f17d59/32.png) [@megadruck](https://forum.shopware.com/u/megadruck)\
**Post date:** [14. Februar 2017 um 09:53 UTC](https://forum.shopware.com/t/shopware-import-export-fehler-bei-installation/43685/3 "2017-02-14T09:53:53Z")

</div>

ich denke eher&nbsp;ADD.

&nbsp;

Aber danke

---

<div class="post-metadata">

**Author:** ![JanineOverhausKocan](https://avatars.discourse-cdn.com/v4/letter/j/65b543/32.png) [@JanineOverhausKocan](https://forum.shopware.com/u/JanineOverhausKocan)\
**Post date:** [14. Februar 2017 um 14:51 UTC](https://forum.shopware.com/t/shopware-import-export-fehler-bei-installation/43685/4 "2017-02-14T14:51:17Z")

</div>

Sorry natürlich ADD anstelle von CHANGE.

Zu den fehlenden Spalten haben wir auch aktuell eine Überprüfung für das Plugin vorgesehen, da hier teilweise die Spalten description und is\_default fehlen.