| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002904 | OXID eShop (all versions) | 3.1. Design, GUI, UX | public | 2011-05-19 13:56 | 2011-05-31 09:46 |
| Reporter | birute_meilutyte | Assigned To | |||
| Priority | urgent | Severity | crash | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | Past development | ||||
| Fixed in Version | 4.5.1 revision 38045 | ||||
| Summary | 0002904: eShop crashes when selecting filter in category and then changing language | ||||
| Description | sometimes 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. | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
- Anonymous
