Nach Erstellen eines Freitextfeldes kommt Ups! ein Fehler ist aufgetreten

 Habe eigentlich nur ein Freitextfeld (zum Glück erstmal nur in der lokalen Testumgebung) erstellt. Shop geht nicht mehr. Jetzt kommt die Meldung: 

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. Type of association must be one of *_TO_ONE or MANY_TO_MANY in C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\SqlWalker.php on line 1028 Stack trace: #0 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\SqlWalker.php(1155): Doctrine\ORM\Query\SqlWalker->walkJoinAssociationDeclaration(Object(Doctrine\ORM\Query\AST\JoinAssociationDeclaration), 1, NULL) #1 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\SqlWalker.php(837): Doctrine\ORM\Query\SqlWalker->walkJoin(Object(Doctrine\ORM\Query\AST\Join)) #2 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\SqlWalker.php(815): Doctrine\ORM\Query\SqlWalker->walkIdentificationVariableDeclaration(Object(Doctrine\ORM\Query\AST\IdentificationVariableDeclaration)) #3 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\SqlWalker.php(522): Doctrine\ORM\Query\SqlWalker->walkFromClause(Object(Doctrine\ORM\Query\AST\FromClause)) #4 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\Exec\SingleSelectExecutor.php(42): Doctrine\ORM\Query\SqlWalker->walkSelectStatement(Object(Doctrine\ORM\Query\AST\SelectStatement)) #5 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\SqlWalker.php(277): Doctrine\ORM\Query\Exec\SingleSelectExecutor->__construct(Object(Doctrine\ORM\Query\AST\SelectStatement), Object(Doctrine\ORM\Query\SqlWalker)) #6 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\Parser.php(390): Doctrine\ORM\Query\SqlWalker->getExecutor(Object(Doctrine\ORM\Query\AST\SelectStatement)) #7 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query.php(281): Doctrine\ORM\Query\Parser->parse() #8 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query.php(293): Doctrine\ORM\Query->_parse() #9 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php(969): Doctrine\ORM\Query->_doExecute() #10 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php(924): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3) #11 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php(751): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #12 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Tools\Pagination\Paginator.php(151): Doctrine\ORM\AbstractQuery->getScalarResult() #13 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Controllers\Backend\Category.php(167): Doctrine\ORM\Tools\Pagination\Paginator->getIterator() #14 C:\MAMP\htdocs\shopwaredemo\engine\Library\Enlight\Controller\Action.php(159): Shopware_Controllers_Backend_Category->getDetailAction() #15 C:\MAMP\htdocs\shopwaredemo\engine\Library\Enlight\Controller\Dispatcher\Default.php(523): Enlight_Controller_Action->dispatch('getDetailAction') #16 C:\MAMP\htdocs\shopwaredemo\engine\Library\Enlight\Controller\Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #17 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Kernel.php(182): Enlight_Controller_Front->dispatch() #18 C:\MAMP\htdocs\shopwaredemo\vendor\symfony\http-kernel\HttpCache\HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Components\HttpCache\AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #20 C:\MAMP\htdocs\shopwaredemo\vendor\symfony\http-kernel\HttpCache\HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #21 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Components\HttpCache\AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #22 C:\MAMP\htdocs\shopwaredemo\shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main}

 

 

Wie kriege ich das wieder weg?

Hoffe jemand kann mir helfen.

 

ps: Wenn ich auf den Speichernbutton klicke kommt noch die Meldung "Kategorie wurde nicht gespeichert.
No mapping found for field ‚category‘ on class ‚Shopware\Models\Attribute\Category‘. "

 

ps ps:

Habe die Datenbanken zurückgesetzt und die Demodaten geladen, Fehler kommt immer noch.

Ich brauche Hilfe!

 

ps ps ps:

Habe mal die Zeile 1028 in SqlWalker.php angeschaut. Der default-Wert wirft hier den Fehler aus, wenn die switch-Abfrage kein anderes Ergebnis liefert. Nach dem auskommentieren der Zeile erhalte ich diese Meldung:

Ups! Ein Fehler ist aufgetreten!

    
        Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
    

    An exception occurred while executing 'SELECT DISTINCT s0_.id AS id_0 FROM s_categories s0_ LEFT JOIN ON LEFT JOIN s_emotion_categories s3_ ON s0_.id = s3_.category_id LEFT JOIN s_emotion s2_ ON s2_.id = s3_.emotion_id LEFT JOIN s_media s4_ ON s0_.mediaID = s4_.id LEFT JOIN s_categories_avoid_customergroups s6_ ON s0_.id = s6_.categoryID LEFT JOIN s_core_customergroups s5_ ON s5_.id = s6_.customergroupID WHERE s0_.id = ? LIMIT 1 OFFSET 0' with params [5]:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON LEFT JOIN s_emotion_categories s3_ ON s0_.id = s3_.category_id LEFT JOIN s_e' at line 1 in C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php on line 119

    Stack trace:
    
        #0 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT DISTINCT...', Array)
#1 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query\Exec\SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT...', Array, Array, NULL)
#2 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#3 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php(969): Doctrine\ORM\Query->_doExecute()
#4 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php(924): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3)
#5 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php(751): Doctrine\ORM\AbstractQuery->execute(NULL, 3)
#6 C:\MAMP\htdocs\shopwaredemo\vendor\doctrine\orm\lib\Doctrine\ORM\Tools\Pagination\Paginator.php(151): Doctrine\ORM\AbstractQuery->getScalarResult()
#7 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Controllers\Backend\Category.php(167): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#8 C:\MAMP\htdocs\shopwaredemo\engine\Library\Enlight\Controller\Action.php(159): Shopware_Controllers_Backend_Category->getDetailAction()
#9 C:\MAMP\htdocs\shopwaredemo\engine\Library\Enlight\Controller\Dispatcher\Default.php(523): Enlight_Controller_Action->dispatch('getDetailAction')
#10 C:\MAMP\htdocs\shopwaredemo\engine\Library\Enlight\Controller\Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Kernel.php(182): Enlight_Controller_Front->dispatch()
#12 C:\MAMP\htdocs\shopwaredemo\vendor\symfony\http-kernel\HttpCache\HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Components\HttpCache\AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 C:\MAMP\htdocs\shopwaredemo\vendor\symfony\http-kernel\HttpCache\HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 C:\MAMP\htdocs\shopwaredemo\engine\Shopware\Components\HttpCache\AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#16 C:\MAMP\htdocs\shopwaredemo\shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#17 {main}