Nach dem Update von 5.3.7 auf 5.4.1 funktioniert mein Produktexport für Idealo nicht mehr. Hier die Meldung, die mir nicht wirklich weiterhilft. In welcher Tabelle soll die Spalte areld.ordernumber fehlen? Wo ist dies definiert? Das Feld ordernumber ist ja nicht weg und befindet sich in „s_articles_details.ordernumber“ so weit ich prüfen konnte.
Ups! Ein Fehler ist aufgetreten!
Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'areld.ordernumber' in 'field list' in engine/Library/Zend/Db/Statement/Pdo.php on line 224
Stack trace:
"#0 engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#1 engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)
#2 engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('\n SE...', Array)
#3 engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('\n SE...', Array)
#4 engine/Shopware/Core/sExport.php(1052): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n SE...')
#5 engine/Shopware/Controllers/Backend/Export.php(133): sExport->executeExport(Resource id #632)
#6 engine/Shopware/Controllers/Backend/Export.php(90): Shopware_Controllers_Backend_Export->generateExport('var/...')
#7 engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_Export->indexAction()
#8 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch('indexAction')
#9 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#10 engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch()
#11 vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#12 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#14 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#15 shopware.php(118): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#16 {main}"
Hier die Feed-Konfiguration
{strip}
{$sArticle.articleID|category:">"|escape|replace:"|":""}{#S#}
{$sArticle.supplier|replace:"|":""}{#S#}
{$sArticle.name|strip_tags|strip|trim|html_entity_decode|escape}{#S#}
{$sArticle.price|escape:"number"}{#S#}
{#S#}
{$sArticle.ean|escape}{#S#}
{#S#}
{#S#}
{$sArticle|@shippingcost:"cash":"de":"Deutsche Post Standard"|escape:"number"}{#S#}
{$sArticle|@shippingcost:"prepayment":"de":"Deutsche Post Standard"|escape:"number"}{#S#}
{$sArticle|@shippingcost:"debit":"de":"Deutsche Post Standard"|escape:"number"}{#S#}
{$sArticle.articleID|link:$sArticle.name|replace:"|":""}{#S#}
{if $sArticle.instock}2 Tage{elseif $sArticle.shippingtime}{$sArticle.shippingtime|escape} Tage{else}10 Tage{/if}{#S#}
{$sArticle.ordernumber|replace:"|":""}{#S#}
{$sArticle.image|image:2}{#S#}
{$sArticle.description_long|strip_tags|strip|trim|truncate:300:"...":true|escape}{#S#}
{if $sArticle.instock>5}5{else}{$sArticle.instock|escape}{/if}{#S#}
{/strip}{#L#}