Hey, nachdem mein Shop nach dem Umzug nun endlich “läuft”, habe ich noch ein Problem, dass sich die Artikeldetails nicht öffnen lassen.
Das Expcetion_log sagt dazu:
oxConnectionException-oxException (time: 2015-12-04 13:43:17): [1176]: mysql error: [1176: Key 'oxartid' doesn't exist in table 'd'] in EXECUTE (select distinct oxarticles.* from (
select d.oxorderid as suborderid from oxorderarticles as d use index ( oxartid ) where d.oxartid in ( '6e529379cf4f1940e3586bec7700d7b8' , '38c9a30f50c761e98c522175b1d8c567' , '974115aebeef17b1cb3b0d5351441c0a' , 'cad3049b26ed78bef4717d0647c4f0fb' ) limit 50
) as suborder
left join oxorderarticles force index ( oxorderid ) on suborder.suborderid = oxorderarticles.oxorderid
left join oxarticles on oxarticles.oxid = oxorderarticles.oxartid
where oxarticles.oxid not in ( '6e529379cf4f1940e3586bec7700d7b8' , '38c9a30f50c761e98c522175b1d8c567' , '974115aebeef17b1cb3b0d5351441c0a' , 'cad3049b26ed78bef4717d0647c4f0fb' )
and ( oxarticles.oxissearch = 1 or oxarticles.oxparentid <> '' ) and ( oxarticles.oxactive = 1 and ( oxarticles.oxstockflag != 2 or ( oxarticles.oxstock + oxarticles.oxvarstock ) > 0 ) and IF( oxarticles.oxvarcount = 0, 1, ( select 1 from oxarticles as art where art.oxparentid=oxarticles.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) LIMIT 0, 5, ) with user db54034
Stack Trace: #0 /WWWROOT/245055/htdocs/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw('mysql', 'EXECUTE', 1176, 'Key 'oxartid' d...', 'select distinct...', false, Object(object_ADOConnection))
#1 /WWWROOT/245055/htdocs/core/adodblite/adodb.inc.php(334): mysql_driver_ADOConnection->do_query('select distinct...', 0, '5', false)
#2 /WWWROOT/245055/htdocs/core/oxlegacydb.php(184): ADOConnection->SelectLimit('select distinct...', '5', 0, false)
#3 /WWWROOT/245055/htdocs/core/oxlist.php(384): oxLegacyDb->selectLimit('select distinct...', '5', 0)
#4 /WWWROOT/245055/htdocs/application/models/oxarticlelist.php(79): oxList->selectString('select distinct...')
#5 /WWWROOT/245055/htdocs/application/models/oxarticle.php(1321): oxArticleList->selectString('select distinct...')
#6 /WWWROOT/245055/htdocs/application/components/widgets/oxwarticledetails.php(758): oxArticle->getCustomerAlsoBoughtThisProducts()
#7 /WWWROOT/245055/htdocs/tmp/smarty/666f58db7c1a249da3d7e6bb435aceec^%%A5^A59^A595DDB8%%fullproductinfo.tpl.php(19): oxwArticleDetails->getAlsoBoughtTheseProducts()
#8 /WWWROOT/245055/htdocs/core/smarty/Smarty.class.php(1870): include('/WWWROOT/245055...')
#9 /WWWROOT/245055/htdocs/tmp/smarty/666f58db7c1a249da3d7e6bb435aceec^%%79^790^7907FF72%%details.tpl.php(88): Smarty->_smarty_include(Array)
#10 /WWWROOT/245055/htdocs/core/smarty/Smarty.class.php(1264): include('/WWWROOT/245055...')
#11 /WWWROOT/245055/htdocs/core/oxshopcontrol.php(508): Smarty->fetch('widget/product/...', 'ox|0|0|0|0')
#12 /WWWROOT/245055/htdocs/core/oxshopcontrol.php(353): oxShopControl->_render(Object(oxwArticleDetails))
#13 /WWWROOT/245055/htdocs/core/oxshopcontrol.php(126): oxShopControl->_process('oxwarticledetai...', NULL, Array, Array)
#14 /WWWROOT/245055/htdocs/core/oxwidgetcontrol.php(73): oxShopControl->start('oxwarticledetai...', NULL, Array, Array)
#15 /WWWROOT/245055/htdocs/core/smarty/plugins/function.oxid_include_widget.php(56): oxWidgetControl->start('oxwarticledetai...', NULL, Array, Array)
#16 /WWWROOT/245055/htdocs/tmp/smarty/666f58db7c1a249da3d7e6bb435aceec^%%08^08A^08ABD53A%%details.tpl.php(10): smarty_function_oxid_include_widget(Array, Object(Smarty))
#17 /WWWROOT/245055/htdocs/core/smarty/Smarty.class.php(1264): include('/WWWROOT/245055...')
#18 /WWWROOT/245055/htdocs/core/oxshopcontrol.php(508): Smarty->fetch('page/details/de...', 'ox|0|0|0|0|6e52...')
#19 /WWWROOT/245055/htdocs/core/oxshopcontrol.php(353): oxShopControl->_render(Object(oeThemeSwitcherDetails))
#20 /WWWROOT/245055/htdocs/core/oxshopcontrol.php(126): oxShopControl->_process('details', NULL, NULL, NULL)
#21 /WWWROOT/245055/htdocs/core/oxid.php(40): oxShopControl->start()
#22 /WWWROOT/245055/htdocs/index.php(26): Oxid::run()
#23 /WWWROOT/245055/htdocs/oxseo.php(44): require('/WWWROOT/245055...')
#24 {main}
Connection Adress -->
Connection Error -->
---------------------------------------------
Dennoch versteh ich nicht wieso es die Spalte ‘oxartid’ nicht finden kann. Die ist definitiv da