View Issue Details

IDProjectCategoryView StatusLast Update
0002904OXID eShop (all versions)3.1. Design, GUI, UXpublic2011-05-31 09:46
Reporterbirute_meilutyte Assigned To 
PriorityurgentSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Product VersionPast development 
Fixed in Version4.5.1 revision 38045 
Summary0002904: eShop crashes when selecting filter in category and then changing language
Descriptionsometimes all products are gone like in attached img, sometimes such error is thrown:

2011-05-19 10:21:16exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'oxv_oxarticles_1_de.oxartnum' in 'order clause'] in EXECUTE("SELECT oxv_oxarticles_1_en.oxid, oxv_oxarticles_1_en.oxparentid, oxv_oxarticles_1_en.oxvarstock, oxv_oxarticles_1_en.oxvarcount, oxv_oxarticles_1_en.oxshopid, oxv_oxarticles_1_en.oxstockflag, oxv_oxarticles_1_en.oxstock, oxv_oxarticles_1_en.oxprice, oxv_oxarticles_1_en.oxvat, oxv_oxarticles_1_en.oxskipdiscounts, oxv_oxarticles_1_en.oxunitquantity, oxv_oxarticles_1_en.oxthumb, oxv_oxarticles_1_en.oxpicsgenerated, oxv_oxarticles_1_en.oxpic1, oxv_oxarticles_1_en.oxtitle, oxv_oxarticles_1_en.oxtprice, oxv_oxarticles_1_en.oxweight, oxv_oxarticles_1_en.oxvarselect, oxv_oxarticles_1_en.oxunitname FROM oxv_oxobject2category_1 as oc left join oxv_oxarticles_1_en
                    ON oxv_oxarticles_1_en.oxid = oc.oxobjectid
                    WHERE ( oxv_oxarticles_1_en.oxactive = 1 and ( oxv_oxarticles_1_en.oxstockflag != 2 or ( oxv_oxarticles_1_en.oxstock + oxv_oxarticles_1_en.oxvarstock ) > 0 ) and IF( oxv_oxarticles_1_en.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_1_en as art where art.oxparentid=oxv_oxarticles_1_en.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) and ( ( ( select oxobjectrights.oxobjectid from oxobjectrights where oxobjectrights.oxobjectid = oxv_oxarticles_1_en.oxid and oxobjectrights.oxaction = 1 limit 1 ) is null ) ) ) and oxv_oxarticles_1_en.oxparentid = ''
                    and oc.oxcatnid = 'testcategory0' and false GROUP BY oc.oxcatnid, oc.oxobjectid ORDER BY oxv_oxarticles_1_de.oxartnum , oc.oxpos, oc.oxobjectid ")
' in /eshop/source/core/adodblite/adodb-exceptions.inc.php:84
Stack trace:
#0 /eshop/source/core/adodblite/adodbSQL_drivers/mysql/mysql_driver.inc(369): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'SELECT oxv_oxar...', false, Object(object_ADOConnection))
#1 /eshop/source/core/adodblite/adodb.inc.php(316): mysql_driver_ADOConnection->do_query('SELECT oxv_oxar...', -1, -1, false)
#2 /eshop/source/core/oxarticlelist.php(414): ADOConnection->Execute('SELECT oxv_oxar...')
#3 /eshop/source/views/alist.php(355): oxArticleList->loadCategoryArticles('testcategory0', Array)
#4 /eshop/source/views/alist.php(749): aList->_loadArticles(Object(oxCategory))
#5 /eshop/source/views/alist.php(219): aList->getArticleList()
#6 /eshop/source/views/oxshopcontrol.php(445): aList->render()
#7 /eshop/source/views/oxshopcontrol.php(303): oxShopControl->_render(Object(aList))
#8 /eshop/source/views/oxshopcontrol.php(100): oxShopControl->_process('alist', NULL)
#9 /eshop/source/index.php(100): oxShopControl->start()
#10 /eshop/source/oxseo.php(32): require('/var/www/eshop/...')
0000011 {main}
---------------------------------------------


Solution: After language switch, reset all selected filters.
TagsNo tags attached.
Attached Files
attributes.png (42,434 bytes)   
attributes.png (42,434 bytes)   
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

related to 0002899 resolvedArunas switching language with active attribute filter does not translate the filter 

Activities