[CE 4.8.5] "Shop offline" bei Sprachwechsel

Hi,

ich habe bei einem neuen Shop folgendes Problem:

Ich browse im deutschen, und wechsele dann in die Englische Sprache, und erhalte sofort die Meldung “Shop offline”.

Hier die Fehlermeldung im Exception Log:


oxConnectionException-oxException (time: 2014-07-28 14:15:34): [1054]: mysql:EXECUTE error: [1054: Unknown column ‘oxv_oxarticles_de.OXVARSTOCK’ in ‘order clause’] in EXECUTE with parameters SELECT oxv_oxarticles_en.oxid, oxv_oxarticles_en.oxparentid, oxv_oxarticles_en.oxvarstock, oxv_oxarticles_en.oxvarcount, oxv_oxarticles_en.oxstock, oxv_oxarticles_en.oxstockflag, oxv_oxarticles_en.oxshopid, oxv_oxarticles_en.oxvarname, oxv_oxarticles_en.oxthumb, oxv_oxarticles_en.oxtitle, oxv_oxarticles_en.oxvarselect, oxv_oxarticles_en.oxshortdesc, oxv_oxarticles_en.oxmindeltime, oxv_oxarticles_en.oxmaxdeltime, oxv_oxarticles_en.oxtprice, oxv_oxarticles_en.oxvat, oxv_oxarticles_en.oxvarminprice, oxv_oxarticles_en.oxskipdiscounts, oxv_oxarticles_en.oxprice, oxv_oxarticles_en.oxvarmaxprice, oxv_oxarticles_en.oxunitquantity, oxv_oxarticles_en.oxdeltimeunit, oxv_oxarticles_en.oxactive, oxv_oxarticles_en.oxicon, oxv_oxarticles_en.oxstocktext, oxv_oxarticles_en.oxtimestamp FROM oxobject2category as oc left join oxv_oxarticles_en
ON oxv_oxarticles_en.oxid = oc.oxobjectid
WHERE ( oxv_oxarticles_en.oxactive = 1 and ( oxv_oxarticles_en.oxstockflag != 2 or ( oxv_oxarticles_en.oxstock + oxv_oxarticles_en.oxvarstock ) > 0 ) and IF( oxv_oxarticles_en.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_en as art where art.oxparentid=oxv_oxarticles_en.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) and oxv_oxarticles_en.oxparentid = ‘’
and oc.oxcatnid = ‘6ea92d20767955bf3ec21db34fca3c44’ ORDER BY oxv_oxarticles_de.OXVARSTOCK desc , oc.oxpos, oc.oxobjectid LIMIT 0, 10, for user d0169d29

Stack Trace: #0 /xxx/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw(‘mysql’, ‘EXECUTE’, 1054, ‘Unknown column …’, ‘SELECT oxv_oxa...', false, Object(object_ADOConnection)) #1 /xxx/core/adodblite/adodb.inc.php(334): mysql_driver_ADOConnection->do_query('SELECT oxv_oxa…’, 0, 10, false)
#2 /xxx/core/oxlegacydb.php(188): ADOConnection->SelectLimit(‘SELECT oxv_oxa...', 10, 0, false) #3 /xxx/core/oxlist.php(389): oxLegacyDb->selectLimit('SELECT oxv_oxa…’, 10, 0)
#4 /xxx/application/models/oxarticlelist.php(83): oxList->selectString(‘SELECT oxv_oxa...') #5 /xxx/modules/zunderweb/z_multifilter/models/z_multifilter_oxarticlelist.php(28): oxArticleList->selectString('SELECT oxv_oxa…’)
#6 /xxx/application/controllers/alist.php(364): z_multifilter_oxarticlelist->loadCategoryArticles(‘6ea92d20767955b…’, Array)
#7 /xxx/application/controllers/alist.php(780): aList->_loadArticles(Object(oxCategory))
#8 /xxx/application/controllers/alist.php(207): aList->getArticleList()
#9 /xxx/modules/zunderweb/z_multifilter/models/z_multifilter_alist.php(113): aList->render()
#10 /xxx/core/oxshopcontrol.php(465): z_multifilter_alist->render()
#11 /xxx/core/oxshopcontrol.php(350): oxShopControl->_render(Object(z_multifilter_alist))
#12 /xxx/modules/_d3modcfg/modules/controllers/d3_oxshopcontrol_modcfg_extension.php(0): oxShopControl->_process(‘alist’, NULL, NULL, NULL)
#13 /xxx/core/oxshopcontrol.php(123): d3_oxshopcontrol_modcfg_extension->_process(‘alist’, NULL, NULL, NULL)
#14 /xxx/modules/_d3modcfg/modules/controllers/d3_oxshopcontrol_modcfg_extension.php(0): oxShopControl->start(NULL, NULL, NULL, NULL)
#15 /xxx/core/oxid.php(38): d3_oxshopcontrol_modcfg_extension->start()
#16 /xxx/index.php(27): OXID::run()
#17 /xxx/oxseo.php(44): require(‘/xxx…’)
#18 {main}

Connection Adress –>
Connection Error –>

Für einige Kategorien ist als Schnellsortierung “Lagerbestand” angegeben, ich schätze, dass es anhand der Fehlermeldung wohl damit zusammenhängt…

Schöne Grüße

Lars

Laut https://bugs.oxid-esales.com/view.php?id=5631 ist das in 4.8.6 behoben.

Nope, Problem bleibt besetehen…

Interessante Randnotiz: Das Problem tritt ausschließlich im Firefox auf.

Cookies auch gelöscht?

Das wars, danke!