Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'productAttribute.article_id' in 'field list' in /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ListProductGateway.php(66): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(104): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ListProductGateway->getList()
#5 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(90): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->getList()
#6 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sArticles.php(2309): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->get()
#7 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sArticles.php(1261): sArticles->getPromotion()
#8 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sMarketing.php(665): sArticles->sGetPromotionById()
#9 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Controllers/Frontend/Detail.php(61): sMarketing->sGetSimilarArticles()
#10 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Detail->errorAction()
#11 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch()
#12 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch()
#13 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch()
#14 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle()
#15 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#16 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#17 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward()
#18 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#19 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#20 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup()
#21 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#22 /var/www/vhosts/maschinox.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle()
#23 {main}
Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'productAttribute.article_id' in 'field list' in /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ListProductGateway.php(66): Doctrine\DBAL\Query\QueryBuilder->execute()
#4 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(104): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ListProductGateway->getList()
#5 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(90): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->getList()
#6 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sArticles.php(2309): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->get()
#7 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sArticles.php(1261): sArticles->getPromotion()
#8 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sMarketing.php(665): sArticles->sGetPromotionById()
#9 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Controllers/Frontend/Detail.php(61): sMarketing->sGetSimilarArticles()
#10 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Detail->errorAction()
#11 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch()
#12 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch()
#13 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch()
#14 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle()
#15 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#16 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#17 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward()
#18 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#19 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#20 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup()
#21 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#22 /var/www/vhosts/maschinox.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle()
#23 {main}
Next Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT product.id as __product_id, product.supplierID as __product_supplierID, product.name as __product_name, product.description as __product_description, product.description_long as __product_description_long, product.shippingtime as __product_shippingtime, product.datum as __product_datum, product.active as __product_active, product.taxID as __product_taxID, product.pseudosales as __product_pseudosales, product.topseller as __product_topseller, product.metaTitle as __product_metaTitle, product.keywords as __product_keywords, product.changetime as __product_changetime, product.pricegroupID as __product_pricegroupID, product.pricegroupActive as __product_pricegroupActive, product.filtergroupID as __product_filtergroupID, product.crossbundlelook as __product_crossbundlelook, product.notification as __product_notification, product.template as __product_template, product.mode as __product_mode, product.main_detail_id as __product_main_detail_id, product.available_from as __product_available_from, product.available_to as __product_available_to, product.configurator_set_id as __product_configurator_set_id, productAttribute.id as __productAttribute_id, productAttribute.articleID as __productAttribute_articleID, productAttribute.articledetailsID as __productAttribute_articledetailsID, productAttribute.attr1 as __productAttribute_attr1, productAttribute.attr2 as __productAttribute_attr2, productAttribute.attr3 as __productAttribute_attr3, productAttribute.attr4 as __productAttribute_attr4, productAttribute.attr5 as __productAttribute_attr5, productAttribute.attr6 as __productAttribute_attr6, productAttribute.attr7 as __productAttribute_attr7, productAttribute.attr8 as __productAttribute_attr8, productAttribute.attr9 as __productAttribute_attr9, productAttribute.attr10 as __productAttribute_attr10, productAttribute.attr11 as __productAttribute_attr11, productAttribute.attr12 as __productAttribute_attr12, productAttribute.attr13 as __productAttribute_attr13, productAttribute.attr14 as __productAttribute_attr14, productAttribute.attr15 as __productAttribute_attr15, productAttribute.attr16 as __productAttribute_attr16, productAttribute.attr17 as __productAttribute_attr17, productAttribute.attr18 as __productAttribute_attr18, productAttribute.attr19 as __productAttribute_attr19, productAttribute.attr20 as __productAttribute_attr20, productAttribute.scha1_videoposition as __productAttribute_scha1_videoposition, productAttribute.scha1_videotype as __productAttribute_scha1_videotype, productAttribute.scha1_videourl as __productAttribute_scha1_videourl, productAttribute.scha1_videopicture as __productAttribute_scha1_videopicture, productAttribute.scha1_videoposition2 as __productAttribute_scha1_videoposition2, productAttribute.scha1_videotype2 as __productAttribute_scha1_videotype2, productAttribute.scha1_videourl2 as __productAttribute_scha1_videourl2, productAttribute.scha1_videopicture2 as __productAttribute_scha1_videopicture2, productAttribute.scha1_videoposition3 as __productAttribute_scha1_videoposition3, productAttribute.scha1_videotype3 as __productAttribute_scha1_videotype3, productAttribute.scha1_videourl3 as __productAttribute_scha1_videourl3, productAttribute.scha1_videopicture3 as __productAttribute_scha1_videopicture3, productAttribute.scha1_videoposition4 as __productAttribute_scha1_videoposition4, productAttribute.scha1_videotype4 as __productAttribute_scha1_videotype4, productAttribute.scha1_videourl4 as __productAttribute_scha1_videourl4, productAttribute.scha1_videopicture4 as __productAttribute_scha1_videopicture4, productAttribute.scha1_hashorizontalorientation as __productAttribute_scha1_hashorizontalorientation, productAttribute.scha1_magnificationglas as __productAttribute_scha1_magnificationglas, productAttribute.article_id as __productAttribute_article_id, topSeller.sales as __topSeller_sales, variant.id as __variant_id, variant.ordernumber as __variant_ordernumber, variant.suppliernumber as __variant_suppliernumber, variant.kind as __variant_kind, variant.additionaltext as __variant_additionaltext, variant.sales as __variant_sales, variant.active as __variant_active, variant.instock as __variant_instock, variant.stockmin as __variant_stockmin, variant.weight as __variant_weight, variant.position as __variant_position, variant.width as __variant_width, variant.height as __variant_height, variant.length as __variant_length, variant.ean as __variant_ean, variant.unitID as __variant_unitID, variant.releasedate as __variant_releasedate, variant.shippingfree as __variant_shippingfree, variant.shippingtime as __variant_shippingtime, variant.laststock as __product_laststock, unit.id as __unit_id, unit.description as __unit_description, unit.unit as __unit_unit, variant.packunit as __unit_packunit, variant.purchaseunit as __unit_purchaseunit, variant.referenceunit as __unit_referenceunit, variant.purchasesteps as __unit_purchasesteps, variant.minpurchase as __unit_minpurchase, variant.maxpurchase as __unit_maxpurchase, tax.id as __tax_id, tax.tax as __tax_tax, tax.description as __tax_description, priceGroup.id as __priceGroup_id, priceGroup.description as __priceGroup_description, manufacturer.id as __manufacturer_id, manufacturer.name as __manufacturer_name, manufacturer.img as __manufacturer_img, manufacturer.link as __manufacturer_link, manufacturer.description as __manufacturer_description, manufacturer.meta_title as __manufacturer_meta_title, manufacturer.meta_description as __manufacturer_meta_description, manufacturer.meta_keywords as __manufacturer_meta_keywords, manufacturerAttribute.id as __manufacturerAttribute_id, manufacturerAttribute.supplierID as __manufacturerAttribute_supplierID, esd.id as __esd_id, esd.articleID as __esd_articleID, esd.articledetailsID as __esd_articledetailsID, esd.file as __esd_file, esd.serials as __esd_serials, esd.notification as __esd_notification, esd.maxdownloads as __esd_maxdownloads, esd.datum as __esd_datum, esdAttribute.id as __esdAttribute_id, esdAttribute.esdID as __esdAttribute_esdID, (SELECT 1 FROM s_articles_esd variantEsd WHERE variantEsd.articleID = product.id LIMIT 1) as __product_has_esd, (SELECT GROUP_CONCAT(customerGroups.customergroupId SEPARATOR '|') FROM s_articles_avoid_customergroups customerGroups WHERE customerGroups.articleID = product.id) as __product_blocked_customer_groups, (SELECT COUNT(availableVariant.id) FROM s_articles_details availableVariant WHERE (availableVariant.articleID = product.id) AND (availableVariant.active = 1) AND ((availableVariant.laststock * availableVariant.instock) >= (availableVariant.laststock * availableVariant.minpurchase))) as __product_has_available_variants, (SELECT COUNT(DISTINCT ROUND(prices.price, 2)) as priceCount FROM s_articles_prices prices INNER JOIN s_articles_details priceVariant ON priceVariant.id = prices.articledetailsID and priceVariant.active = 1 WHERE (prices.from = 1) AND (prices.pricegroup = ?) AND (prices.articleID = product.id)) as __product_fallback_price_count, manufacturerMedia.id as __manufacturer_img_id FROM s_articles_details variant INNER JOIN s_articles product ON product.id = variant.articleID LEFT JOIN s_core_units unit ON unit.id = variant.unitID LEFT JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id LEFT JOIN s_articles_esd esd ON esd.articledetailsID = variant.id INNER JOIN s_core_tax tax ON tax.id = product.taxID LEFT JOIN s_articles_supplier manufacturer ON manufacturer.id = product.supplierID LEFT JOIN s_core_pricegroups priceGroup ON priceGroup.id = product.pricegroupID LEFT JOIN s_articles_supplier_attributes manufacturerAttribute ON manufacturerAttribute.supplierID = product.supplierID LEFT JOIN s_articles_top_seller_ro topSeller ON topSeller.article_id = product.id LEFT JOIN s_media manufacturerMedia ON manufacturerMedia.path = manufacturer.img LEFT JOIN s_articles_esd_attributes esdAttribute ON esdAttribute.esdID = esd.id WHERE (variant.ordernumber IN (?)) AND (variant.active = 1) AND (product.active = 1)' with params ["EK", "AD-310-030TS"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'productAttribute.article_id' in 'field list' in /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79
Stack trace:
#0 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1313): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
#4 /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery()
#5 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ListProductGateway.php(66): Doctrine\DBAL\Query\QueryBuilder->execute()
#6 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(104): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ListProductGateway->getList()
#7 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/ListProductService.php(90): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->getList()
#8 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sArticles.php(2309): Shopware\Bundle\StoreFrontBundle\Service\Core\ListProductService->get()
#9 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sArticles.php(1261): sArticles->getPromotion()
#10 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Core/sMarketing.php(665): sArticles->sGetPromotionById()
#11 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Controllers/Frontend/Detail.php(61): sMarketing->sGetSimilarArticles()
#12 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Detail->errorAction()
#13 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch()
#14 /var/www/vhosts/maschinox.de/httpdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch()
#15 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch()
#16 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle()
#17 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
#18 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
#19 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward()
#20 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
#21 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
#22 /var/www/vhosts/maschinox.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup()
#23 /var/www/vhosts/maschinox.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
#24 /var/www/vhosts/maschinox.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle()
#25 {main}
thrown in /var/www/vhosts/maschinox.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 79