# Migration Error in extJS

**URL:** https://forum.shopware.com/t/migration-error-in-extjs/47028
**Category:** Installation/Einstieg
**Created:** [20. Juli 2017 um 11:55 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028 "2017-07-20T11:55:03Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![motz](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@motz](https://forum.shopware.com/u/motz)
#### Post date: [20. Juli 2017 um 11:55 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/1 "2017-07-20T11:55:03Z")

</div>

Hallo,

Shopware: 5.2.27  
PHP: 5.6 und 7.0  
Import von PrestaShop zu Shopware

bei mir funktioniert in verschiedenen Installationen das Plug-in Shop-Migration nicht. Ich bekomme folgenden fehler wenn ich nach der Eingabe der Datenbank Daten auf weiter klicke:

&nbsp;

```
Uncaught TypeError: Cannot read property 'message' of undefined
    at i.failure (VM1786 Wizard&no-cache=1500549386+1+1:1270)
    at Object.callback (ext-all.js?201706221543:21)
    at i.afterAction (ext-all.js?201706221543:21)
    at i.onFailure (ext-all.js?201706221543:21)
    at Object.callback (ext-all.js?201706221543:21)
    at i.onComplete (ext-all.js?201706221543:21)
    at i.onStateChange (ext-all.js?201706221543:21)
    at XMLHttpRequest. (ext-all.js?201706221543:21)
failure @ VM1786 Wizard&no-cache=1500549386+1+1:1270
callback @ ext-all.js?201706221543:21
afterAction @ ext-all.js?201706221543:21
onFailure @ ext-all.js?201706221543:21
callback @ ext-all.js?201706221543:21
onComplete @ ext-all.js?201706221543:21
onStateChange @ ext-all.js?201706221543:21
(anonymous) @ ext-all.js?201706221543:21

```

&nbsp;

---

<div class="post-metadata">

### Author: ![motz](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@motz](https://forum.shopware.com/u/motz)
#### Post date: [24. Juli 2017 um 12:28 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/2 "2017-07-24T12:28:28Z")

</div>

Hab jetzt mal folgendes in die config.php gepackt für die fehlerausgabe.

&nbsp;

```
'front' => [
        'showException' => true
    ],
    'phpsettings' => [
        'display_errors' => 1,
    ],
);

```

Und jetzt sehe ich im Firebug folgendes:

&nbsp;

```
uncaught exception: Ext.JSON.decode(): You're trying to decode an invalid JSON String: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1wlanbox_test.s_core_snippets' doesn't exist' in /var/www/clients/client1/web24/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91
Stack trace:
#0 /var/www/clients/client1/web24/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(Array)

```

Das Migrations Tool greift auf die falsche Datenbank Tabelle zu “c1wlanbox\_test.s\_core\_snippets”. Die gibt es aber nicht in der Quell DB. Soll ja von Presta zu Shopware.

---

<div class="post-metadata">

### Author: ![schwarztea](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@schwarztea](https://forum.shopware.com/u/schwarztea)
#### Post date: [2. August 2017 um 15:03 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/3 "2017-08-02T15:03:09Z")

</div>

Hallo,

ich habe das gleiche Problem. Hast du schon eine Lösung gefunden?  
Falls nicht, hat jemand eine Lösung dafür?

Ich möchte&nbsp;xt:Commerce VEYTON&nbsp;4.1 zu Shopware (Version 5.2.27) Migrieren.&nbsp;

Gruß  
Thomas

---

<div class="post-metadata">

### Author: ![motz](https://avatars.discourse-cdn.com/v4/letter/m/bbce88/32.png) [@motz](https://forum.shopware.com/u/motz)
#### Post date: [2. August 2017 um 15:09 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/4 "2017-08-02T15:09:02Z")

</div>

Hallo,

ja ich musste das prefix angeben was bei der Quell Datenbank angegeben wurde “p\_” schau ob du in deiner xt datenbank auch eins hast und gib es bei der Migration an. Mir hat es geholfen.

---

<div class="post-metadata">

### Author: ![schwarztea](https://avatars.discourse-cdn.com/v4/letter/s/e9a140/32.png) [@schwarztea](https://forum.shopware.com/u/schwarztea)
#### Post date: [3. August 2017 um 11:19 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/5 "2017-08-03T11:19:11Z")

</div>

Hallo,

danke für deine schnelle Antwort. Das habe ich auch schon probiert. Leider kommt bei mir wieder der gleiche Fehler.

```
sourceClass: "Ext.JSON", sourceMethod: "decode", msg: "You're trying to decode an invalid JSON String: on line 234↵", message: "You're trying to decode an invalid JSON String: on line 234↵"}
message
:
"You're trying to decode an invalid JSON String: ↵Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zsp_xtc_live.s_core_snippets' doesn't exist' in /Applications/MAMP/htdocs/zsp/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91↵Stack trace:↵#0 /Applications/MAMP/htdocs/zsp/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(Array)↵#1 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Statement/Pdo.php(228): Doctrine\DBAL\Driver\PDOStatement->execute(Array)↵#2 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)↵#3 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)↵#4 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `s_cor...', Array)↵#5 /Applications/MAMP/htdocs/zsp/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abs in /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Statement/Pdo.php on line 234↵"
msg
:
"You're trying to decode an invalid JSON String: ↵Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zsp_xtc_live.s_core_snippets' doesn't exist' in /Applications/MAMP/htdocs/zsp/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91↵Stack trace:↵#0 /Applications/MAMP/htdocs/zsp/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(Array)↵#1 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Statement/Pdo.php(228): Doctrine\DBAL\Driver\PDOStatement->execute(Array)↵#2 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)↵#3 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)↵#4 /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `s_cor...', Array)↵#5 /Applications/MAMP/htdocs/zsp/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abs in /Applications/MAMP/htdocs/zsp/engine/Library/Zend/Db/Statement/Pdo.php on line 234↵"
sourceClass
:
"Ext.JSON"
sourceMethod
:
"decode"

```

Hoffentlich kann mir jemand helfen.

Vielen Dank.

Gruß  
Thomas

---

<div class="post-metadata">

### Author: ![Tschaenssen](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@Tschaenssen](https://forum.shopware.com/u/Tschaenssen)
#### Post date: [21. Dezember 2017 um 13:20 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/6 "2017-12-21T13:20:55Z")

</div>

Hallo,

ich hole diesen Beitrag mal wieder nach oben. Bei mir tritt das gleiche Problem auf. Hat hier mittlerweile jemand eine Lösung gefunden?

Gruß

Steffen

---

<div class="post-metadata">

### Author: ![f\_kunz](https://avatars.discourse-cdn.com/v4/letter/f/a5b964/32.png) [@f\_kunz](https://forum.shopware.com/u/f_kunz)
#### Post date: [23. Dezember 2017 um 15:42 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/7 "2017-12-23T15:42:42Z")

</div>

Ich bin auch gerade über den Fehler gestolpert bei dem Versuch eine WooCommerce Datenbank zu migrieren.  
Aktuelle Shopware Version ( **Shopware 5.3.4&nbsp;** Build Rev 201710241020) mit Migration Plugin&nbsp;2.5.1

```
... Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wordpress.s_core_snippets' doesn't exist in ...

```

&nbsp;

---

<div class="post-metadata">

### Author: ![Tschaenssen](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@Tschaenssen](https://forum.shopware.com/u/Tschaenssen)
#### Post date: [23. Dezember 2017 um 16:01 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/8 "2017-12-23T16:01:19Z")

</div>

Hallo,

ich konnte das Problem bei mir beheben. Da es sich bei mir um die Migration von XT Commerce 5 handelt musste ich die Datenbank anpassen. Ich habe in der Tabelle xt\_store das Feld shop\_title oder shop\_name hinzufügen müssen. Da ich nicht am PC bin kann ich das gerade nicht genau sagen. Im Anschluss hat bis auf den Kategorie Import und die Artikelzuordnung alles funktioniert.&nbsp;

Gruß Steffen

---

<div class="post-metadata">

### Author: ![klickpark](https://avatars.discourse-cdn.com/v4/letter/k/d78d45/32.png) [@klickpark](https://forum.shopware.com/u/klickpark)
#### Post date: [16. April 2018 um 13:38 UTC](https://forum.shopware.com/t/migration-error-in-extjs/47028/9 "2018-04-16T13:38:57Z")

</div>

Bei mir tritt leider das gleiche Problem auf.

Versuche&nbsp; **xt:Commerce VEYTON 4.0 bis 4.1** &nbsp;per _Shop-Migration_&nbsp;in&nbsp; **Shopware 5.3.3** &nbsp;zu migrieren.

- PHP 7.0.18
- NGINX

**You’re trying to decode an invalid JSON String**

```
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DATABASENAMEHERE.s_core_snippets' doesn't exist in /var/www/clients/client114/web473/test/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91 Stack trace: #0 /var/www/clients/client114/web473/test/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(91): PDOStatement->execute(Array) #1 /var/www/clients/client114/web473/test/engine/Library/Zend/Db/Statement/Pdo.php(219): Doctrine\DBAL\Driver\PDOStatement->execute(Array) #2 /var/www/clients/client114/web473/test/engine/Library/Zend/Db/Statement.php(317): Zend_Db_Statement_Pdo->_execute(Array) #3 /var/www/clients/client114/web473/test/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #4 /var/www/clients/client114/web473/test/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('DESCRIBE `s_cor...', Array) #5 /var/www/clients/client114/web473/test/engine/Library/Enlight/Components/Db/Adapter/Pdo/M in /var/www/clients/client114/web473/test/engine/Library/Zend/Db/Statement/Pdo.php on line 224

```

&nbsp;

**UPDATE:**

I found a solution.

Unfortunately I chose the wrong profile.&nbsp;The migration works with&nbsp; **XTModified & xt:Commerce 3.0.4&nbsp;** selected.
